Hiding Data

The UK's most regular instructor-led training courses.
Training information: excel-training-course · Excel courses · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2003

Hiding Data

Sarita has attended:
Excel Intermediate course
Word Intermediate course
Powerpoint Introduction course
Powerpoint Intermediate Advanced course

by - delegate Sarita [5 posts] (2008 Jun 10 Tue, 17:01) Reply

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

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2009 Jan 22 Thu + 23 Fri	Southwark	0	FULL
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	4	book now	£475	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	5	book now	£485	£490
2003	2009 Feb 19 Thu + 20 Fri	Southwark	4	book now	£475	£485
2003	2009 Feb 26 Thu + 27 Fri	Bayswater	8	book now	£335	£365
2003	2009 Mar 12 Thu + 13 Fri	Bloomsbury	7	book now	£345	£399
Full Schedule: See all 43 Excel VBA course dates. Bookings currently available until 18th March 2010.

RE: Hiding Data

by - trainer Amanda diamond contributer [1298 posts] (2008 Jun 11 Wed, 14:36) Reply

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

by - delegate Sarita [5 posts] (2008 Jun 12 Thu, 14:53) Reply

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

Thank you.

RE: Hiding Data

by - delegate Sarita [5 posts] (2008 Sep 16 Tue, 11:39) Reply

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

· Reasons Why VBA for Excel Training Fails
· Microsoft Excel Training Course
· Excel in the Home Office
· Why Excel Training (Sometimes) Doesn't Work and What You Can Do About It
· Take the Anxiety out of Domestic Finances with Microsoft Excel

Please browse our web site to find out more about
excel-training-course and other Microsoft training courses.