excel-training-advanced courses - arranging sheet
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel-training-advanced courses - Arranging the sheet

excel-training-advanced courses - Arranging the sheet

resolvedResolved · Low Priority · Version Standard

replyReply Thu 8 Nov 2007, 12:22Delegate Muhammad said...

Muhammad has attended:
Excel Advanced course

Arranging the sheet

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

For upcoming training course dates see: Pricing & availability

replyReply Tue 13 Nov 2007, 16:22Trainer Andrew said...

RE: Arranging the sheet

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 tip:

Auto-insert the current time

In Microsoft Excel, to enter the current time into a cell, hold CTRL+SHIFT and press SEMICOLON.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard