Office for Mac Issues

Why Excel for Mac Cannot Delete Extra Worksheet Rows and Columns

Aamir Naveed AkramAamir Naveed Akram Nov 14, 2026 868 views

Question details

The user wants to remove unused rows and columns from a new Excel worksheet.

Why Excel for Mac Cannot Delete Extra Worksheet Rows and Columns
Product
Microsoft Excel for Mac
Device & OS
macOS
Scenario
A user wants a worksheet to display only the rows and columns needed for their work.
Observed behavior
Deleting rows or columns does not reduce the worksheet's total number of rows or columns.
Before you start

Decide which rows and columns you want to keep visible. If the sheet is protected, check Review > Unprotect Sheet before attempting to hide them.

Solution 1Recommended

Hide unused rows and columns in Excel for Mac

Use this approach to keep extra rows and columns out of view without changing the worksheet's fixed size.

An Excel worksheet has 1,048,576 rows and 16,384 columns. Deleting worksheet rows or columns shifts remaining content, but it does not reduce those limits.

1
Select unused rows

Click the Name Box to the left of the formula bar, enter the range of unused rows, such as 101:1048576, and press Return.

2
Hide the rows

Right-click a selected row header and choose Hide. Rows 101 through 1,048,576 will be hidden.

3
Select unused columns

Click the Name Box, enter the range of unused columns, such as K:XFD, and press Return.

4
Hide the columns

Right-click a selected column header and choose Hide. Columns K through XFD will be hidden.

Hide unused rows and columns in Excel for Mac
Hidden rows and columns still exist: Hiding changes what is visible, not the worksheet's dimensions. To restore them, select the whole sheet and use Home > Format > Hide & Unhide to unhide rows or columns.
Work with spreadsheets in WPS Office

Hide unused spreadsheet rows and columns in WPS Office

Use WPS Spreadsheet to open a workbook and hide unused rows and columns, keeping the working area focused without attempting to reduce the sheet's fixed size.

  1. 1. Open the workbook: Open WPS Spreadsheet and use File > Open to select your Excel workbook.
  2. 2. Select unused rows: Click the Name Box beside the formula bar and enter the unused row range, such as 101:1048576, then press Enter.
  3. 3. Hide the rows: Right-click a selected row header and choose Hide.
  4. 4. Hide unused columns: Enter an unused column range, such as K:XFD, in the Name Box. Right-click a selected column header and choose Hide.
  5. 5. Save the workbook: Choose File > Save or File > Save As to save the workbook with the rows and columns hidden.
Hide unused rows and columns to focus on your dataOpen and edit Microsoft Excel XLSX and XLS filesUse familiar spreadsheet controls in a free office suite
microsoft office alternative - wps office

Frequently Asked Questions

Can I permanently reduce the number of rows and columns in an Excel worksheet?

No. An Excel worksheet has 1,048,576 rows and 16,384 columns. You can hide unused areas, but you cannot reduce those worksheet limits.

What happens when I delete a worksheet row or column?

Select a row or column header and choose Delete to shift the remaining content. The worksheet still retains its full number of rows and columns.

How do I show hidden rows and columns again?

Select the whole worksheet, then use Home > Format > Hide & Unhide and choose Unhide Rows or Unhide Columns.

Why can't I hide rows or columns?

The sheet may be protected. Check Review > Unprotect Sheet and, if required, enter the password or ask the workbook owner for permission.