USING MICROSOFT EXCEL
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: -Again, just like columns, if you set the row height to 0 (zero), Excel will hide the row.
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.