i'll show you some easy steps how in the previous tutorial, we learned how to hide rows in excel. there are multiple ways to unhide columns in excel: we have already learned how to hide columns in excel. free course! click: teachucomp free learn how to hide and unhide columns and rows in microsoft excel at want all of our free excel 2013 videos? download our free ipad app at in this short video, i cover a few ways to quickly unhide columns in excel. but when it comes to unhiding columns in excel it can be a bit of a excel 2013 tutorial for beginners how to hide and unhide columns. How To Hide And Unhide Columns In Microsoft Excel 2013Īuthor and talk show host robert mcmillen explains how to hide and unhide columns in microsoft excel 2013. hold down the ⇧ shift key while you click the letter above the column to. select the columns on both sides of the hidden column. this will open your document that has hidden columns in excel. double click the excel document, or double click the excel icon and then select the document's name from the home page. or you can click the first column header, hold shift, and click the last column header in. to select multiple adjacent columns, drag through them. to select a single column, click the column header. and, you can select the columns you want to hide in a few different ways. you can quickly unhide all columns or rows as well. Applies to: microsoft ® excel ® 2013, 2016, 2019 and 365 (windows) you can hide or unhide columns or rows in excel using the context menu, using a keyboard shortcut or by using the format command on the home tab in the ribbon. this has been a guide to unhide columns in excel. if you want the ctrl 0 to work properly, you need to change the setting in the control panel. if you use a shortcut, it will be just a matter of seconds to unhide columns in excel. This is the most reliable shortcut to unhide columns in excel.

you can also easily hide one or more columns.

the hidden rows display again and are highlighted along with the surrounding rows. then, right click on the selected row headers and select unhide from the popup menu. To unhide a row, you must first select the rows both above and below the hidden row (s).

Unhide first column in excel 2013