tap the header forrow 31to pick the entire row.
Press and hold theShiftandCtrlkeys on the keyboard.
Release all the keys.
Hilary Allison / Lifewire
Right-click one of therow headingsto open thecontextual menu.
you’ve got the option to use the same process to hide any rows or columns you want.
Just go for the header or headers for the row or column, right-tap the header, and selectHide.
Right-hit the row headers and, from the menu, selectUnhide.
The hidden rows are restored.
Right-tap the selected column headers and, from the menu, chooseUnhide.
The hidden columns are restored.
Changing the scroll area is a temporary measure; it resets each time the workbook is closed and reopened.
Opena blank Excel file.
At the bottom of the screen, right-click theSheet1sheet tab.
From the menu, chooseView Code.
TheVisual Basic for Applications (VBA)editor window opens.
In the left rail, locate thePropertiessection.
UnderProperties,in the right column of theScrollArearow, nudge the empty box and typeA1:Z30.
SelectFile>Saveand keep your workbook as you normally would.
SelectFile>Close and Return to Microsoft Excel.
To ensure your change is applied, perform this test.
In your worksheet, give a shot to scroll past row 30 or column Z.
To remove the restrictions, access VBA again and delete the ScrollArea range.
FAQ
Microsoft saysthat the maximum size of a single Excel spreadsheet is 1,048,576 rows by 16,384 columns.
The maximum row height is 409 points, and the maximum column width is 255 characters.
If you want to set a hard limit to columns or rows in an Excel spreadsheet (i.e.
