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
M
Muskan Shaikh
5
very helpfull
M
Mohit
5
Good
Y
Yogesh bhatt
4
Practice worksheet bhi milengi kya is course me.
H
Hemant Mandal
4
For practical it's great for theoretical you need to study from somewhere else.
2
23HARD DISK
5
Good
M
Mahipal Chandra
5
Nice for poor family students
D
Deepanshu
5
Good
V
Vijay Kumar Rao
5
"The MS Excel Course was great! The lessons were clear and I learned many useful tips that I can use right away. I'm very happy with what I've learned. 4/5 stars."
P
Piyush Ranjan
5
yes i am happy to learn new things
R
Rufaro Mafandaedza
4
The course is really good but please put subtitles in English in your videos.
Share a personalized message with your friends.