Do you ever need to look at specific columns or rows of data that are located far apart from one another on your worksheet? Or maybe there's so much data in the worksheet that it's difficult to focus on the information you care about at the moment. There's an easy way to deal with this in Excel. Simply hide the rows or columns you don’t want to see so you can view just the data you want to work with. When you want to see all your data again, just unhide the rows or columns that are hidden. Watch this demo to see how to do it.

How to do it (text version):

• Hide or display rows and columns

 Problems watching the video? Try our troubleshooting tips.