Selecting Multiple Worksheets

The UK's most regular instructor-led training courses.
Training information: visual+basic+excel · Excel courses london · VBA training in London

Resolved · Low Priority · Version Standard

Rebecca has attended:
Excel Advanced course

by - delegate Rebecca [14 posts] (2008 Feb 21 Thu, 14:58) Reply

Hi

I would like to autoformat columns A-J in 5 worksheets within onw workbook. How do I select all worksheets? I have tried using Array but this has not worked.

Many thanks

Becky

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Jul 9 Wed	Bloomsbury	0	FULL
2003/XP	2008 Jul 9 Wed	Bayswater	2	book now	£195	£205
2003/XP	2008 Jul 16 Wed	Tooting	0	FULL
2003/XP	2008 Jul 16 Wed	Bloomsbury	1	book now	£235	£240
2003/XP	2008 Jul 18 Fri	Southwark	4	book now	£224	£235
2003/XP	2008 Jul 23 Wed	Southwark	0	FULL
Full Schedule: See all 143 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Selecting Multiple Worksheets

by - trainer Mark gold contributer [151 posts] (2008 Feb 29 Fri, 15:35) Reply

Hi Becky

Thank you for coming on the training course

In relation to your question what you will need to do is highlight the cells you want to auto format then hold hold the control (ctrl) then click on the sheet tabs you also want to include then go to the format menu, and click auto format and apply the format you need

This should solve your problem

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn’t and you need further clarification then please press the reply button and ask for further clarification with your specific question. In case you have a related question then please ask the question as a separate posting.

Mark east