Question

Priyam has prepared a sales report for his company in excel. He does not want to display the data in Some columns . What should He should choose to make the columns invisible

Answer 1

I think it is Hide option

Answer 2

Priyam should choose the hide option to make the columns invisible.

One must select respective row header beneath the used cell of the spreadsheet in where he/ she wants to begin hiding the rows.

One must press Ctrl + Shift + Down Arrow for this purpose.

This step would highlight everything of the selected row at the bottom of worksheet.

After that, one must choose the row and Hide from the format menu of the worksheet.