DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
CTRL + (Down Arrow)
|
|
|
ALT + (Down Arrow)
|
|
|
SHIFT + (Down Arrow)
|
|
|
CTRL + SHIFT + (Down Arrow)
|
Detailed explanation-1: -To scroll to the start and end of each range while selecting the ranges before stopping at the end of the worksheet, press CTRL+SHIFT+an arrow key. Press SCROLL LOCK, and then use the UP ARROW key or DOWN ARROW key to scroll one row up or down.
Detailed explanation-2: -Locate the last cell that contains data or formatting on a worksheet. To locate the last cell that contains data or formatting, click anywhere in the worksheet, and then press CTRL+END.
Detailed explanation-3: -In both Excel and Google Sheets it is possilbe to do [Ctrl] [Arrow key] to jump to the last filled non-blank row or column in series of rows/columns which allows quick navigation around a spreadsheet.
Detailed explanation-4: -CTRL+END Move to the last cell on the worksheet, in the bottom-most used row of the rightmost used column. PAGE DOWN Move down one screen. PAGE UP Move up one screen. ALT+PAGE DOWN Move one screen to the right.