Why Excel for Mac Cannot Delete Extra Worksheet Rows and Columns
Question details
The user wants to remove unused rows and columns from a new Excel worksheet.

- 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.
Decide which rows and columns you want to keep visible. If the sheet is protected, check Review > Unprotect Sheet before attempting to hide them.
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.
Click the Name Box to the left of the formula bar, enter the range of unused rows, such as 101:1048576, and press Return.
Right-click a selected row header and choose Hide. Rows 101 through 1,048,576 will be hidden.
Click the Name Box, enter the range of unused columns, such as K:XFD, and press Return.
Right-click a selected column header and choose Hide. Columns K through XFD will be hidden.

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. Open the workbook: Open WPS Spreadsheet and use File > Open to select your Excel workbook.
- 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. Hide the rows: Right-click a selected row header and choose Hide.
- 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. Save the workbook: Choose File > Save or File > Save As to save the workbook with the rows and columns hidden.

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.




