DATABASE FUNDAMENTALS
WORKBOOK THEMES
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
right-click
|
|
left-click
|
|
highlight
|
|
double-click
|
Detailed explanation-1: -Press and hold down the Ctrl key on the keyboard. Continue to hold down the Ctrl key and click once on each additional row to be hidden to select them. Right-click on one of the selected rows and choose Hide. The selected rows will be hidden from view.
Detailed explanation-2: -Select the row beneath the last row with data (to select the entire row, click on the row header). Press Ctrl + Shift + Down arrow to extend the selection to the bottom of the sheet. Press Ctrl + 9 to hide the selected rows.
Detailed explanation-3: -Hide Rows To hide rows in Excel, you can use one of the following keyboard shortcuts: Ctrl+9. Ctrl+Shift+9.
Detailed explanation-4: -Bonus tip: You can also use the Ctrl+⌘+9 shortcut to quickly hide all the rows in your worksheet, or the Ctrl+⌘+0 shortcut to hide all the columns. If you want to quickly hide all the sheets in your workbook, you can use the Ctrl+Shift+⌘+A shortcut.