excel-training-advanced courses - Arranging the sheet

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

Resolved · Low Priority · Version Standard

Arranging the sheet

Muhammad has attended:
Excel Advanced course

by - delegate Muhammad [6 posts] (2007 Nov 8 Thu, 12:22) Reply

can we arrange the sheets in alphabatic order in one data excel file and can we rename our sheets accoding to current date

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	4	book now	£485	£490
2003	2009 Jan 22 Thu + 23 Fri	Southwark	1	book now	£495	£495
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	6	book now	£450	£485
2003	2009 Feb 26 Thu + 27 Fri	Bayswater	8	book now	£335	£365
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 18th March 2010.

RE: Arranging the sheet

by - trainer Andrew platinum contributer [576 posts] (2007 Nov 13 Tue, 16:22) Reply

Hi Muhammad

You can get Excel to manipulate sheet order and names in a workbook by using the programming language Visual Basic for Applications or VBA. Follow this link for info on our Excel VBA courses.

· Excel Macros for the Non-Programmer
· Advanced Excel and PivotTable Reports
· What's Better Than the Help Function in Excel? Microsoft Training
· How to Create Better Excel Spreadsheets: Part Three
· Do You Really Need Excel VBA Training?

Excel tip:

Sorting data stored in rows

Primarily Excel is set up to sort data that is stored in columns rather than rows.

It is possible to get Excel to sort data stored in rows however.

Click in the row you want to sort, or select the cells in the rows you wish to sort.

Go to Data - Sort, then go to the Options button in the bottom left corner of the Sort dialogue box.

View all Excel hints and tips

Rate this page: