How To Hide-Unhide Columns Or Rows | Excel Tutorial
Channel: Burn to Learn
Date: 2023-06-07

Do you like our content? Buy us a cup of coffee!
https://ko-fi.com/burntolearn

Create amazing websites in just a few clicks with Squarespace
https://squarespace.syuh.net/burntolearn

There will be times when you want to hide columns or rows in your Excel document. To do it do this: 

Select the column you want to hide. Then right click and select the hide option If you want to hide columns sequenced together, select the first one and press the shift key then click the last column. 

Now right click then select the hide option. When the columns you want to hide are separated, click the first  column and hit the control key and select all of the separated columns. Then right click and select the hide option. Follow the same steps to hide a row or rows.  

As you can see the columns or rows are no longer visible. This does not mean that they have been deleted. They are only hidden. Once you have done this you will see two vertical lines in the middle of the 2 columns or horizontal lines between the rows where the hidden columns or rows are.  They represent the columns or rows that have been hidden. 

To unhide them you can double click on the 2 vertical or horizontal lines. Also you can right click on the lines and select the unhide option. Or select all of the document by clicking on this triangle in the upper left corner. Then right click on one of the columns or rows and select the unhide option.  And that’s it!


Burn To Learn - T-Shirts
https://burntolearn.threadless.com/designs 

Visit our website http://www.burntolearn.com. to see all our tutorials.
Facebook: https://www.facebook.com/burtolearn/
Twitter: https://twitter.com/btltutorials
Instagram - https://www.instagram.com/btltutorials/
LinkedIn - https://www.linkedin.com/company/burntolearn.com/
Reddit - https://www.reddit.com/user/burn-to-learn/

 ------------------------               ---------------------------               ------------------------------ 

#Excel #Microsoft  #exceltips  #exceltutorial #hide #unhide #columns #rows