USING MICROSOFT EXCEL
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: -Press SCROLL LOCK, and then simultaneously hold down CTRL and an arrow key to quickly move through large areas of your worksheet. Note: When SCROLL LOCK is on, Scroll Lock is displayed on the status bar in Excel. Pressing an arrow key while SCROLL LOCK is on will scroll one row up or down or one column left or right.
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: -Ctrl + End-This shortcut key will take you to the bottom of your spreadsheet, no matter how many rows you have. Ctrl + Home-This shortcut key will take you to the top of your spreadsheet. Ctrl + Page Down-This shortcut key will take you to the next page of your 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.