Skip to main content

New Article

How to SUM by matching partial text in Excel

3 Different ways to Hide or Unhide Rows and Columns in Excel 2016

While working on large data table you may need to hide single row or some rows and single column or columns. In Microsoft Excel this is very common operational activities for all types of users. This feature allows you to hide less important rows or columns and keep your focus on important data area. On the other hand, if you need to update source data, set a new column or row formatting for your working area, or share your data table to others, then you may need unhide or show all the hidden rows or columns. So, it's good if you learn it.
 
This tutorial will teach you 3 different ways about how you can hide or unhide rows and columns singly or multiple in your Excel worksheet. As well as, after hiding rows or columns, I'll also share 3 different ways about how you can unhide the hidden rows or columns in Excel worksheet.
 
 
Start from Select Rows and Columns:
 
Before going to start our lesson, first off all you need to select the rows or columns perfectly. In this section you will learn how to select rows and columns in excel perfectly.

1. Single Row Selection:
 
A. Mouse Clicking:
 
Move your Cursor on any Row Number. Your Mouse Icon will change to Right Arrow. Then use your Left Mouse Click (for Right Handed Mouse user) on the Row Number to select that entire single row. Or Select any cell by clicking. Assume that you wish to select Row number 7, then Click on 7 from Row Numbers. Or click A7, D7, AZ7 or any.

 
B. Keyboard Shortcut:
 
If you wish to select the same row number 7, you can also perform it through Keyboard Shortcut. Move your cursor at Row number 7 of any Column, then press Shift + Spacebar at once to select that entire row.

 
C. Name Box: 
 
If you are unable to click on the Row Number 7 or even you are unable to place your cursor at any cell of row number 7 because of row height is very short, then you can take help from Name Box. Just type the cell address you want to place your cursor there. In this example, you need to enter A7 or D7 or any column name with mentioning row 7 and press Enter.
 
Info:
A Name Box is a feature, by which you can select any specific cell address
 
 

2. Multiple Continuous Rows Selection:

 
A. Mouse Clicking:

Click on the Row Number from where you want to start selection. For example 7. Press and hold Shift key. Click on the selection ending row number for example 16. This will select entire Row 7 to Row 16.


B. Keyboard Shortcut: 
 
Place your cursor at Row 7. Press Shift + Spacebar to select entire Row 7. Release the Spacebar only and then press the down arrow key from Cursor Key Set or Arrow Keys.

 
C. Name Box: 
 
From Name Box, just type C7:C16 and press Enter to select rows 7 to 16.
 

 
3. Multiple Random Rows Selection:

 
A. Mouse Clicking:
 
Click on Row Number from where you want to start selection. Press and hold Ctrl key only. Then Click on another few Row Numbers randomly. After finish the random clicking, release the Ctrl Key. Example, first Click on Row 11. Then Press and hold Ctrl key. Click on Row 5, Row 19, Row 14. And Then release Ctrl Key.

 
B. Keyboard Shortcut: 
 
Place your Cursor at Row 8. Press and hold Shift key and then Spacebar to select entire Row Number 8. Release Shift and Spacebar key. And Press and hold Ctrl key. Click on Row 5, Row 14. Release the Ctrl Key. Now Press Shift + Spacebar to select them.

 
C. Name Box:
 
From name box, Type B14,B17,B19 and press Enter to select these cells. Then press Shift + Spacebar to select entire last Row 19. Then release Shift + Spacebar key. Click on B17 and press Shift + Spacebar to select Row 17. Do it again for 14.

 
4. Single Column Selection:

 
A. Mouse Clicking:
 
Use your Left Mouse Click (for Right Handed Mouse user) on the Column Name to select that entire single column. Assume that you wish to select Column Name D, then Click on D from Column Name.


B. Keyboard Shortcut:
 
If you wish to select the same Column Name D, you can also perform it through Keyboard Shortcut. Move your cursor at Column D, then press Ctrl + Spacebar at once to select that entire column.
 
 
C. Name Box:
 
If you are unable to click on the Column Name D or even you are unable to place your cursor at any cell of Column Name D because of column width is very close, then you can take help from Name Box. Just type the cell address you want to place your cursor there. In this example, you need to enter D1 or D11 or any Row Number with mentioning Column D and press Enter to select Column D.



5. Multiple Continuous Column Selection:

 
A. Mouse Clicking:
 
Click on the Column Name from where you want to start selection. For example Click on Column D. Press and hold Shift key. Click on the selection ending Column Name F. This will select Column D to F.

 
B. Keyboard Shortcut:
 
Place your cursor at Column D. Press Ctrl + Spacebar to select entire Column D. Release the Spacebar only and then press the Right Arrow key from Cursor Key Set.



C. Name Box: 
 
From Name Box, just type D7:F7 to select Column D to Column F.




6. Multiple Random Columns Selection:

 
A. Mouse Clicking:
 
Click on Column Name from where you want to start selection. Press and hold Ctrl key only. Then Click on another few Column Name randomly. After finish the random clicking, release the Ctrl Key. Example, first Click on Column D. Then Press and hold Ctrl key. Click on Column G, Column F, Column I. And Then release Ctrl Key.



B. Keyboard Shortcut: 
 
Place your Cursor at Column D. Press and hold Ctrl key and then Spacebar to select entire Column D. Release Ctrl and Spacebar key. And Press and hold Ctrl key. Click on Column G, Column F. Release the Ctrl Key. Now press Ctrl + Spacebar to select them.


C. Name Box:
 
From name box, Type D14,B14,F14 and press Enter to select these cells as well as column. From Menubar Click on Home - Format and apply commands.




How to hide Rows in Excel:

There are 3 different ways to hide Rows in Excel. In this section, I would like to share how you can hide Rows by Mouse Clicking, from Menubar and from Keyboard Shortcut.

 
A. Hide Rows by Right Mouse Click:
  • Select the row or rows. For example 5, by clicking on Row Header. Or You can learn different selection ways as described earlier in this article. 
  • Right Click on that Row Header (Row number 5). 
  • A popup menu will appear. 
  • Click on Hide.


B. Hide Rows from Menubar:
  • Place your cursor in a single cell. For example B6.
  • Goto "Home - Format - Hide & Unhide - Hide Rows".


C. Hide Rows from Keyboard Shortcut:
  • Place your cursor in a single cell. For example C7.
  • Press and hold Ctrl key and then Press 9 (Ctrl + 9).


How to Unhide Rows in Excel:
 
There are 3 different ways to unhide Rows in Excel. In this section, I would like to share how you can unhide Rows by Mouse Clicking, from Menubar or Ribbon and from Keyboard Shortcut.

 
A. Unhide Rows by Right Mouse Click:
  • Select the row or rows. For example 5. By clicking on Row Header from Row 4 to Row 6 to select the previous and after hidden row. Or you can learn different selection ways as described earlier in this article. 
  • Right Click on that Row Header. 
  • A Popup Menu will appear. 
  • Click on Unhide.


B. Unhide Rows from Menubar:
  • Place your cursor in a hidden row cell. For example B6. You can take help of Name Box to place your cursor in a hidden cell as discussed earlier.
  • Goto "Home - Format - Hide & Unhide - Unhide Rows".


C. Unhide Rows from Keyboard Shortcut:
  • Place your cursor in a single cell. For example B6.
  • Press and hold Ctrl + Shift key and then press 9 (Ctrl + Shift + 9).



How to Hide Column in Excel:
 
There are 3 different ways to Hide Columns in Excel. In this section, I would like to share how you can Hide Columns by Mouse Clicking, from Menubar and from Keyboard Shortcut.

 
A. Hide Columns by Right Mouse Click:
  • Select the Column or Columns. For example C, by clicking on Column header.
  • Right Click on that Column Header (Column C).
  • A popup menu will appear.
  • Click on Hide.


B. Hide Columns from Menubar:
  • Place your cursor in a single cell. For example D6.
  • Goto "Home - Format - Hide & Unhide - Hide Columns".



C. Hide Columns from Keyboard Shortcut:
  • Place your cursor in a single cell. For example F7.
  • Press and hold Ctrl key and then press 0 Zero (Ctrl + 0).


 
How to Unhide Columns in Excel:

There are 3 different ways to unhide Columns in Excel. In this section, I would like to share how you can unhide Columns by Mouse Clicking, from Menubar and from Keyboard Shortcut.

 
A. Unhide Columns by Right Mouse Click:
  • Select the Columns. For example C4. By clicking on Column Header from Column B to Column D to select the previous and after hidden columns. Or You can learn different selection ways as described earlier in this article.
  • Right Click on that hidden Column Header.
  • A popup menu will appear.
  • Click on Unhide.

 
B. Unhide Columns from Menubar:
  • Place your cursor in a hidden column cell. For example G6. You can take help of Name Box to place your cursor in a hidden cell as discussed earlier.
  • Goto "Home - Format - Hide & Unhide - Unhide Columns".


C. Unhide Columns from Keyboard Shortcut:
  • Place your cursor in a single cell. For example E7.
  • Press Alt - o - c - u one after another (not at once).


Info:

Ctrl + Shift + 0
Shortcut key will not work in Excel to Unhide Columns. You need to use ALT - O - C - U one by one.
 
 
Video Tutorial: 
 


Comments

Popular posts from this blog

How to display an image in worksheet based on a List or based on IF condition?

Excel can show image on worksheet based on a specific IF condition. So, how to do it? Simple follow the below steps: Step by Step: Step 1: Insert images in your Excel Worksheet. Here I've inserted 5 different types of balls, Football, Cricket, Pool, Basketball, Tennis ball. Note that, All balls are placed into different cell. These are placed in Picture sheet. Image 1: 5 balls placed in 5 different cells and covered photo's wide and height Step 2: In the report sheet, design the report as you wish. I've designed in my way like below: Image 2: Kids asking to Donald Duck, which ball need to throw now Step 3: Make a drop down list "Games" in E6 cell in Report sheet from Data Validation. which is as below: Football Cricket Pool Basketball Tennis You can do an IF function here in E6 in Report sheet, which will meet a certain condition and returned Football, Cricket, Pool, Basketball or Tennis. Step 4: Now the tricky part is...

Cumulative Closing Balance like a Bank Statement in PivotTable

A Bank Employee in many case needs to calculate the Closing Balance after each transaction in PivotTable like a Bank Statement . But with the help of Calculated Field of a PivotTable , you can only calculate Field with Field . It's not possible to use a formula in Calculated Field where you can mention a single cell with Relative Reference Cell . Because a PivotTable acts like a Table format where you can work with Field or Column Name . A Helping Column (A regular column, that helps to get a partial result where formula applied) can be a good idea. But there is an option in PivotTable by which you can Calculate Cumulative . In this article I will show you, how you can do it. Calculating with Formula: Assume that, you have an Excel file with Debit and Credit transaction of an Account . Image 1: Sample Bank Statement In a Bank Statement , Month wise Cumulative Balance is important. In the Excel sheet, as above, it is very easy to use a formula and calc...

Value Paste and Formula Paste

In many case, in our professional life, we need to do Copy and Value Paste or Copy and Formula Paste in all most always. Those employees, who works under MIS Department, have to do it lots of time in a single day to prepare reports. It is very time costing task in Office. Many of us use Excel Menubar to do it, others are using Keyboard Shortcut by pressing ALT key (like for Value Paste Press ALT+H+V+V and for Formula Paste Press ALT+H+V+F ). But did you noticed that, these two ways strongly need your attention to do this task. More clearly, if you choose Value Paste from Menubar , then what you need to do? First you should take the mouse in Hand Wheel the mouse in Home menu Then Click on Paste Then you pressure your eyes to find the Value Paste icon And then Click on it to paste it These all steps can take more than 1 second. Am I right? Below is an image of this process: Image 1: Value Paste from Home Menu On the other hand, if you choose the shortcut f...