ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how do i name the sheets after the months (https://www.excelbanter.com/excel-worksheet-functions/11101-how-do-i-name-sheets-after-months.html)

craig

how do i name the sheets after the months
 
I want to make a workbook 12 sheets long. One for Jan one for Feb and so on.
I read about renameing the sheet but i get an error that it wont let me. is
their something else i need to do?

Michael

Hi Craig
If you right Click on the sheet Tab and select Rename, you should be able to
type in January, February, etc. There are a number of naming convetions that
can't be used, "History" being one of them.
If, when you right Click on the sheet Tab, it is greyed out. It means the
workbook is protected and a password is required to open it.

HTH
Michael

"craig" wrote:

I want to make a workbook 12 sheets long. One for Jan one for Feb and so on.
I read about renameing the sheet but i get an error that it wont let me. is
their something else i need to do?



All times are GMT +1. The time now is 09:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com