Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

columns hidden then unhidden

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Columns hidden then unhidden have no width and require teasing o

Columns hidden then unhidden have no width and require teasing o

ResolvedVersion 2010

Liz has attended:
SharePoint course

Columns hidden then unhidden have no width and require teasing o

This effect is simliar to the problem I report 23 November. On that occasion it was rows and turned out to be related to filtering.
This time it is columns. I manually hid some to create a custom view. Then I selected all and unhid with a view to creating a different custom view. The hidden columns didn't unhide. I can manually slide them out but thats not satisfactory. I have tried closing the custom view and even deleting it.
What is causing this please and how do I resolve it?

RE: Columns hidden then unhidden have no width and require teasi

Hello Liz,

Thank you for your post. I simulated on my Excel the steps you mentioned, including the saved view. What worked for me was to select the entire worksheet (top left corner), then right-click on any column header and select Unhide from the options. All my hidden columns opened up.

If you have already tried these steps and they didn't work, please post again and we'll look for a different solution.

Kind regards
Marius Barnard
Excel Trainer

Excel tip:

Formula for last day of month

In some cases it is necessary to find the last day of a month for a given date. If you use the following formula, you can achieve this, ie; if you have a column of dates, use this formula to find the end of month for each day by using the fill handle. The formula is as follows, and assumes in this example that the first date in question is in cell C5, in any other cell type; =DATE(YEAR(C5),MONTH(C5)+1,1)-1

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.