fsgerma.blogg.se - Jow to unhide a column in excel

#Jow to unhide a column in excel how to#
#Jow to unhide a column in excel free#

How to unhide column A using the Go To option Pick one of the tricks below to unhide only the first column in your table. Unhiding columns in Excel may seem easy until you have several hidden columns but need to display only the left-most one. Or you can right-click the selection and choose Unhide from the context menu, or just press the Unhide columns shortcut: Ctrl + Shift + 0 How to unhide first column in Excel Go to the Home tab > Cells group, and click Format > Hide & Unhide > Unhide columns.For example, to show hidden column B, select columns A and C. Select the columns to the left and right of the column you want to unhide.If you have an Excel table where multiple columns are hidden and want to show only some of them, follow the steps below. How to show hidden columns that you select

#Jow to unhide a column in excel free#

If you don't know VBA too well, feel free to explore its possibilities by reading our article How to insert and run macros.

Click on a small triangle in the upper-left corner of your table to select the entire worksheet.

Whether you have one or several hidden columns in your table, you can easily display them all at once using the Excel Unhide option.

Show all hidden columns in Excel via Go To Special.

Unhide the first column by expanding it.

Unhide all columns automatically with VBA.

In this post I'll share how to show hidden columns using the standard Excel Unhide option, a macro, the Go To Special functionality and Document Inspector. If you happen to work with Excel files where some columns are hidden, you may want to know how to unhide columns in Excel to view all data. It's possible to conceal some columns by using the Hide feature or by setting the column width to zero.

The possibility to hide columns in Excel is really helpful. It will teach you to show all hidden columns or just the ones you select, how to unhide first column, and more. From this article, you'll learn how to unhide columns in Excel 2016 - 2007.