Hide – Unhide Rows & Columns in Excel 13

I believe when working in Excel, we come to the point where we want to Hide a Column or a Row, in order to understand the data in the Worksheet. Sometimes a Worksheet that contains many data is confusing to read and time consuming, so we find ourselves wanting to make our Worksheet less crowdie, but not by deleting the data but hiding some. In this post I will describe how to Hide or Unhide Columns and Rows. All we have to do is to follow the steps below.

In the image below, we can see a table that is created with all the necessary information in it. Now, we assume that we want to hide the Columns B, C, D and E, in order to focus on the rest of the data. What do we do?

List Of Names

First, we must select the Columns B, C, D and E, and once selected we do a right click with our mouse on them. Straight away, the short cut menu appears, where from here we select the command Hide from the bottom of the shortcut menu as shown in the image below.

Shortcut Menu - Hide

Straight away, the selected Columns are hidden as shown in the image below. We can see that the viewable Columns are A, F, G, H and etc. The Columns that are not viewable are the ones that we selected before, which were B, C, D, and E.

Hidden Columns

Okay, now that we have Hidden the Columns, how do we make them viewable again? In order to make them viewable we must select the two Columns that contain the Hidden ones. In this example, we must select the Columns A and F, because the Columns B, C, D and E are in between the Columns A and F. Once selected, we do a right click with our mouse again, and from the drop down menu that appears we select the Unhide command from the bottom of the drop down menu and straight away the Hidden Columns will appear.

Shortcut Menu - Unhide

The same procedure we must follow in order to Hide Rows. In the image below I have selected the Rows 3, 4 and 5 and once selected we do a right click with our mouse on them. Straight away, the short cut menu appears, where from here we select the command Hide from the bottom of the shortcut menu as shown in the image below.

Hide Rows

Straight away, the selected Rows are hidden as shown in the image below. We can see that the viewable Rows are 2, 6, 7, etc. The Rows that are not viewable are the ones that we selected before, which were 3, 4 and 5.

Hide Rows

Okay, now that we have Hidden the Rows, how do we make them viewable again? In order to make them viewable we must select the two Rows that contain the Hidden ones. In this example, we must select the Rows 2 and 6, because the Rows 3, 4 and 5 are in between the Rows 2 and 6. Once selected, we do a right click with our mouse again, and from the drop down menu that appears we select the Unhide command from the bottom of the drop down menu and straight away the Hidden Rows will appear.

Unhide Rows

Another way to Hide Columns and Rows, or to Unhide Columns and Rows is to make sure we have selected the Columns or Rows that we want to Hide or Unhide and then from the Home tab we locate the area of the ribbon named Cells as shown in the image below. Once the Cells area is located we select the command Format. The Format drop down menu appears which we locate the Visibility area and under the Hide & Unhide area from the other drop down menu that appears we select either one of the commands Hide Rows, Hide Columns, Unhide Rows or Unhide Columns depending on what we want to do.

Visibility

In my next post I will describe the procedure on how to Hide and Unhide Sheets in a Workbook in Excel 13.

Below you can check out the video describing the procedure on how to Hide or Unhide Columns and Rows in Excel 13.

Hide – Unhide Rows & Columns in Excel 13

About officesmart

MVP: Honored with the MVP (Most Valuable Professional) for OFFICE SYSTEM title for the years 2011, 2012, 2013, 2014 and 2015 by Microsoft, for my contribution and commitment to the technical communities worldwide. Microsoft Master Specialist: This certification provides skill-verification tools that not only help assess a person's skills in using Microsoft Office programs but also the ability to quickly complete on-the-job tasks across multiple programs in the Microsoft Office system

Posted on February 24, 2015, in Excel English 2013, Microsoft Office 2013 English and tagged , , , , , , , , , , , , , , . Bookmark the permalink. Comments Off on Hide – Unhide Rows & Columns in Excel 13.

Comments are closed.