DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
CTRL + (Up arrow)
|
|
|
ALT + (Up arrow)
|
|
|
SHIFT + (Up arrow)
|
|
|
DEL + (Up arrow)
|
Detailed explanation-1: -Ctrl + Home: This shortcut will take you to the very top of your spreadsheet. 2. Ctrl + End: This shortcut will take you to the very bottom of your spreadsheet.
Detailed explanation-2: -When you move to a cell, it becomes the active cell. Press CTRL+an arrow key to scroll to the start and end of each range in a column or row before stopping at the end of the worksheet.
Detailed explanation-3: -Click the Ribbon Display Options icon on the top-right corner of your document. It is to the left of the Minimize icon. In the menu that opens, click Show Tabs and Commands to show the Ribbon with all tabs and full commands.
Detailed explanation-4: -This is useful if you have a lot of data in your spreadsheet and you want to quickly get to the bottom without scrolling. The third shortcut is the ‘Ctrl + Home’ keys. This shortcut takes you to the top of your spreadsheet, which can be useful if you want to quickly get back to the top after scrolling to the bottom.