#Unhide a column in excel 2010 how to
#Unhide a column in excel 2010 windows 10

Then, right-click and pick вЂњUnhideвЂќ in the shortcut menu. The used columns with column headers are listed on listbox. He suggested using File Info Inspect Workbook Inspect Document Check the 'Hidden Rows and Colmns' item only, then Inspect.

#Unhide a column in excel 2010 windows 10

You can do this easily by dragging through them. Unable to unhide Row A in Excel (Version 2010 and Windows 10 Up to date) I have asked the question and had many replies, including from Arck Tang. Select the columns on each side of the hidden column(s). When youвЂ™re ready to view those hidden columns, unhiding them is just as simple as hiding them.

#Unhide a column in excel 2010 how to

RELATED: How to Freeze and Unfreeze Rows and Columns in Excel Unhide Columns in Microsoft Excel There are a few other ways to unhide the column, as well, but (as I said) I find such approaches a bother. Enter cell F1 into the Name box and then press Ctrl+Shift+0 to unhide the column. If youвЂ™d like to keep certain columns on screen while you scroll through your spreadsheet, learn how to freeze columns and rows in Excel. Enter cell F1 into the Name box and then use the controls available through the Format tool on the Home tab of the ribbon to unhide the column. This is a good thing to keep in mind if youвЂ™re looking for data you donвЂ™t see. You can unhide a column by selecting the two columns surrounding the column (for example, if you hid column B, you would select columns A and C), right-clicking one of the selected columns, then clicking the Unhide option. Here we outline a couple of time-saving ways to hide and unhide your Excel columns and rows. If youвЂ™re using a Mac, this indicator may appear as a bold green line. There are several ways to hide and unhide columns and rows in Excel. Right-click one of them and pick вЂњHideвЂќ in the shortcut menu.ДЄfter you hide columns in Excel, youвЂ™ll see a thick white line indicator between the remaining column headers. Once you choose the columns you want to hide, theyвЂ™ll be highlighted. To select multiple non-adjacent columns, click the first column header, hold Ctrl, and click the remaining column headers.Or you can click the first column header, hold Shift, and click the last column header in the range. 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.