How to Hide/Unhide Columns, Rows, and Sheets in Excel 2010

Excel 2010 has a superb component to cover the chosen rows, segments, and sheets, this could be exceptionally convenient particularly when you need to shield particular substance from any kind of hindering use. Dispatch Excel 2010 exercise manual in which you need to shroud lines, sections or sheets. For outline, we have incorporated an exercise manual containing different sheets in which we will shroud lines, sections and so on.

Also Read:  How To Recover Deleted Facebook Messages

How to Hide Rows in Excel

In wanted spreadsheet select the lines (for different non-infectious determination hold Ctrl key) you need to cover up and explore to Home tab. From Cells gathering, click Format catch. Presently from Hide and Unhide alternatives, click Hide Rows. Upon click it will naturally shroud the chose lines. The lines 2,3,5 and 7 numbers are presently covered up.

Also Read:  How to Print in Black and White

How to Hide Cells in Excel

For concealing the sections in particular sheet, select the segments you need to stow away.

Rehash a similar methodology for it, from Format – > Hide and Unhide alternatives, click Hide Columns, upon tap the chose sections will be covered up.

How to Hide Sheets

Presently select the sheet which you need to stow away.

Also Read:  Download “IMO” – The Best Video Calling Software for PC/Mobile

Snap Hide Sheet from Hide and Unhide alternatives.

Upon tap the entire sheet will be hidden.

Unhide Rows, Columns, and Sheets

For uncovering the shrouded sheets, lines and segments, click Format, and from Hide and Unhide alternatives, tap the individual choice accessible in the menu.