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
S
Sachin shakya
5
Im very happy, I'm learning excel in learnvern.com
G
Gowtham U G
5
Ok
K
Keshav dev Saini
5
Sir mujhe Excel ke all pdf notes chaiye pls send kardijiye
K
Kanika Garg
5
Understandable and easy explanation
R
RUPINDER KAUR
5
The course is straightforward for beginners to learn, and the tutor's voice is clear. However, we have some questions, such as how to use the keys on our laptop that aren't working, need help.
Mohd Asif Shaikh
5
Course is presented in simple and easy standard. But there is a mistake in Absolute video, the percentage option is not selected by the user so it is calcucate in mutiple option instead if percentage.
S
Supriya Sood
5
Very useful course and understanding easily all the things
M
Muhammad Faizan
5
I am really enjoying Learning from this platform, thanks
Share a personalized message with your friends.