Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet Tab Names
Does it matter what the name of a worksheet tab is at all? I would like to
place in a hyphen when I create the tab like Jan-Feb. When I calculate my formulas will this hyphen mess me up when it comes to calculating? I would think no since the tab is usually in quotes or so within the formula correct? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet Tab Names
You can use a hyphen in sheet names. When you need to refer to
that sheet, enclose the sheet name in single quotes: ='Jan-Feb'!A1 -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Refman" wrote in message ... Does it matter what the name of a worksheet tab is at all? I would like to place in a hyphen when I create the tab like Jan-Feb. When I calculate my formulas will this hyphen mess me up when it comes to calculating? I would think no since the tab is usually in quotes or so within the formula correct? Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet Tab Names
You're correct, the characters aren't seen as a part of a formula.
Hope this helps. -- John Cello John Cello Consulting Communications For Business www.johncelloconsulting.com "Refman" wrote: Does it matter what the name of a worksheet tab is at all? I would like to place in a hyphen when I create the tab like Jan-Feb. When I calculate my formulas will this hyphen mess me up when it comes to calculating? I would think no since the tab is usually in quotes or so within the formula correct? Thanks. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet Tab Names
Next time you're experimenting, you can see how excel treats those names.
Create a test workbook with two worksheets. Call them A and B. In B1, put =a!a1 Now rename A to Jan-Feb and then look at what excel did to the formula. Refman wrote: Does it matter what the name of a worksheet tab is at all? I would like to place in a hyphen when I create the tab like Jan-Feb. When I calculate my formulas will this hyphen mess me up when it comes to calculating? I would think no since the tab is usually in quotes or so within the formula correct? Thanks. -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet Tab Names
Thanks everyone for your quick replies. I wanted to make sure as someone at
work said they messed it up if you put hyphens and what not in. Thanks again. ;) "Dave Peterson" wrote: Next time you're experimenting, you can see how excel treats those names. Create a test workbook with two worksheets. Call them A and B. In B1, put =a!a1 Now rename A to Jan-Feb and then look at what excel did to the formula. Refman wrote: Does it matter what the name of a worksheet tab is at all? I would like to place in a hyphen when I create the tab like Jan-Feb. When I calculate my formulas will this hyphen mess me up when it comes to calculating? I would think no since the tab is usually in quotes or so within the formula correct? Thanks. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automating Worksheet Names | Excel Worksheet Functions | |||
how can you list all of the worksheet names in a file | Excel Discussion (Misc queries) | |||
In Excel, how do I change worksheet headers (A,B) to names (Box)? | New Users to Excel | |||
Lookups using worksheet names | Excel Discussion (Misc queries) | |||
Dynamic Worksheet Names | Links and Linking in Excel |