Learn how to unhide columns in Excel. Hiding columns is easy. But when it comes to unhiding columns in Excel it can be a bit of a challenge. These tips will help you master hiding and unhiding both columns AND rows (jump to topics in video using links in description below).

Learn how to unhide a single column, or all of your columns, how to unhide Column A without unhiding ALL columns in the worksheet, and how to unhide Row 1.

Jump quickly to a topic in the video:
– how to unhide columns in Excel 00:00
– how to hide columns 01:16
– when it looks like unhide column is not working 02:30
– how to unhide all columns 02:48
– how to unhide only the columns you need 03:36
– how to hide rows 04:30
– how to unhide rows 04:40
– how to unhide row 1 04:47
– how to unhide column A 06:04

Grab our Free Guide to the ‘Steps to becoming Proficient in Excel’. An AWESOME tool to use to assess your current skill level, identify gaps in your knowledge and learn where to find the info you’ll need to fill in any gaps you have identified.
Find our more here: https://excelatwork.co.nz/subscribe-eawi/

Read the full blog post here: https://www.excelatwork.co.nz/2019/11/27/how-to-unhide-columns-in-excel/

VERSION FRIENDLY
Try this with Excel 2007, 2010, Excel 2013, Excel 2016, Excel 2019 and Excel for Office 365.
Sharyn’s using the desktop version of Excel for Office 365 as part of the Office 365 Business Premium subscription.

#ExcelTutorial #ExcelTips #ExcelBeginner #ExcelatWork

Please take the opportunity to connect and share this video with your friends and family if you find it useful.