Guides for working with rows and cells, formatting, formulas, charts and sharing in Google Sheets.
Rows, columns and cells
Freeze and hide rows and columns, merge cells, wrap text and manage sheet tabs.
- How to Freeze Columns (or Rows) in Google Sheets
- How to Make a Header Row in Google Sheets
- How to Insert a Row in Google Sheets
- How to Hide and Unhide a Column in Google Sheets
- How to Merge Cells in Google Sheets (and Unmerge Them)
- How to Change Row Height in Google Sheets
- How to Wrap Text in Google Sheets
- How to Rename, Add, or Hide a Sheet Tab in Google Sheets
Formatting
Color cells, add borders, change fonts and format currency.
- How to Make Cells Red if a Number Is Less Than Zero in Google Sheets
- How to Remove (or Add) Fill Color in Google Sheets
- How to Add Borders in Google Sheets
- How to Left Align Numbers in Google Sheets
- How to Use Larger Font Sizes in Google Sheets
- How to Clear Contents or Formatting in Google Sheets
- How to Use Currency Formatting in Google Sheets (and Remove the Dollar Sign)
Formulas, data and charts
Look up values, show formulas, filter data and make graphs.
- How to Use VLOOKUP in Excel or Google Sheets
- How to Show Formulas in Google Sheets
- How to Change Calculation Settings in Google Sheets (Including Iterative Calculation)
- How to Create a Filter in Google Sheets
- How to Make a Graph in Google Sheets
- How to Insert a Google Sheets Chart Into a Google Docs Document
- How to Turn Off Autocomplete in Google Sheets
Files, sharing and printing
Download, share, publish and print sheets, and restore older versions.
- How to Convert a Google Sheet to PDF, Excel, or CSV
- How to Print a Google Sheet on One Page
- How to Publish a Google Sheet to the Web as a PDF
- How to Share or Unshare a Google Sheets File (Get a Link)
- How to Create a New Google Sheets Spreadsheet in Google Drive
- How to Remove Sheet Protection (Permissions) in Google Sheets
- How to Restore an Older Version of a Google Sheets File
- How to Remove Comments and Notes From Google Sheets
- How to Add a Hyperlink in Google Sheets
- How to Insert a Picture in Google Sheets
- How to Embed Google Sheets in WordPress
- How to Unhide the Menu in Google Sheets
- How to View or Hide Gridlines in Google Sheets on an iPhone