Step 4: Select the first row up shared range, press Ctrl+ Shift + Up arrow simultaneously to select all rows up shared range, and then hide them. Step 3: Select the first row below shared range, press the Ctrl + Shift + Downward arrow keys at the same time to select all rows below shared range, and then hide them. Step 2: Right click selected columns, and select the Hide from right-clicking menu. Select the first column right to the shared range, and then press the Ctrl + Shift + Rightward arrow keys simultaneously to select all right columns. Step 1: Besides the shared range, you need to select the left ranges and hide them. Apart from setting scrolling area, we can also limit number of rows and columns by hiding unshared rows and columns in Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |