lazur
Download

Google Sheets for Mac

Google Sheets how-to guides

Every Google Sheets guide we have, newest first. Each one lists the menu path, the shortcut and what to do when it does not work.

24 guides

Lazur in Google Sheets →
Person working at a laptop with a spreadsheet open, the kind of list where you add a filter in Google Sheets on MacEasy · 3 minHow to add a filter in Google Sheets on Mac to one range: step by stepHow to add a filter in Google Sheets on Mac: select your range, then go to Data > Create a filter. Hide rows by value, condition, or color.Person at a Mac laptop checking a spreadsheet, the kind of list where you count unique values in Google Sheets on MacEasy · 10 minHow to count unique values in Google Sheets on Mac: formulas and steps for ChromeLearn how to count unique values in Google Sheets on Mac with COUNTUNIQUE and Remove duplicates. Browser steps, Mac shortcuts, and fixes.Person at a Mac laptop working on a spreadsheet, the kind of sheet that needs a dropdown listEasy · 5 minHow to create a dropdown list in Google Sheets on Mac: steps for ChromeLearn how to create a dropdown list in Google Sheets on Mac in Chrome, with menu steps, shortcuts, display styles, and fixes for common errors.Person at a laptop reviewing a spreadsheet before they download it as Excel on a MacEasy · 3 minStep by step: how to download google sheets as excel on mac in 2026Learn how to download google sheets as excel on mac: open File, choose Download, pick Microsoft Excel (.xlsx). Includes fixes for a greyed-out menu.Person at a Mac exporting a Google Sheets file as PDF from the browserEasy · 5 minHow to export google sheets as pdf on mac: steps for Chrome, Safari, and FirefoxHow to export google sheets as pdf on mac: File > Print in Chrome, Safari, or Firefox, plus fixes for cut-off columns and greyed-out buttons.Person working on a laptop at a desk with a spreadsheet open, the setting for how to find and replace in Google Sheets on Mac.Easy · 8 minHow to find and replace in Google Sheets on Mac, step by step for ChromeLearn how to find and replace in Google Sheets on Mac with ⌘ ⇧ H, the Edit menu, regex options, and a safe Replace all check.A person at a Mac laptop reviewing a spreadsheet before they freeze columns in Google Sheets on MacEasy · 3 minHow to freeze columns in Google Sheets on Mac: steps and how to undo itLearn how to freeze columns in Google Sheets on Mac from the View menu, plus how to unfreeze them and fix the common problems that stop them staying put.Person at a laptop learning how to freeze the top row in Google Sheets on MacEasy · 2 minHow to freeze the top row in Google Sheets on Mac, in Chrome or SafariHow to freeze the top row in Google Sheets on Mac: select row 1, then choose View > Freeze > 1 row. Works in Chrome or Safari.Person at a MacBook reviewing a spreadsheet, the kind of work where you learn how to hide rows and columns in Google Sheets on MacEasy · 3 minHow to hide rows and columns in Google Sheets on Mac: browser steps and shortcutsHow to hide rows and columns in Google Sheets on Mac with the right-click menu, ⌘ ⌥ 9, and ⌘ ⌥ 0. Covers unhiding and the filter trap.Person working on a spreadsheet on a laptop, the kind of data you bring in when you import a CSVEasy · 5 minHow to import csv into google sheets on mac: the File menu steps, with fixesLearn how to import csv into google sheets on mac: open File > Import, pick your CSV, set the separator, and click Import. Steps for the browser app.Person working at a laptop on a spreadsheet, the usual setting for insert a row above in Google Sheets on MacEasy · 2 minHow to insert a row above in Google Sheets on Mac: keyboard and menu stepsInsert a row above in Google Sheets on Mac with ⌘ ⌥ =, the right-click menu, or the Insert menu. Steps, fixes for failed shortcuts, and where Lazur helps.Person at a desk working on a laptop, learning how to make a chart in Google Sheets on MacEasy · 10 minHow to make a chart in Google Sheets on Mac: steps for Chrome and SafariLearn how to make a chart in Google Sheets on Mac: select your cells, use Insert > Chart, then change the type, range and titles.Person on a Mac learning how to merge cells in Google Sheets in a browser windowEasy · 5 minHow to merge cells in Google Sheets on Mac: step by step in ChromeHow to merge cells in Google Sheets on Mac: open Format > Merge cells, pick a merge type, and unmerge safely. Covers data loss and sorting errors.Person at a Mac laptop checking a spreadsheet before they remove duplicate rows in Google SheetsEasy · 5 minHow to remove duplicate rows in Google Sheets on Mac: step by step with fixesLearn how to remove duplicate rows in Google Sheets on Mac using Data > Data cleanup > Remove duplicates. Steps, Mac shortcut, and fixes when it fails.Person at a desk reviewing a spreadsheet on a laptop, the kind of check you do before restoring a fileEasy · 5 minHow to see revision history in Google Sheets on Mac: steps for the browser appHow to see revision history in Google Sheets on Mac: click Last edit, pick a version, then restore it or make a copy. Shortcut ⌘ ⌥ ⇧ H.Person working on a laptop with a spreadsheet open, the setting where you learn keyboard shortcuts in Google Sheets on MacEasy · 2 minHow to show keyboard shortcuts in Google Sheets on Mac: step by step, with fixesLearn how to show keyboard shortcuts in Google Sheets on Mac: press ⌘ /, open the full list from Help, and fix shortcuts that do not respond.Person working on a Mac laptop at a desk, the setting where people sort data by column in Google SheetsEasy · 5 minHow to sort data by column in Google Sheets on Mac: step by step in ChromeHow to sort data by column in Google Sheets on Mac: right-click a column letter to sort a whole sheet, or use Data > Sort range for part of one.Person working on a laptop at a desk, reviewing a spreadsheet of text rows before splitting text into columnsEasy · 5 minHow to split text into columns in Google Sheets on Mac: browser steps and fixesHow to split text into columns in Google Sheets on Mac: choose Data > Split text to columns, pick a separator, and fix the common problems.Person working on a MacBook with a spreadsheet open in a browser windowEasy · 3 minHow to switch between sheet tabs in Google Sheets on Mac: shortcuts and clicksLearn how to switch between sheet tabs in Google Sheets on Mac with Option + arrow keys, the sheet list, and clicks in your browser.Person at a Mac laptop checking a sheet, the setting for how to unfreeze rows and columns in Google Sheets on MacEasy · 3 minHow to unfreeze rows and columns in Google Sheets on Mac: step by stepLearn how to unfreeze rows and columns in Google Sheets on Mac with View > Freeze, plus what to do when both are frozen and the menu won't respond.Person working on a Mac laptop at a desk, reviewing rows in a spreadsheetMedium · 10 minHow to use conditional formatting in Google Sheets on Mac: rules, formulas and fixesLearn how to use conditional formatting in Google Sheets on Mac, with exact menu paths, custom formulas, rule order and fixes that work in the browser.A person at a Mac laptop learning how to use SUMIF in Google Sheets on MacEasy · 10 minHow to use SUMIF in Google Sheets on Mac: step by step with examplesHow to use SUMIF in Google Sheets on Mac: write the formula, use number and text criteria, and fix errors. Steps for Chrome, with shortcuts.Person at a Mac laptop working in a spreadsheet, learning how to use tool finder in Google Sheets on MacEasy · 5 minHow to use tool finder in Google Sheets on Mac: shortcut, steps, and fixesLearn how to use tool finder in Google Sheets on Mac: press Option + /, type a task, and pick the match. Includes fixes when it fails.Person at a Mac laptop learning how to use VLOOKUP in Google Sheets on MacMedium · 15 minHow to use VLOOKUP in Google Sheets on Mac: a browser walkthrough with fixesLearn how to use VLOOKUP in Google Sheets on Mac, step by step. Covers the exact match formula, menu paths, shortcuts and fixes for #N/A errors.