training courses in excel - Text Boxes

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

Resolved · Low Priority · Version Standard

Text Boxes

Rebecca has attended:
Excel Intermediate course

by - delegate Rebecca [2 posts] (2008 Jan 23 Wed, 16:05) Reply

Hi,

I have created a work sheet with a text box underneath the data.

However, when i hide columns on the sheet, the text box becomes unreadable.

How do I set the text box so it remains in tact and visible regardless of whether I hide or reveal columns?

I am using Excel 2003.

Many thanks

Rebecca

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 9 Fri	Bloomsbury	1	book now	£240	£245
2007	2009 Jan 14 Wed	Bloomsbury	5	book now	£235	£245
2002/XP	2009 Jan 14 Wed	Tooting	0	FULL
2003	2009 Jan 16 Fri	Southwark	0	FULL
2007	2009 Jan 21 Wed	Bloomsbury	3	book now	£240	£245
2003	2009 Jan 21 Wed	Southwark	2	book now	£235	£240
Full Schedule: See all 114 Excel Advanced course dates. Bookings currently available until 31st March 2010.

RE: Text Boxes

by - trainer Mark gold contributer [328 posts] (2008 Feb 1 Fri, 13:39) Reply

Hi Rebecca

Hope you are fine

When you use text boxes in excel you will need to do certain things to make this visable at all times

Firstly you will need to select the text box so you can the little grap handles, then secondly you will need to right click the text box so that a little options menu appears, but make sure you right the border of the text box then click format text box.

You will then see a window with six tabs at the top click the properties tab and choose dont move or size with cells, then lastly click OK

this should solve your problem

Mark East