hiding data

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Hiding Data

Hiding Data

resolvedResolved · Low Priority · Version 2003

Hiding Data

What other uses would this be used for apart from hiding it when sending to someone else?

RE: Hiding Data

Hi Sarita

Thank you for your question and welcome to the forum.

I have used the Hide feature before when I am creating a spreadsheet and I want to keep historical data but not see it.

For example, now that it is June 2008 I would hide the figures for May 2008 as I will not be amending those figures anymore since May has passed. On the other hand, I don't want to delete the figures either.

So I hide them instead so I still have access to them if I ever need them but they don't take up room in my spreadsheet.

I hope this helps.
Amanda

RE: Hiding Data

Thank you Amanda - it has given me an idea of what else I can do.

Thank you.

RE: Hiding Data

Thank you, it has helped. I have actually wanted to hide data to reduce my spreadsheet.


 

Excel tip:

Number format shortcut

Ctrl+Shift+! applies the Number format, with two decimal places

View all Excel hints and tips


Server loaded in 0.09 secs.