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

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

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’t have the similar data.

To do any of the above you can simply right-click on the relevant sheet (where it may say Sheet1, sheet2, etc..)
Choose the relevant option.

For your particular question you have to choose Rename and enter the name of your choice (January, February, etc..)

Please note that you are allowed up to 31 characters to name the worksheet but it is advisable to keep it concise. The reason for this is because if you have lots of sheets and have large names for those sheets then you can only see couple of worksheet tabs at one time. Rest of them get hidden behind the horizontal scroll bar.

Also certain characters such as ? and : are not allowed when you are naming or renaming worksheets.

I hope that this has helped in answering your query. If it has then please mark this query as Resolved!! If not then please press the reply button and contact me for further clarification!!


Kindest Regards

Rajeev Rawat