How to Save a Google Sheets File as a CSV
The CSV file type might seem somewhat basic when you are dealing with a spreadsheet, but it’s a very versatile file type that works with… Continue Reading How to Save a Google Sheets File as a CSV
How-to guides and tutorials to help you perform specific tasks and use the Google Sheets spreadsheet application.
The CSV file type might seem somewhat basic when you are dealing with a spreadsheet, but it’s a very versatile file type that works with… Continue Reading How to Save a Google Sheets File as a CSV
Google Sheets toolbar missing? Press Ctrl+Shift+F or click the arrow to show menus, exit full screen, show the formula bar, and fix zoom or extension issues. Continue Reading Why Is My Google Sheets Toolbar Missing? How to Get It Back
Lock a row in Google Sheets by freezing it with View > Freeze so it stays visible, or protect it with Data > Protect sheets and ranges. Continue Reading How to Lock a Row in Google Sheets
Make multiple columns the same width in Google Sheets with Resize columns, by dragging one selected border, or fit them to data. Rows too. Continue Reading How to Make Columns the Same Width (Distribute Evenly) in Google Sheets
Make a title in Google Sheets: add a title row, merge and center it, format it, freeze it, print it on every page, and name the file and sheet tabs. Continue Reading How to Make a Title in Google Sheets
Restore an earlier version of a Google Sheets file from version history, recover only certain data with Make a copy, and name versions for later. Continue Reading How to Restore a Version From Version History in Google Sheets
Insert an image into a cell in Google Sheets with Insert > Image > Image in cell or the IMAGE function, lock it in place, and fix images that won’t show. Continue Reading How to Insert an Image Into a Cell in Google Sheets
Print gridlines in Google Sheets by checking Show gridlines in print settings, or add borders for darker lines, print a selection, and fit it on one page. Continue Reading How to Print With Gridlines in Google Sheets
Turn off autocomplete in Google Sheets from Tools > Suggestion controls, and disable formula suggestions, corrections, and Smart Fill prompts. Continue Reading How to Turn Off Autocomplete in Google Sheets
Print every tab in Google Sheets: press Ctrl + P, change Print from Current sheet to Workbook, pick sheets, then click Next. Plus PDF tips. Continue Reading How to Print an Entire Workbook in Google Sheets
Change cell border color in Google Sheets by choosing a color with the Borders pencil before applying borders, recolor existing borders, and use mobile. Continue Reading How to Change Cell Border Color in Google Sheets
Sort a column from highest to lowest in Google Sheets with Sort sheet Z to A, keep headers in place, sort by multiple columns, or use the SORT function. Continue Reading How to Sort a Column From Highest to Lowest in Google Sheets
Unhide a sheet in Google Sheets with View > Hidden sheets or the All Sheets list, unhide on mobile, and fix a grayed-out Hidden sheets option. Continue Reading How to Unhide a Sheet in Google Sheets (Desktop and Mobile)
Center a Google Sheets printout: open File > Print, expand Formatting and set Alignment to Center and Middle. Plus scale and margin tips. Continue Reading How to Print in the Middle of the Page in Google Sheets
Move Google Sheets page numbers to the top: File, Print, Headers and footers, check Page numbers, then Edit custom fields to place them in the header. Continue Reading How to Put Page Numbers at the Top in Google Sheets
Change a file name in Google Sheets: click the name at the top left, type a new one, and press Enter, or use File > Rename. Plus Drive and mobile steps. Continue Reading How to Change a File Name in Google Sheets
Delete a column in Google Sheets with the right-click menu, Edit menu, or a shortcut, delete several at once, and see how formulas react. Continue Reading How to Delete a Column in Google Sheets (Desktop and Mobile)
Show formulas in Google Sheets with View > Show > Formulas or Ctrl+backtick, display a formula next to its result with FORMULATEXT, and protect formulas. Continue Reading How to Show Formulas (Equations) in Google Sheets
If your Google Sheets file has a lot of worksheets, finding the right one can be difficult. This is made even worse when the tabs… Continue Reading How to Change the Color of the Sheet Tab in Google Sheets
Change Google Sheets recalculation to on change, every minute or every hour in File > Settings > Calculation, and learn how iterative calculation works. Continue Reading How to Change Recalculation Settings in Google Sheets
Change the print orientation in Google Sheets to landscape, fit all columns on one page, repeat headers, and save a landscape PDF. Continue Reading How to Print a Google Sheets Spreadsheet in Landscape
Clear formatting in Google Sheets with Ctrl + \ or Format > Clear formatting, and remove conditional formatting, alternating colors, and validation. Continue Reading How to Clear Formatting in Google Sheets (Cell, Range, or Sheet)
Make a histogram in Google Sheets with Insert > Chart and the Histogram chart type, adjust bucket size, and build a frequency table with FREQUENCY. Continue Reading How to Make a Histogram in Google Sheets (Step-by-Step)
Add color to cells in Google Sheets: select cells and click Fill color, or color by value with conditional formatting. Plus alternating colors. Continue Reading How to Add Color to Cells in Google Sheets
Add borders in Google Sheets: select cells, click the Borders icon, and pick a type, color, and style. Plus mobile steps, shortcuts, and fixes. Continue Reading How to Add Borders to Cells in Google Sheets
These steps are going to show you how to insert a picture from your iPhone into a cell in one of your Google Sheets spreadsheets.… Continue Reading How to Insert a Picture in the Google Sheets iPhone App
Copy multiple rows in Google Sheets: click the row numbers with Shift, press Ctrl + C, then paste. Plus non-adjacent rows and values-only paste. Continue Reading How to Copy Multiple Rows in Google Sheets
To autofill in Google Sheets, select the cell (or cells) with the starting value, then drag the small blue square in the bottom-right corner of… Continue Reading How to Use Autofill in Google Sheets
The steps below show you how to download a chart or graph in your Google Sheets spreadsheet as a .png file so that you can… Continue Reading How to Download a Google Sheets Chart as a PNG
The steps below show you how to create a drop down menu in Google Sheets. This menu will be either created from a list of… Continue Reading How to Create a Google Sheets Drop Down Menu
Remove many checkboxes at once in Google Sheets by selecting them and pressing Delete, or remove the data validation rule. Continue Reading How to Remove Multiple Checkboxes in Google Sheets
View a cell’s edit history in Google Sheets with right-click > Show edit history, use Version history for bigger changes, and get edit notifications. Continue Reading How to View Cell History in Google Sheets
Google Sheets is very similar to Microsoft Excel in many ways and, for a large number of users, is a perfectly acceptable replacement. Sheets lets… Continue Reading How to Download an Excel Version of a Google Sheets File
Hide a column in Google Sheets: right-click the column letter and choose Hide column, or press Ctrl+Alt+0. Plus how to unhide columns and hide several. Continue Reading How to Hide a Column in Google Sheets
Google Sheets, much like Microsoft Excel, lets you add new worksheets to your file. This makes it easy for you to organize all of your… Continue Reading How to Rename a Google Sheets Worksheet Tab
Remove cell borders in Google Sheets with Borders > Clear borders, clear the whole sheet, keep some lines, and hide gray gridlines on screen and in print. Continue Reading How to Remove Cell Borders in Google Sheets
To highlight every other row in Google Sheets, select your data, click Format > Alternating colors, pick a style in the side panel, and click… Continue Reading How to Highlight Every Other Row in Google Sheets (Alternating Colors)
Randomize data in Google Sheets with Data > Randomize range, shuffle with SORT and RANDARRAY, pick random entries, and freeze results. Continue Reading How to Randomize a List in Google Sheets
When you first create a spreadsheet in Google Sheets it will contain a series of cells arranged into rows and columns. These cells will be… Continue Reading How to Merge Cells in Google Sheets
Center data horizontally in Google Sheets with the Horizontal align button, Format > Alignment, or Ctrl + Shift + E, and center vertically too. Continue Reading How to Center Data Horizontally in Google Sheets
Splitting a column of full names takes one menu in Google Sheets, Data > Split text to columns, as long as the cells to the… Continue Reading How to Split Full Names in Google Sheets
Google Drive makes it very easy for you to share a link to one of the Google Sheets files that you’ve created. Turn on a… Continue Reading How to Stop Sharing a Link to a Google Sheets File
The collaboration feature in Google Sheets makes it easier for a group of people to work on the same file. But if you have shared… Continue Reading How to Protect a Worksheet in Google Sheets
Apply currency formatting in Google Sheets: select cells and click $ or Format > Number > Currency. Plus custom currencies, locale and accounting. Continue Reading How to Apply Currency Formatting in Google Sheets
Remove cell shading in Google Sheets: select cells and click Fill color > Reset, or press Ctrl + \ to clear formatting. Plus banding and rule fixes. Continue Reading How to Remove Cell Shading in Google Sheets
When you first create a spreadsheet you probably have a general idea of the information you need, and what will be included in the sheet.… Continue Reading How to Insert a Column in Google Sheets