Google Sheets Reference and Cheat Sheet: The unofficial cheat sheet reference for Google's free online spreadsheet application

Description

Whether you are just getting started with Google Sheets, switching from Microsoft Excel, or need a fast desk reference for everyday spreadsheet tasks, this four-panel desk reference gives you instant answers without searching through help menus or Google support pages. Who this is for: Home users, students, office workers, teachers, and anyone using Google Sheets for budgets, data tracking, calculations, or collaboration — including those transitioning from Microsoft Excel to Google Sheets on Windows, macOS, or ChromeOS. Topics covered: Overview of the Google Sheets main screen, including annotated screenshots of the interface and formatting toolbar How to create, rename, save, close, and copy spreadsheets How to edit Google Sheets spreadsheets while offline How to add rows and columns, and how to delete, cut, and clear data How to hide and unhide rows and columns How to import .xls, .xlsx, .csv, .tsv, and .txt files into Google Sheets How to export spreadsheets to .xlsx, PDF, .csv, and other formats Basic formulas including addition, subtraction, multiplication, division, and order of operations Common functions including SUM, AVERAGE, COUNT, MIN, MAX, NOW, and SQRT How to use Autofill to create a series of numbers, dates, or formulas How to freeze rows and columns How to sort and filter data How to create charts and graphs including pie charts, bar charts, and scatter plots Complete formatting toolbar guide including fonts, alignment, borders, fill color, merge cells, text wrapping, and number formats Keyboard shortcuts for Google Sheets on Windows, ChromeOS, and macOS What's covered — panel by panel: Panel 1 — The Google Sheets main screen and spreadsheet basics Annotated guide to the Google Sheets main screen at sheets.google.com, including the menu, Google apps waffle icon, list and grid view, AZ sort button, file picker, and how to identify imported Excel files versus native Sheets files. How to create a new spreadsheet from scratch or from a template. How to rename, save, close, and copy spreadsheets. How to edit spreadsheets offline. How to import .xls, .xlsx, .csv, .tsv, and .txt files. How to export to .xlsx, PDF, .csv, .tsv, OpenDocument, and other formats. Panel 2 — Formatting toolbar, formulas, and functions Complete guide to every icon in the Google Sheets formatting toolbar, including undo, redo, print, paint format, zoom, currency, percentage, decimal places, fonts, font decoration, font color, fill color, borders, merge cells, alignment, text wrapping, link, comment, insert chart, filter, and functions. Basic formula examples using cell references and PEMDAS order of operations. Common function examples including SUM, AVERAGE, COUNT, MIN, MAX, NOW, and SQRT. How to freeze a row or column. Panel 3 — Data, charts, and worked examples How to add rows and columns above, below, left, and right. How to insert multiple rows or columns at once. How to delete, cut, and clear data and formatting. How to hide and unhide columns and rows. How to create a chart or graph from selected data including pie charts, bar charts, and scatter plots, and how to customize chart type, title, colors, and fonts. Step-by-step worked examples for addition using SUM, calculating an average using AVERAGE, creating a series with Autofill, and isolating data with sort and filter. Panel 4 — Keyboard shortcuts Comprehensive keyboard shortcut reference for Google Sheets on Windows, ChromeOS, and macOS. Covers basic shortcuts, Google Sheets actions, moving and selecting cells, formatting shortcuts, and menus and navigation shortcuts. Key features: Covers Google Sheets for Windows, macOS, and ChromeOS Includes Microsoft Excel file import and export instructions for .xls and .xlsx formats Worked examples for formulas, functions, Autofill, sorting, filtering, and charting Annotated screenshots for easy at-a-glance reference Updated 2025 edition Physical dimensions: 11 x 8.5 x 0.2 inches, printed on durable card stock Holes for three-ring binders; designed to sit on a desk, hang on a wall, or fit in a binder Fully recyclable and created by the publisher of the award-winning IN 30 MINUTES guides Frequently asked questions: Is this laminated? It is printed on durable card stock, not laminated, and designed for repeated desk use. Is this for beginners? Yes — it is specifically designed for home users, students, and office workers who are new to Google Sheets or who need a quick reference for everyday spreadsheet tasks. Can it be used with older versions of Google Sheets? Yes — the core features, formulas, functions, and keyboard shortcuts covered in this reference apply to all current versions of Google Sheets. Does it cover Microsoft Excel file formats? Yes — it includes instructions for importing .xls and .xlsx files into Google Sheets and exporting Google Sheets files back to .xlsx format. Does it cover formulas and functions? Yes — it includes basic formula examples using cell references and order of operations, plus worked examples for SUM, AVERAGE, COUNT, MIN, MAX, NOW, and SQRT. Does it cover keyboard shortcuts? Yes — it includes a comprehensive keyboard shortcut reference for Google Sheets on Windows, ChromeOS, and macOS covering basic shortcuts, navigation, formatting, and menu access. Does it cover charts and graphs? Yes — it includes step-by-step instructions for creating pie charts, bar charts, scatter plots, and other chart types, and how to customize chart titles, colors, and fonts. Review: Valuable information listed in easy to understand format - Love all the information listed Review: Great tool. - A great tool to keep by my computer when I need a little help