QueHow

A How-To and wiki Blog

  • Operating System
    • Windows
      • Windows 10
      • Windows 7
    • Linux
  • Software
    • Application Software
    • Microsoft Office
      • Outlook
      • Word
      • PowerPoint
  • Internet
    • Browsers
      • Mozilla Firefox
      • Google Chrome
    • CMS
    • Tips & Tricks
  • Website
    • ecommerce
    • Google
    • Social Networking
    • General Websites
  • Email
    • Gmail
  • Wiki

How to Hide and Unhide Rows & Columns in Excel?

By Neha T Leave a Comment

Have you ever hide and unhide rows & columns in excel? In some excel sheets we store our everyday information like attendance of office staff, we create an everyday to-do list etc. Putting everyday data in an Excel sheet creates numerous rows and columns in the sheet. Too many columns and rows in the sheet makes it voluminous. Analysing such a voluminous spreadsheet become a headache.

In fact, sometimes we don’t even need to analyse the entire data we only need to inspect some part of the data. In this case, there may be some rows or columns in the sheet which we may not want to review in our current investigation. So, instead of deleting those rows and columns we can hide it for some time till we are examining data of our interest & when we are done we can unhide the hidden rows or columns.

The hidden rows and columns do not appear on the sheet as their size is reduced to zero. While printing the excel sheet, the hidden rows and columns of an excel sheet do not get printed. Let us move to the steps to hide and unhide columns in excel.

Steps to Hide and Unhide Rows & Columns in Excel:

Hide Columns in Excel

Step 1: Select the number of columns from the column header that you want to hide. Like, in the image below you can see that I have selected column C and Column D.

hide columns 1

Step 2: Right-click on the selected column and you will see some options. From the given options you have to select Hide.

hide columns 2

You can easily recognize the hidden columns in the sheet. As the alphabets representing the hidden columns will be missing from column header and you can see two very small parallel lines in the column header in place of hidden columns as you can see in the image below.

hide columns 3

Hide Rows in Excel

Step 1: Select the number of rows from the row header that you want to hide. As you can see in the image below I have selected row 4 and 5.

hide rows 1

Step 2: Right-click on the selected rows and some options will appear. Among the displayed options select Hide.

hide rows 2

Like columns, you can easily recognize the hidden rows in the Excel sheet. As the numbers representing the hidden rows will be missing from the row header. Two very small parallel line will appear in the row header, in place of hidden rows as you can see in the image below.

hide rows 3

Unhide Columns in Excel

Step 1: Select the column before the hidden column and the column after the hidden column. In the image below you can see that I have selected column B and column E as I want to unhide column C and column D.

Unhide columns 1

Step 2: Right-click on the selected columns and it will display some options. Among the displayed option click on Unhide.

Unhide columns 2

Now, the hidden columns between the selected columns will now start appearing on the Excel sheet. You can observe the image below, column C and column D are appearing on the screen.

Unhide columns 3

Unhide Rows in Excel

Step 1: Select the row before the hidden row and the row after the hidden rows in the row header. Observe the image below, as you can see that row 4 and row 5 is hidden that’s why I have selected row 3 and row 6.

Unhide rows 1

Step 2: Right-click on the selected rows and it will display some options. Among the displayed option click on Unhide.

Unhide rows 2

Now, the hidden rows will start appearing on the excel sheet. In the image below, you can observe that row 4 and row 5 are now appearing on the Excel sheet.

Unhide rows 3

So, this is all about hiding and unhiding the rows and columns in the Excel sheet.

You Might Also Like:

Graph in Excel - featured ImageHow to Create a Graph in Excel? Create Pivot Table in Excel feature imageHow to Create a Pivot Table in Excel? how-to-transpose-in-ms-excel-2016-featured-imageHow to Transpose in MS Excel 2016? Merge Cell in Excel feature imageHow to Merge Cells, Columns & Rows in Excel? how-to-freeze-row-and-column-in-ms-excel-in-2016-featured-imageHow to Freeze Rows and Columns in MS Excel 2016? delete blank row feature imageHow to Delete Blank Rows in Excel 2016? compare two columns in Excel Feature imageHow to Compare Two Columns to Find Matches & Differences in Excel 2016? Hide Formula in Excel - feature imageHow to Hide Formula in Excel?

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Most Viewed

  • How to Install and Use TELNET in Ubuntu
  • How to install Hindi fonts in MS Word
  • How to Change a File Extension in Windows 10?
  • How to create a flipkart account in 3 simple steps
  • How to Change Monitor Refresh Rate in Windows 10?
  • How to install IIS on Windows 10
  • How to Insert Clickable Checkbox in MS Word 2016?
  • How to Set Auto Reply in Outlook 2016?
  • How to Login as Administrator in Windows 10?
  • How to Check RAM Size and System Type in Windows 10?

Recent Additions

  • How to Remove Background Noise in Power Director?
  • How to Repost on Instagram Story?
  • How to Tag Someone on Instagram Post?
  • How to Fade Out Video in Power Director?
  • How to Tag Someone on Instagram Story?
  • How to Add Music on Instagram Story?
  • How to Save Video in Power Director?
  • How to Add Multiple Pictures on Instagram Story?
  • How to Post a Story on Instagram?
  • How to Unblock Someone on Instagram?

Related Searches

  • How to create a password protected folder in Ubuntu 14.04
  • How to Clear Cache and Cookies in Google Chrome?
  • How to Create a Desktop Shortcut on Windows 10
  • How to enable right side chat in gmail
  • How to contact Snapdeal

Copyright © 2021 · QueHow · Contact Us