![excel how many rows available in excel excel how many rows available in excel](https://www.nerdexcel.com/wp-content/uploads/2020/10/freeze-panes-option-excel.png)
The VBA properties are reset when you close and reopen the spreadsheet, so disabling scrolling and editing is just a temporary solution.
Excel how many rows available in excel how to#
Figure 1 How to collapse cells How to Collapse Rows within a Group.
![excel how many rows available in excel excel how many rows available in excel](https://i1.wp.com/excelzoom.com/wp-content/uploads/2015/07/find-replace.png)
We will also learn how to expand or collapse rows and outlines in Pivot table fields. In this tutorial, we will learn how to collapse multiple columns. Even if the rows are visible, nobody can edit them. Excel allows us to collapse or expand an entire row, column, outline or group of data. When you disable scrolling, you also disable editing. For example, to scroll through rows 1 through 100 and columns A through Z, type "A1:Z100" (without the quotes). Type the letter of the last column you want to display before the number of the last row. In the ScrollArea field, type the letter of the first column you want to display, before typing the row number.
![excel how many rows available in excel excel how many rows available in excel](https://cdn.corporatefinanceinstitute.com/assets/rows-function01.png)
You can temporarily disable scrolling through - as well as editing - columns. You can hide and unhide rows and columns that contain data, in case you don't want people to edit them accidentally. To unhide all rows, press "Ctrl-A" to select everything in the spreadsheet, click "Format" in the Cells group, select "Hide & Unhide" and then click "Unhide rows." To unhide all columns, click "Unhide columns." Many of you requested that we improve the way this works, and that’s just what we’ve done. When you’re scrolling in a sheet with very large cells, the way Excel for Windows snapped to the grid made it hard to view your data. Click "Format," select "Hide & Unhide" and then click "Hide columns" to hide the columns. The bold text in row 2 says 'Were happy to anounce New in Excel for Windows: Smooth Scrolling'. Hold "Ctrl-Shift" and press the "Right" arrow key to select all columns. Don't try to scroll to the last column because Excel 2013 spreadsheets can contain 16,384 columns. Locate the last column you want to be visible in the spreadsheet and then click the header of the next column to select it. You can also hide columns to prevent people from editing them.