excel+training - tabs bottom worksheet
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 - Tabs at bottom of worksheet

excel+training - Tabs at bottom of worksheet

resolvedResolved · Low Priority · Version Standard

replyReply Wed 2 Jan 2008, 15:47Delegate Carol said...

Carol has attended:
Excel Introduction course

Tabs at bottom of worksheet

Please could you tell me how to create the tabs at the bottom of the worksheets for days, months etc

For upcoming training course dates see: Pricing & availability

replyReply Thu 3 Jan 2008, 12:35Trainer Katie said...

RE: Tabs at bottom of worksheet

Hi Carol,

Thank you for your question.

The tabs at the bottom of the worksheets are the labels for each worksheet. To create a new tab, click on the INSERT menu > WORKSHEET.

To rename it, simply right click on the label then choose RENAME & type the days/month as necessary.

Hope this helps.

Regards,

Katie

replyReply Thu 3 Jan 2008, 12:38Trainer Rajeev said...

RE: Tabs at bottom of worksheet


Dear Carol

Thank you for attending Excel Intro Training. I hope you enjoyed the training.

The tabs at the bottom of file are known as Work sheet tabs. MS Excel has been programmed to display three worksheets when ever you create a new file ( also known as Work book in Excel).

The users has the flexibility to delete , move around, copy, rename and insert more sheets as per their requirements. you can even have separate colours for the sheets. This is particularly helpful if you have similar kind of data in various spreadsheet and want to distinguish it from the sheet that doesn

 

Excel tip:

Showing all menu items

If you go into a pull down menu you usally find that you get a selection of items(this is the default) or sometimes everything. If you only get a selectiopn you have to go to the double arrows at the bottom of the menu and click it to get all of the hidden items.
To turn this off so that you always get everything, go to Tools / Customize / Options Tab / "Always show full menus". Make sure there is a tick in the box and you will always have every item.

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