excel-training-advanced courses - arranging sheet

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

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

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:

Display developer tab - Excel 2010

a. In Excel, click on the File tab
b. Select Options from left hand side
c. Choose the Customize Ribbon section
d. Click the box next to Developer in the list of tabs on the right hand side of the dialog box. When ticked the Developer tab will be visible.
e. Click OK to apply your changes

View all Excel hints and tips


Server loaded in 0.09 secs.