How to Select All Data in Excel on Mac

Nothing stalls your workflow faster than wrestling with a huge dataset in Excel. Selecting all your data on a Mac might seem simple, but knowing the right trick for the right situation can save you tons of time and frustration. This guide will walk you through every method, from the most famous keyboard shortcut to some advanced techniques that will make you feel like an Excel power user.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

The Universal Shortcut: Command + A

The fastest and most common way to select data is with the keyboard shortcut Command + A. However, what it selects depends on where your active cell is. This context-aware behavior is actually a feature, not a bug, and learning how it works is the key to mastering data selection.

Command + A (Pressed Once): Select the Current Data Range

If you click any single cell within a continuous block of data (like a table of sales figures), pressing Command + A once will intelligently select only that block of data. Excel identifies the "current region" as the area surrounded by empty rows and columns. This is incredibly useful for when you just want to grab your table to format it, create a chart, or copy it elsewhere, without selecting the entire worksheet.

Step-by-step:

1. Open your Excel sheet and find your table of data.
2. Click any cell inside the data - for example, B5.
3. Press ⌘ + A on your keyboard.
4. Excel will instantly highlight all the contiguous cells connected to B5, stopping at the first empty row or column.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Command + A (Pressed Twice): Select the Entire Worksheet

What if you want to select everything on the sheet, including titles, notes, and empty cells? Simply press the shortcut a second time. After the first press selects your current data table, the second press expands the selection to all 1,048,576 rows and 16,384 columns in the worksheet.

Step-by-step:

1. Click any cell inside your data table.
2. Press ⌘ + A. Your data table will be highlighted.
3. Without clicking anywhere else, press ⌘ + A again.
4. The entire worksheet is now selected.

Pro Tip: If you click on a cell that is not part of a data block (an empty cell), pressing Command + A just once will select the entire worksheet immediately, skipping the intermediate step.

The Single-Click Method: The Select All Button

If keyboard shortcuts aren't your thing, Excel for Mac provides a straightforward visual way to select the entire worksheet with a single click. It’s perfect for users who prefer using their mouse or trackpad.

Where to find the Select All button:

Look at the top-left corner of your worksheet, right where the row headers (1, 2, 3...) meet the column headers (A, B, C...). You'll see a small, gray triangle button at that intersection.

How to use it:

1. Move your cursor to the top-left corner of the grid.
2. Click on the gray triangle button.
3. The entire worksheet will be selected instantly.

This method accomplishes the same thing as pressing Command + A twice and is a great, simple alternative for quickly selecting every single cell on the sheet.

Precision Selection with the Name Box

For those who need more control, the Name Box offers a precise way to select ranges. The Name Box is the small field to the left of the formula bar that typically displays the address of your active cell (e.g., A1).

While often used for naming ranges, you can also type a cell range into it to jump to and highlight that specific area. To select all data, you could technically type in the full dimensions of an Excel sheet, but the most practical use of this feature is to select your used range of data.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

How to Select the Active Data Area:

1. First, identify the last cell containing data in your worksheet. An easy way to find it is to click on a known cell (like A1) and press Fn + Command + Right Arrow to get to the last column, then Fn + Command + Down Arrow to get to the final row. Let's say your last cell is M500.
2. Click in the Name Box to the left of the formula bar.
3. Type the range manually, starting from A1 to your last cell. For our example, you would type: A1:M500
4. Press Enter. Excel will immediately select that precise range, giving you a clean selection of just the cells that have data in them.

This technique is superior when your data sheet has stray blank rows or columns that might confuse the Command + A shortcut, allowing you to define the exact boundaries of your selection.

Go-To Shortcuts for Mac Power Users

Once you've mastered the basics, you can elevate your efficiency with more advanced shortcuts. These allow you to select large blocks of data without ever taking your hands off the keyboard.

Select to the End of Your Data: Command + Shift + Arrow Keys

This combination is perfect for selecting entire columns or rows within your data table, starting from your current position.

• Select to the right boundary: Place your cursor in the first cell of a row in your table and press Command + Shift + Right Arrow. Excel extends the selection from your active cell to the last cell with data in that row.
• Select to the bottom boundary: Similarly, press Command + Shift + Down Arrow to select from your active cell to the last cell with data in that column.

You can combine these to select an entire table in two quick steps. Click on the first cell of your table (e.g., A1) and press Command + Shift + Right Arrow, then follow it up with Command + Shift + Down Arrow. Your whole table is now selected.

A Smarter Alternative: Command + Shift + *

The asterisk (*) shortcut on the numeric keypad (or Command + Shift + 8 on some keyboards) serves the same function as the first press of Command + A. It selects the "current region" — the body of data your active cell is within. For many users, this shortcut is more intuitive because it doesn't have the two-step function of Command + A, it is designed to do one thing and do it well: select the table you're working in.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Pinpoint Selection with Shift + Click

Dragging your mouse over thousands of rows is slow and error-prone. The Shift + Click method is a far better way to select a large, specific block of data manually. It lets you define the start and end points of your desired selection without any dragging.

Here’s how it works:

1. Click on the very first cell of the range you want to select.
2. Scroll down (or across) to the last cell you want to include in your selection. You can use the scroll bars or your trackpad.
3. Hold down the Shift key.
4. While holding Shift, click on the last cell of your desired range.
5. The entire rectangle of cells between your first and second click will be highlighted. This method gives you perfect, precise selections over huge areas every time.

Quick Guide: Which Selection Method is Best?

With so many options, it can be helpful to have a quick cheat sheet for which method to use in different scenarios.

• To select your isolated data table: Press Command + A once, or use Command + Shift + *. This is best for creating charts or formatting a specific table.
• To select the entire worksheet: Press Command + A twice, or click the Select All button in the top-left corner. Use this for applying worksheet-wide formatting changes.
• To select from one point to another: Use the Shift + Click method. This is best for large but specific blocks of data when shortcuts might fail due to blank cells.
• To select from your cursor to the edge of a table: Use Command + Shift + Arrow Key. This is for fast, keyboard-driven selections of rows or columns.

Final Thoughts

Mastering these selection techniques in Excel for Mac — whether it's with quick shortcuts like Command + A, the one-click button, or precision tools like Shift + Click — is fundamental to efficient data manipulation. Using the right method for the task at hand eliminates tedious dragging and saves valuable time for more important analysis.

While speeding up your tasks in Excel is a huge win, we built Graphed because we believe you shouldn't have to live in spreadsheets in the first place. Instead of spending hours exporting CSVs, cleaning data, and building pivot tables, Graphed connects directly to your data sources like Google Analytics, Shopify, and Salesforce. You can ask for reports and build dashboards in seconds using plain English, allowing you to skip the manual selection process entirely and get straight to the insights you need to grow your business.