How to Freeze Columns (or Rows) in Google Sheets
To freeze columns in Google Sheets on a computer, click a cell in the last column you want to keep on screen, then click View …
Google Sheets How-To Guides
Visit our collection of articles and tutorials that can help you improve your Google Sheets spreadsheets and fix problems you may be experiencing.
Not sure where to start? Check out our featured Google Sheets guides below:
- How to Wrap Text in Google Sheets – change the way that text is laid out in the cells of your spreadsheet.
- How to Subtract in Google Sheets – use a formula to subtract one cell or value from another one.
- How to Make Google Sheets Alphabetical Order – learn how to sort your spreadsheet alphabetically by one of the columns in the file.
How to Make a Header Row in Google Sheets
To make a header row in Google Sheets, type a label for each column in row 1, then click View > Freeze > 1 row. …
How to Convert a Google Sheet to PDF, Excel, or CSV
To convert a Google Sheet to a PDF, open it on a computer and click File > Download > PDF (.pdf), pick what to export …
How to Make Cells Red if a Number Is Less Than Zero in Google Sheets
To make cells turn red when a number is less than zero in Google Sheets, select the cells, click Format > Conditional formatting, set Format …
How to Embed Google Sheets in WordPress
To embed a Google Sheet in WordPress, open the sheet and click File > Share > Publish to web. Click the Embed tab, choose the …
How to Insert a Picture in Google Sheets
To insert a picture in Google Sheets, click a cell, click Insert > Image, choose whether the picture goes in the cell or over the …
How to View or Hide Gridlines in Google Sheets on an iPhone
To view or hide gridlines in Google Sheets on an iPhone, open the spreadsheet in the Sheets app, tap the name of the sheet tab …
How to Wrap Text in Google Sheets
To wrap text in Google Sheets, select the cells, click the Text wrapping button in the toolbar (or choose Format > Wrapping), and choose Wrap. …
How to Remove (or Add) Fill Color in Google Sheets
To remove fill color in Google Sheets, select the colored cells, click the Fill color button (the paint bucket) in the toolbar, and click Reset …
How to Add Borders in Google Sheets
To add borders in Google Sheets, select the cells, click the Borders button in the toolbar, and choose where the lines go, such as all …
How to Left Align Numbers in Google Sheets
Google Sheets puts numbers on the right side of a cell by default. To move them to the left, select the cells and click Format …
How to Hide and Unhide a Column in Google Sheets
To hide a column in Google Sheets, right-click the column letter and choose Hide column. To unhide it, click either of the small arrows that …
How to Turn Off Autocomplete in Google Sheets
To turn off autocomplete in Google Sheets on a computer, open your spreadsheet and click Tools > Suggestion controls, then click Enable autocomplete to remove …
How to Merge Cells in Google Sheets (and Unmerge Them)
To merge cells in Google Sheets, select the cells, click Format > Merge cells, and choose Merge all, Merge horizontally, or Merge vertically. To split …
How to Make a Graph in Google Sheets
To make a graph in Google Sheets, select the cells with your data (including the header row), then click Insert > Chart. Sheets adds a …
How to Print a Google Sheet on One Page
To print a Google Sheet on one page, click File > Print, open the Scale menu in the print settings, and choose Fit to page. …
How to Change Row Height in Google Sheets
To change row height in Google Sheets, right-click the row number on the left side of the sheet, click Resize row, type a height in …
How to Change Calculation Settings in Google Sheets (Including Iterative Calculation)
To change calculation settings in Google Sheets, click File > Settings, open the Calculation tab, choose Automatic or Manual under Calculation Mode, turn on Iterative …
How to Publish a Google Sheet to the Web as a PDF
To publish a Google Sheet to the web as a PDF, open the spreadsheet, go to File > Share > Publish to web, choose PDF …
How to Create a Filter in Google Sheets
To create a filter in Google Sheets, select your data and click Data > Create a filter. Filter buttons appear in the header row, and …
How to Share or Unshare a Google Sheets File (Get a Link)
To get a shareable link for a Google Sheets file, open it, click Share, and under General access choose Anyone with the link. Pick Viewer, …
How to Create a New Google Sheets Spreadsheet in Google Drive
To create a new Google Sheets spreadsheet in Google Drive, open drive.google.com, click New, and choose Google Sheets > Blank spreadsheet. Open the folder where …
How to Remove Sheet Protection (Permissions) in Google Sheets
To remove sheet or range protection in Google Sheets, open the spreadsheet on a computer, click Data > Protect sheets and ranges, click the protection …
How to Add a Hyperlink in Google Sheets
To add a hyperlink in Google Sheets, click a cell and press Ctrl + K (Command + K on a Mac), or click Insert > …
How to Unhide the Menu in Google Sheets
If the menus disappeared from the top of Google Sheets, press Ctrl + Shift + F to bring them back. On a Mac, press Command …
How to Remove Comments and Notes From Google Sheets
To remove a comment in Google Sheets, click the comment, click More (three dots), choose Delete, and confirm. To remove a note, right-click the cell, …
How to Use Larger Font Sizes in Google Sheets
To make the font bigger in Google Sheets, select the cells, then click the + button next to the font size box in the toolbar. …
How to Insert a Row in Google Sheets
To insert a row in Google Sheets, right-click a row number and choose Insert 1 row above or Insert 1 row below. To add several …
How to Clear Contents or Formatting in Google Sheets
To clear formatting in Google Sheets, select the cells and click Format > Clear formatting, or press Ctrl + \ (Command + \ on a …
How to Show Formulas in Google Sheets
To show formulas in Google Sheets, press Ctrl + ~ (the same shortcut on Windows, Mac, and Chromebook), or click View > Show > Formulas. …