| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy comments to several sheets in a workbook? | Excel Worksheet Functions | |||
| PROTECTING/UNPROTECTING SHEETS | Excel Discussion (Misc queries) | |||
| Multiple sheets selected | Excel Discussion (Misc queries) | |||
| Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) | |||
| CountIF across multiple sheets in a workbook | Excel Worksheet Functions | |||
Hybrid Mode
