Can't unhide hidden cells

Resolved · Medium Priority · Version 2010

Tue 15 May 2018, 15:32 Delegate Anita said...

Anita has attended:
Excel Advanced course

Can't unhide hidden cells

Columns A-C can't be seen, I can only see columns D onwards on screen. I have tried un-hiding from the start to column D though it doesn't alter anything.

Tue 15 May 2018, 19:59 Trainer Jens said...

RE: Can't unhide hidden cells

Hi Anita,

Thank you for the forum question.

Please place you mouse courser before column D at the top. The mouse courser will change to a move tool (a left and right arrow). Click and drag towards right.

I hope this makes sense.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Wed 16 May 2018, 11:54 Delegate Anita said...

RE: Can't unhide hidden cells

Hi Jens,

When I put the curser to where you describe, the move tool didn't appear. I have also checked the column width wasn't the problem and it looks to be fine.

Any more ideeas?
Thanks

Wed 16 May 2018, 13:22 Trainer Jens said...

RE: Can't unhide hidden cells

Hi Anita,

I will have to look at the file to find the reason.

If it is possible please send the file to:

info@microsofttraining.net

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Wed 16 May 2018, 13:32 Delegate Anita said...

RE: Can't unhide hidden cells

Hi Jens,

It just dawned on me to cut and paste it into a new worksheet which has brought all the information across!
Thanks for your help.

Regards,
Anita

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

The Easiest Way to See a Sum or Average in Excel 2010

Did you know the quickest and most simple way of working out the average or sum of a set of numbers?

Highlight numbers in cells or type some numbers in cells and then look at the status bar at the bottom of the window. Here you will see a display of the average of the numbers, as well as a count of the cells and the sum of these cells.

View all Excel hints and tips