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%
19%
6%
3%
3%
Reviews
K
Karan Baghel
5
nice
M
Mohammed Zameeruddin
5
This is a valuable course that explains almost everything.
M
Md Sahal Al Ibrahim
5
This is a valuable course that explains almost everything.
H
Haider Ali
5
I never saw this type of course. Such incredible modules you added, every video is this worthy, because many courses' videos are worthless, we could learn nothing at the end.
M
MD SHAKIR
5
VERY HELPFUL
P
Prashant Sharma
5
start learning with learnvern
G
Ganesh kachare
5
Very good course
A
ABDUR REHMAN
5
Hint for the excel assignment 9?
M
Mahnoor
5
Which excel version is used ? Kindly tell me because i want to download it. I saw very first video which is quite easy and understandable.
Share a personalized message with your friends.