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

cant unhide hidden cells

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Can't unhide hidden cells

Can't unhide hidden cells

ResolvedVersion 2010

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.

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

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

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

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

Excel tip:

Display pictures on Chart Data Point

Replacing a single chart data point bar with a picture.
Step 1: Left click on a bar. Then, wait, and do a second single click on the bar. This will select just one data point.

Step 2: Right click on the bar and select Format Data Point.

Step 3: On the fill effects tab, choose a picture. Browse for a picture for that bar. Indicate if you want it to be stretched or stacked. Repeat for each bar.

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.