Google Sheets-Google Sheets - Quick Reference Card

Google Sheets - Quick Reference Card

Pdf Summary

This document is a Google Sheets Quick Reference guide covering core tasks, screen elements, and common keyboard shortcuts. It explains how to create, open, rename, star, copy, move, delete, and print spreadsheets from Google Drive and the File menu. It also points users to Help resources via the Help menu and Sheets Help search.<br /><br />For editing, it describes selecting cells, rows, and columns; entering and modifying data; copying, cutting, and pasting (including paste values only); inserting rows or columns; moving cell ranges by dragging; deleting cells; hiding/unhiding rows and columns; and using Find and replace to locate or update text. Spell check instructions are included under the Tools menu.<br /><br />Formatting topics include changing font, size, text color, alignment (horizontal and vertical), merging cells, wrapping text, adding borders, applying number formats (date, time, currency, decimals), freezing rows/columns, and copying formatting with the paint format tool. It also outlines how to create conditional formatting rules based on specified conditions.<br /><br />The formulas/functions section shows how to create formulas using cell references and operators, insert functions from the Insert > Function menu, and use common functions such as SUM, MIN, MAX, and COUNT. It also explains AutoFill for completing series and naming ranges via Data > Named ranges.<br /><br />Sheet and data management includes inserting, renaming, deleting, hiding, and moving sheets; sorting columns; and filtering data with Create a filter.<br /><br />Finally, it covers inserting objects (charts, images, links), modifying charts, and collaboration features such as downloading or emailing a spreadsheet, sharing with permissions, adding/replying to comments, and viewing/restoring version history. A list of key keyboard shortcuts for navigation, editing, and formatting is provided.

Keywords

Google Sheets quick reference

spreadsheet keyboard shortcuts

Google Drive file management

cell editing and selection

copy paste values only

find and replace

conditional formatting rules

formulas and functions (SUM MIN MAX COUNT)

sorting and filtering data

sharing permissions and version history