DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
When you decrease the row height to ____, the row is hidden.
|
|
0
|
|
|
1
|
|
|
2
|
|
|
3
|
Explanation:
Detailed explanation-1: -If the row height is set to 0, the row is hidden. You can also use the Row. Visible property to hide a row or display the hidden row again.
Detailed explanation-2: -Select any cell in the data range, then Ctrl + Shift + L (apply data filter). All rows with zero row height will appear.
Detailed explanation-3: -When the row numbers in your worksheet turn blue, this indicates that some rows are filtered out. To unhide such rows, simply remove all filters on a sheet. This is how you hide and undie rows in Excel.
There is 1 question to complete.