In most cases in Microsoft excel worksheet, it is necessary
to hide or unhide certain rows or columns so as to make the whole worksheet
compact and readable without scrolling to the right and left or up and down.
For example, if you want to insert chart into a worksheet
and you don’t want certain columns or rows to appear on the chart, it is
necessary to hide and later unhide those columns and rows when you are through
with the chart.
In this tutorial, I will be taken you through the steps of
hiding and unhide rows and columns in Microsoft excel worksheet. So sit back
and follow me along.
Table of Content
- Explanation
- Hide Columns and Rows
- Unhide Columns and Rows
EXPLANATION
From the above figure, it can be seen that students are
offering six subjects. The first subject is English follow by Mathematics,
Chemistry, Physics, Biology, Geography. what happen if we want to plot a pie
chat of students names against Mathematics scores. The problem here is that
English column is between Name and Mathematics columns, and we need to select
both Name and mathematics columns to insert the pie chart in the worksheet.
The solution to this problem is to hide the middle column (English)
and then select the remaining columns (Name and Mathematics).
Hide Columns or Rows
The following steps below apply to both row and column
Step one:
Select the column or row
Click on the heading to select it as shown in the figure
below
Steep two:
Right-click and from the drop down menu, select “Hide”
Outcome
Unhide Column or Row
The following steps below apply to both row and column
Step one:
To unhide a column or row, select the column or row to the
right and left or up and down of the column or row you have already hidden.
ReplyDeleteGreat Article! This blog is useful for everyone. Turnao is a web-based application used to Convert excel spreadsheet to online database.
Thanks for the comment.
ReplyDeleteAwesome write up.. Visit my blog too 👇
ReplyDeleteNaira Techs
Thanks for sharing such amazing content which is very helpful for us. Please keep sharing like this. Also check to learn Microsoft Excel 2007 for Beginners or many more.
ReplyDeletePretty good I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I'll be subscribing to your feed and I hope you post again soon. Big thanks for the useful info.
ReplyDeleteExcel pivot table calculated field