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
  • Mobile
  • 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:

Create Pivot Table in Excel feature imageHow to Create a Pivot Table in Excel? Graph in Excel - featured ImageHow to Create a Graph 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 Add Hyperlink to Another Sheet in Excel?
  • How to Add and Remove Watermark in Excel
  • How to use Relative and Absolute Cell Reference in Excel?
  • How to Enable and Disable Scroll Lock in Excel?
  • How to Use INDEX and MATCH Functions in Excel?
  • How to Make Bar Graph in Excel?
  • How to Count Duplicate Values in Excel?
  • How to Wrap Text in Excel?
  • How to Round off Numbers in Excel?
  • How to Create a Bell Curve in Excel?

Related Searches

  • How to Stop Uploading Updates to the other PC’s in Windows 10
  • How to Disable Right Click on Images in Wordpress through Code / Plugin
  • How to Reduce Boot Time of Windows 7
  • How to create a Paytm account
  • How to Download & Install Skype on Windows 10?

Copyright © 2023 · QueHow · Contact Us