Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How stop auto formatting?
When I'm trying to copy table titles across the top, it automatically keeps
adding the next consecutive number after the title. For example, the title is HC, but when I copy that across it automatically adds HC2, and then HC3 (the numbers after the title). I don't want this. I just want HC across the top! Thanks. -- Thank you. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How stop auto formatting?
Excel 2007 Tables do not allow duplicate column headers.
If you want it to be just HC and NOT part of the title, after you get HC2, HC3, press ctrl/Z (undo) and you'll see HC HC... but it won't be part of the table. "tjsmags" wrote in message ... When I'm trying to copy table titles across the top, it automatically keeps adding the next consecutive number after the title. For example, the title is HC, but when I copy that across it automatically adds HC2, and then HC3 (the numbers after the title). I don't want this. I just want HC across the top! Thanks. -- Thank you. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How stop auto formatting?
It keeps saying Column 1, no HC shows up at all.
OK, i'm totally confused...you mean to tell me i cannot have the same titles across the top of a table?!? That's totally absurd! -- Thank you. "Bob Umlas" wrote: Excel 2007 Tables do not allow duplicate column headers. If you want it to be just HC and NOT part of the title, after you get HC2, HC3, press ctrl/Z (undo) and you'll see HC HC... but it won't be part of the table. "tjsmags" wrote in message ... When I'm trying to copy table titles across the top, it automatically keeps adding the next consecutive number after the title. For example, the title is HC, but when I copy that across it automatically adds HC2, and then HC3 (the numbers after the title). I don't want this. I just want HC across the top! Thanks. -- Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to stop excel from auto formatting whole number to decimal % | New Users to Excel | |||
Stop cells auto-formatting | Excel Discussion (Misc queries) | |||
How do I get Excel to stop auto-formatting? | Excel Discussion (Misc queries) | |||
How do I stop Excel auto formatting the text 3-4 as 04 Apr? | Excel Discussion (Misc queries) | |||
can't stop auto fomatting - help | Excel Discussion (Misc queries) |