Question

5. How to hide/unhide and insert a new column or row in a spreadsheet?​

Answer 1

Answer:

Hide and Unhide Columns and Rows

Click the Format button located on the Home tab / Cells group then choose Hide Columns or Rows (another option is to Right click on a highlighted column or row heading and select hide). Your Columns and Rows are now hidden.

Explanation:

Answer 2

Explanation:

To hide a column or row

Click to select the entire row or column. If you want to hide multiple columns or rows drag your mouse across each of the columns or rows to be hidden. 2. Right-click the selected area and then select Hide from the shortcut menu.