Select All in Google Sheets: Shortcuts and Options

To select all cells in a Google Sheets tab, click the blank square at the top-left corner of the grid, where the row numbers and column letters meet. You can also use Ctrl+A on Windows or ChromeOS, or Command+A on a Mac, while the sheet grid is active; the selection applies to one tab, not every tab in the file.

Where to find the Select all button

In a browser, open the spreadsheet and look at the upper-left corner of the cell grid. A small, blank square sits above row 1 and to the left of column A. Click it once to select the entire current sheet. The row and column headers change appearance to show that the grid is selected, and the cells are highlighted.

This corner control is the clearest option when you mean every cell in the current tab, including empty cells. It is different from clicking the column A heading or row 1 heading, which selects only that column or row. The control remains in the same place as you scroll, so you do not need to return to the first row or column to use it.

Selection is not an edit by itself. Clicking the square does not delete, format, or copy anything; it simply marks the cells that a later command will affect. If you click the square accidentally, click an individual cell to return to a normal single-cell selection.

Keyboard shortcuts and what they select

With a cell active in the grid, Ctrl+A on Windows or ChromeOS, and Command+A on Mac, selects all. Depending on the current selection, the first press can select the contiguous data region around the active cell; pressing the shortcut again can expand the selection to the whole sheet. If you need to be certain you have selected the entire grid, use the top-left corner button.

The shortcut works only as intended when Google Sheets has focus. If the cursor is in the browser address bar, a text box, or a formula being edited, the browser or text field may select text instead of spreadsheet cells. Click a cell first, then use the shortcut. A blue outline around the cell or range is a useful sign that the grid has focus.

On a Mac, use the Command key rather than Control for the standard select-all shortcut. On a Chromebook, use Ctrl. Browser extensions, operating-system settings, and the state of an edit field can affect keyboard behavior, so the corner button is a reliable fallback when a shortcut seems to select the wrong thing.

Select a data range instead of the entire sheet

Often, selecting every cell is broader than the task requires. If a table has headers in row 1 and records in rows 2 through 40, clicking inside the table and using Ctrl+A or Command+A may select the connected data region first. This is useful for copying or formatting a table without including unrelated cells elsewhere on the sheet.

A contiguous range is a block of adjacent cells with no blank row or column breaking it up. For example, a blank row between two sets of records can cause a shortcut to stop at the edge of the first block. Check the highlighted border before applying a change. If the selection is not the intended range, click and drag across the cells, or click the first cell and Shift-click the last cell.

You can also select a range by clicking the Name box, the small field to the left of the formula bar that normally displays the active cell address. Type a reference such as A1:D40 and press Enter to select that range. This is handy for a large block that is difficult to drag across, but it selects only the addresses entered, not the whole tab.

Select entire rows or columns

To select one column, click its letter at the top of the grid. To select one row, click its number at the left. For adjacent columns or rows, click the first heading and drag across the neighboring headings, or click the first heading and Shift-click the last. This is usually safer than selecting the whole sheet when you want to resize, hide, clear, or format just a particular part.

For example, to make every cell in column C display dates consistently, click the C heading and choose the appropriate date format. To remove an unwanted record, select its row number and use the row’s context menu to delete the row. Selecting a row or column heading targets that entire row or column, including its currently empty cells.

Be careful when you use a command such as Delete after selecting a whole row or column. It can remove more than the visible values, while clearing cell contents is a different operation. Read the command label and check the highlighted heading before confirming a destructive action.

One sheet tab is not the whole spreadsheet file

A Google Sheets file can contain multiple tabs, shown along the bottom of the window. Selecting all cells with the corner button or a keyboard shortcut affects the active tab only. It does not select every cell in every tab, and it does not select all the tabs as a group.

This distinction matters when a file has tabs for different months, departments, or projects. If you want to apply the same formatting or change to several tabs, selecting the grid on one tab will not carry that selection over to the others. You must work on each tab separately or use another approach that is appropriate to the change, such as copying a prepared tab or editing a shared source of data.

Before copying or clearing a sheet, look at the tab name at the bottom and confirm it is the one you intend to change. For a task involving multiple tabs, make a plan for each one rather than assuming that Select all applies to the entire file.

When selecting the whole sheet is useful

Selecting the full grid can help when you need an action to apply consistently across one tab. Common examples include setting a default font, changing the general text size, or copying the contents of a small, simple sheet. The command that follows the selection determines what actually happens; selection alone does not perform any of these actions.

Apply broad formatting: Select all, then choose a font or text size if you genuinely want it across the tab. Specific formatting already applied to cells may be changed.
Copy a complete tab: Select all and copy when you need the cell grid’s contents, then paste into a suitable destination. For a complete duplicate, including the tab structure and formatting, duplicating the tab may be a better fit.
Inspect or reset a sheet: Select all before using a command only when you intend that command to affect the full grid. Check whether it changes formatting, values, or both.

For ordinary data work, a table-sized range is often a better target. If you have a list of names and email addresses in columns A and B, selecting A1:B40 avoids including thousands of empty cells. Narrow selections reduce the chance of accidentally changing unrelated notes or formatting.

Common problems and ways to avoid mistakes

If Ctrl+A or Command+A selects text in the browser instead of cells, click a cell in the grid and try again. If it selects only a table or nearby block, press the shortcut a second time if appropriate, or click the corner button to select the full tab. When in doubt, confirm the highlight visually before using a command.

Another common misunderstanding is that selecting all cells means selecting only cells with content. The corner button selects the sheet grid, including blank cells. That is useful for whole-sheet formatting, but it can be unnecessary for copying a small table. Use a specific range when blank areas or other sections should stay untouched.

Take extra care before pressing Backspace, Delete, or choosing a clear or formatting command after a whole-sheet selection. A broad selection makes a broad target. If you are unsure what a command will change, click a single cell and test the action on a copy of the spreadsheet first. Undo can reverse many recent edits, but it is better not to rely on it for every large change.

Large sheets may take longer to respond to broad operations than small ones. Avoid applying complicated formatting or other changes to the entire grid simply because selecting all is convenient. Limit the selection to the actual data area when that meets the goal.

Google Sheets compared with Excel

The basic idea is similar in Google Sheets and Microsoft Excel: a corner control selects a worksheet, and a keyboard shortcut can select all. In the Google Sheets browser interface, use the blank square at the intersection of row and column headings. Excel also has a select-all corner control, but its location and appearance can vary slightly by version and window layout.

In both programs, selecting a worksheet is not the same as selecting every sheet in a workbook or spreadsheet file. Shortcuts can also behave differently depending on whether the active focus is in the grid, a formula field, or another input area. If you are following instructions written for Excel, check the app named in the instructions; menu labels, tab controls, and some selection behavior are not identical.

Frequently Asked Questions

How do I select all cells in Google Sheets?
Click the blank square above row 1 and left of column A. With the grid active, Ctrl+A on Windows or ChromeOS, or Command+A on Mac, is another option.

Does Select all include blank cells?
Yes. The corner button selects the grid on the active tab, including empty cells. A shortcut may first select a connected data region, so use the corner button when you need the whole sheet.

How do I select all tabs in a Google Sheets file?
Select all on the grid does not select every tab; it affects only the active tab. Google Sheets does not turn that cell selection into a selection of all tabs. Handle tabs individually or choose a suitable copy or editing workflow.

Why does Ctrl+A select only some cells?
The shortcut may select the contiguous data block around the active cell before expanding to the full sheet. A blank row or column can divide blocks. Click the top-left corner control for an unambiguous whole-tab selection.

How do I select a whole row or column?
Click the row number to select that row or the column letter to select that column. Drag across headings or Shift-click another heading to extend the selection to adjacent rows or columns.

Can I select all in the Google Sheets mobile app?
The app’s touch interface differs from the browser. You can tap the row and column heading area or use the app’s selection controls, but the precise gestures can vary by device and app version. For a dependable full-grid selection using the browser controls described here, open the file in a desktop browser.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.