When working with a large dataset in Excel, it can be time-consuming to navigate through the worksheet to select the desired cells. Fortunately, Excel provides many keyboard shortcuts that can help save time and effort. One such keyboard shortcut is the ability to extend the selection down one screen, which can be very useful when working with large datasets.
Keyboard Shortcut to Extend Selection Down One Screen In Excel
To use the keyboard shortcut to extend the selection down one screen in Excel, follow these steps:
- Click on the cell where you want to start the selection.
- Press and hold the Shift key on Windows or the Fn key on Mac.
- While holding the key, press the Page Down key (PgDn) on your keyboard.
- The selection will be extended down one screen.
Points to Remember:
- This keyboard shortcut works for both Windows and Mac versions of Excel.
- The selection will extend down one screen from the current active cell.
- If you have frozen panes in your worksheet, the selection will be extended down to the last visible row in the unfrozen panes.
- You can use the same keyboard shortcut with the Page Up key (PgUp) to extend the selection up one screen.
In conclusion, using the keyboard shortcut to extend the selection down one screen. Which can save a lot of time when working with large Excel worksheets. With just a few keystrokes, you can quickly select a range of cells that are not currently visible on the screen, without having to scroll up and down the worksheet.