| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
naming worksheet tabs
Sorry, you cannot.
Max length 31 Exception characters [ ] * ? / \ -- Jacob (MVP - Excel) "SHARON" wrote: i need to name a worksheet tab with a name that is more characters than allowed. Can you make the tab larger to accommodate a larger tab name? I know you can make the tab larger in properties/appearance/advanced; however, that does not allow me to type in more characters. -- Thanks, Sharon |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
naming worksheet tabs
Actually, i only have 28 characters/spaces...any idea why it's not allowing
me 31? -- Thanks, Sharon "Jacob Skaria" wrote: Sorry, you cannot. Max length 31 Exception characters [ ] * ? / \ -- Jacob (MVP - Excel) "SHARON" wrote: i need to name a worksheet tab with a name that is more characters than allowed. Can you make the tab larger to accommodate a larger tab name? I know you can make the tab larger in properties/appearance/advanced; however, that does not allow me to type in more characters. -- Thanks, Sharon |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
naming worksheet tabs
--Which version of Excel?
--Check for any extra spaces before or after the text string? --Post back with the sheet name you are trying? -- Jacob (MVP - Excel) "SHARON" wrote: Actually, i only have 28 characters/spaces...any idea why it's not allowing me 31? -- Thanks, Sharon "Jacob Skaria" wrote: Sorry, you cannot. Max length 31 Exception characters [ ] * ? / \ -- Jacob (MVP - Excel) "SHARON" wrote: i need to name a worksheet tab with a name that is more characters than allowed. Can you make the tab larger to accommodate a larger tab name? I know you can make the tab larger in properties/appearance/advanced; however, that does not allow me to type in more characters. -- Thanks, Sharon |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
naming worksheet tabs
oops....i actually had a blank space at the end, which was the
problem...problem solved...Thanks! -- Thanks, Sharon "SHARON" wrote: Actually, i only have 28 characters/spaces...any idea why it's not allowing me 31? -- Thanks, Sharon "Jacob Skaria" wrote: Sorry, you cannot. Max length 31 Exception characters [ ] * ? / \ -- Jacob (MVP - Excel) "SHARON" wrote: i need to name a worksheet tab with a name that is more characters than allowed. Can you make the tab larger to accommodate a larger tab name? I know you can make the tab larger in properties/appearance/advanced; however, that does not allow me to type in more characters. -- Thanks, Sharon |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| naming worksheet tabs | Excel Discussion (Misc queries) | |||
| Naming Worksheet Tabs? | Excel Worksheet Functions | |||
| Naming of tabs from data in a worksheet | Excel Worksheet Functions | |||
| Naming Worksheet tabs | Excel Discussion (Misc queries) | |||
| How can I automate the naming of worksheet tabs? | Excel Discussion (Misc queries) | |||
Linear Mode
