Excel Performance Problems

How to Remove Blank Rows That Extend Excel's Used Range on Mac

Steven ParkerSteven Parker Nov 13, 2026 869 views

Question details

The user needs to remove blank rows and columns that Excel for Mac includes in its used range, so the Control+End shortcut stops at the actual last data cell instead of far below or to the right.

How to Remove Blank Rows That Extend Excel's Used Range on Mac
Product
Microsoft Excel for Mac
Device & OS
macOS
Scenario
After pasting or importing data, Excel remembers blank rows and columns as part of the used range, and the user needs to reset that range.
Observed behavior
Control+End moves far below or to the right of the actual data because Excel still treats the blank area as used.
Before you start

Before deleting anything, press Fn+Control+End to see the cell Excel currently treats as the last used cell, and make sure row and column headings are visible so you can select only the blank area beyond your real data.

Solution 1Recommended

Delete Blank Rows and Columns to Reset the Used Range on Mac

Use this method to remove the empty rows and columns that are making Excel jump past your actual data.

Excel keeps the used range until you remove cells and reopen the workbook. Deleting the blank rows and columns, then saving, closing, and reopening forces Excel to recalculate the used range.

1
Locate the last used cell

Press Fn+Control+Right Arrow to jump to the last used column in the current row, then press Fn+Control+Down Arrow to jump to the last used row. Alternatively, press Fn+Control+End to go directly to the last cell Excel remembers.

2
Delete blank rows below the data

Click the row number just below your last real data row, hold Shift+Command+Down Arrow to select through the last used row, then Control-click the selected row numbers and choose Delete.

3
Delete blank columns to the right of the data

Click the column letter just to the right of your last real data column, hold Shift+Command+Right Arrow to select through the last used column, then Control-click the selected column letters and choose Delete.

4
Save, close, and reopen the workbook

Press Command+S to save, close the workbook completely, and reopen it so Excel recalculates the used range.

5
Test the Control+End shortcut

Press Fn+Control+End again. The selection should now stop at the last cell that contains data or formatting you intend to keep.

Delete Blank Rows and Columns to Reset the Used Range on Mac
Used range reset: If Control+End still jumps too far, repeat the process and check for hidden rows, columns, formatting, or objects in the blank area before saving.
Free Microsoft Office alternative

Use WPS Office on Mac as a Free Excel Alternative

If Excel for Mac keeps remembering phantom blank rows and columns, WPS Office is a free, lightweight alternative that opens and saves Excel workbooks with a familiar spreadsheet interface, so you can edit without the same used-range overhead.

  1. 1. Download WPS Office for Mac: Go to the WPS Office download page and download the Mac version.
  2. 2. Open the workbook in WPS Spreadsheets: Launch WPS Office, click the spreadsheet module, and open your existing .xlsx file.
  3. 3. Edit and save without losing compatibility: Delete the blank rows or columns you no longer need, then save as .xlsx to keep compatibility with Excel.
Fully compatible with .xlsx, .xls, and .csv file formatsFree to download and use for everyday spreadsheet editingFamiliar ribbon interface and shortcuts make migration from Excel easyLightweight Mac performance with less file overhead for routine workbook cleanup
microsoft office alternative - wps office

Frequently Asked Questions

Why does Control+End move far below my actual data in Excel for Mac?

Excel uses the last cell it has ever seen as part of the used range, including copied or formatted blank rows and columns. You can check this by pressing Fn+Control+End, then delete the blank rows and columns and reopen the workbook to reset it.

What is the Mac equivalent of Ctrl+End in Excel?

On a Mac, press Fn+Control+End to move to the last used cell. You can also use Fn+Control+Right Arrow to locate the last used column and Fn+Control+Down Arrow for the last used row.

Do I have to save and close the workbook after deleting blank rows and columns?

Yes. Excel normally recalculates the used range only after the workbook is saved, closed, and reopened. If you skip this step, Control+End may still jump to the old last cell.

Why are there still phantom blank rows after I delete them?

Hidden rows, columns, formatting, objects, or formulas in the blank area can keep the used range large. Clear or delete those cells as well, then save and reopen the workbook.

Can WPS Office open the same Excel file after I clean it up?

Yes. WPS Spreadsheets supports .xlsx and .xls files, so you can open, edit, and save the workbook while keeping Excel compatibility.