Tag: sheets
Google Sheets want to use AI to flag and fix your mistakes
Google brings machine learning to online spreadsheets with Simple ML for Sheets
How to create a calendar in Google Sheets
Xi Jinping’s censors overwhelmed as they scrub rebels’ blank sheets of paper from the Internet
Alation’s Connected Sheets brings data governance to spreadsheets
How to Create a Combo Chart in Google Sheets
Picking out the best chart for effectively displaying related data isn’t always easy. Using a combo chart in Google Sheets, you can take advantage of two charts combined for the ideal visual.
Read This Article on How-To Geek ›
How to Add a Trendline in Google Sheets
If you want a simple visual to help your audience see the direction of the data in your chart, consider a trendline. You can add different types of trendlines in Google Sheets and customize their appearance.
Read This Article on How-To Geek ›
Best Black Friday Bed Accessory Deals: Save on Sheets, Pillows and Even Dog Beds – CNET
Google Sheets power tips: How to use dropdown lists
Google Sheets lets you design spreadsheets with sophisticated features, and one of the most useful to know is dropdown lists. You can add a dropdown list to a cell (or to a range of cells), and when you or another person with access to your spreadsheet clicks the cell, a dropdown will open that shows a list of numbers or words that they can select. The number or word that’s selected will then appear inside the cell.
Some use case examples:
- You need co-workers to enter very specific numbers or words into your spreadsheet. Providing dropdown lists makes this more convenient for them and eliminates the risk of mistyped entries.
- You add a dropdown list containing number presets that immediately change a chart embedded on your spreadsheet.
- You create a spreadsheet to track a project, in which co-workers select their work progress status from a dropdown list.
You can create two kinds of dropdown lists in Google Sheets: The first lists specific numbers or words that you’ve entered as preset choices, while the second lists data that currently appears in a range of cells in your spreadsheet. This guide walks you through the basic steps of creating both types of dropdowns and adding color to them.