Rows holding the information that you don't need to see or don't want to print can be hidden. To hide a cell, choose it from the row(s) to be concealed. On the Home command tab, in the Cells group, click Format. Select Hide & Unhide > Hide Rows from the Format menu's Visibility section. The row is obscured.
Excel, the most popular spreadsheet software, has a number of features to help you manipulate data and create graphs. One of these features is the ability to hide rows or columns.
To unhide rows and columns in Excel:
Click on the View tab
Check "Unhide" under "Row" or "Columns"
Select a row or column from the list
The Hide-Unhide Row and Column in MS Excel is a powerful feature that allows you to easily hide rows or columns of data. You can then unhide them later on when you need to use the information again.
To hide or unhide a row or column, follow these steps:
Click on the row or column header that you want to hide or unhide.
Click on the "Home" tab at the top of the screen and click "Hide & Unhide".
Select "Hide Row" or "Hide Column" from the drop-down menu, depending on what you want to do.
It helps you to focus on the data that is most important for you by hiding rows or columns of information. You can also use the Hide-Unhide Row and Column in MS Excel feature to create space between columns of data so that they are easier to read when they are side by side.
Learner's Ratings
4.4
Overall Rating
69%
20%
6%
3%
2%
Reviews
U
Uttam Kumar Bose
5
9
S
SOHAIB HAFEEZ
4
i save my file and after some time i want to change my file but i need boaht the original form and edited file now what i should do?
V
Vishesh
5
Very good
M
MANISH KUMAR
5
Awesome!
A
Anita mohanlal Kumawat
5
Ok
K
Komal Sharma
5
Thank you so much sir/ma'am, I taught you in a very easy way
Share a personalized message with your friends.