All Collections
Workflows
Google Sheets Basics
How To Select All The Data In Your Google Sheet
How To Select All The Data In Your Google Sheet

Select all the data in any of your sheets in a Google Sheet

Heather Phillips avatar
Written by Heather Phillips
Updated over a week ago

There is a quick way to select the data in all the rows and columns with just one click. 

Find the blank rectangle above row number 1 and to the left of Column A.

Click that box and all cells are now selected and turn light blue.

Selecting all your data in one sheet is very useful. You can quickly copy or delete the data in the entire sheet, change the formatting such as the font style or alignment of all cells, or use the data to quickly add a pivot table.

Did this answer your question?