How-to basics
Everyday tasks: sorting, filtering, formatting, printing, shortcuts.
- Google Sheets Apps Script Documentation: How to Use ItGoogle Sheets Apps Script documentation is available in Google’s official Apps Script developer documentation, especially the Spreadsheet service reference at developers.google.com/apps-script/reference/spreadsheet. It…
- Google Sheets Apps Script Not Opening? Fixes to TryIf Apps Script is not opening from Google Sheets, open the spreadsheet in a desktop web browser and select Extensions > Apps…
- Google Sheets Conditional Formatting: How to Apply RulesYes. Google Sheets includes conditional formatting, which automatically changes a cell’s appearance when its value or a formula meets a condition. In…
- Google Sheets Data Validation: How to Set It Up EasilyYes. In Google Sheets in a web browser, select the cells, choose Data > Data validation, then click Add rule to set…
- Google Sheets: Check Whether a Value Is in a RangeYes. In Google Sheets, check whether a value appears anywhere in a range with =COUNTIF(A2:A20,D2)>0. It returns TRUE if the value in…
- Google Sheets Apps Script If Statements: How They WorkIn Google Sheets Apps Script, an if statement runs code only when a condition is true; use else or else if to…
- Google Sheets Alphabetize Function: Sort Data A to ZGoogle Sheets does not have a function named ALPHABETIZE; use the SORT function to create an alphabetized result, or use the Data…
- Google Sheets and Power Query: How They Work TogetherGoogle Sheets does not include Microsoft Power Query, so you cannot open a Power Query editor or refresh a Power Query connection…
- Google Sheets: How to Sort by Last NameYes. Google Sheets can alphabetize a list by last name, but it does not automatically identify surnames inside a full-name cell. Add…
- Google Sheets Alphabetize a Column: A Practical GuideTo alphabetize a column in Google Sheets, select a cell in your data and choose Data > Sort sheet > Sort sheet…
- Google Sheets: How to Add Up a Column of NumbersIf your numbers are in B2:B10, enter =SUM(B2:B10) in an empty cell to add them; Google Sheets displays the total there. Replace…
- Google Sheets Add Timestamp When a Cell ChangesYes. To add a fixed timestamp when a cell changes in Google Sheets, use a small Apps Script attached to the spreadsheet;…
- Google Sheets: Add a Filter to a Column and Sort RowsTo add a filter in Google Sheets, select the data range, including its header row, then choose Data > Create a filter.…
- Google Sheets Add Item to Dropdown: Steps and TipsTo add an item to a Google Sheets dropdown, select a cell that uses the dropdown, open Data > Data validation, choose…
- Google Sheets Absolute Value of a Percentage FormulaTo get the absolute value of a percentage in Google Sheets, use =ABS(A2), assuming A2 contains the percentage. The result is the…
- Google Sheets: Add Checkboxes to Cells and Use ThemTo add a checkbox in Google Sheets, select the cell or range, then choose Insert > Checkbox. Click a box to check…
- Google Sheets Date Dropdown: Add a Calendar PickerYes. In Google Sheets in a web browser, select the cell, choose Data > Data validation, add a rule with the Date…
- Google Sheets 2D SUMIF: Sum Values by Row and ColumnGoogle Sheets has no built-in 2D SUMIF function, but you can sum a table by matching a row label and a column…
- Google Sheets Absolute Percentage: Formulas and ExamplesTo return the absolute value of a percentage in Google Sheets, use =ABS(A2); to calculate the size of a percentage change between…
- Google Sheets Percentage: Show 2 Decimal Places EasilyTo show percentages with two decimal places in Google Sheets, select the cells, choose Format > Number > Percent, then click Increase…
- Google Sheets 2D Conditional Formatting: A Practical GuideGoogle Sheets can apply conditional formatting across a two-dimensional range: select the cells, open Format > Conditional formatting, and use a color…
- Google Sheets 2D Data Validation: How to Set It UpGoogle Sheets does not have a special “2D data validation” rule that reads a grid and automatically chooses a dropdown list from…
- Google Finance Codes for Sheets: Tickers and ExamplesIn Google Sheets, “Google Finance codes” usually means the ticker symbol and, when needed, its exchange prefix used by GOOGLEFINANCE. For example,…
- Google Gradebook Spreadsheet: Build One in Google SheetsA Google gradebook spreadsheet is a grade-tracking table you create in Google Sheets; it is not a separate Google product. To make…
- Google Sheets: Show Percentages to 2 Decimal PlacesTo show percentages with two decimal places in Google Sheets, select the cells and choose Format > Number > Percent, then use…
- Google Docs Employee Schedule Template: Create and Share ItYes. You can make a Google Docs employee schedule template by inserting a table, adding dates and shift details, and saving a…
- Google Docs Monthly Budget Template: Free Ways to StartYes, you can make a monthly budget for free with Google’s tools, but a budget with totals and calculations is usually better…
- Google Sheets Budget Spreadsheet: Setup and FormulasA Google Sheets budget spreadsheet is a reusable table for recording income, planned spending, and actual spending, with formulas that total the…
- Google Debt Snowball Spreadsheet: Build One in SheetsYes. You can build a debt snowball spreadsheet in Google Sheets by listing each debt, sorting debts from the smallest balance to…
- Google Apps Script for Sheets: Automation and SetupGoogle Apps Script is Google’s cloud-based JavaScript platform for automating Google Sheets and connecting it with other Google services. In a spreadsheet,…