Home |
Search |
Today's Posts |
#1
|
|||
|
|||
help with header row format
Hi,
The first row in my excel file is the header. When I insert a new row after that, the new row takes the format, color etc of the header. How can I avoid the new rows inserted form taking the format of the forst row? Thanks |
#2
|
|||
|
|||
If it's Excel 2003, when you insert the new row under the header row youy
should get a small icon appearing which has a drop down arrow providing format options. You can select to format the new row as the line above, the line below, or clear formatting. -- Noel O'K "Chris" wrote: Hi, The first row in my excel file is the header. When I insert a new row after that, the new row takes the format, color etc of the header. How can I avoid the new rows inserted form taking the format of the forst row? Thanks |
#3
|
|||
|
|||
I don see any icon. It inserts the new row with the same size, color, format
etc. form the first row. "noelma" wrote: If it's Excel 2003, when you insert the new row under the header row youy should get a small icon appearing which has a drop down arrow providing format options. You can select to format the new row as the line above, the line below, or clear formatting. -- Noel O'K "Chris" wrote: Hi, The first row in my excel file is the header. When I insert a new row after that, the new row takes the format, color etc of the header. How can I avoid the new rows inserted form taking the format of the forst row? Thanks |
#4
|
|||
|
|||
Turn on or off Insert Options
Click Options on the Tools menu, and click the Edit tab. Select or clear Show Insert Options buttons. -- Noel O'K "Chris" wrote: I don see any icon. It inserts the new row with the same size, color, format etc. form the first row. "noelma" wrote: If it's Excel 2003, when you insert the new row under the header row youy should get a small icon appearing which has a drop down arrow providing format options. You can select to format the new row as the line above, the line below, or clear formatting. -- Noel O'K "Chris" wrote: Hi, The first row in my excel file is the header. When I insert a new row after that, the new row takes the format, color etc of the header. How can I avoid the new rows inserted form taking the format of the forst row? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I change date format in the header in Excel XP ? | Excel Discussion (Misc queries) | |||
Date format in Header | Excel Discussion (Misc queries) | |||
format the "date" button for a header | Excel Discussion (Misc queries) | |||
Conditonal Format with a date format | Excel Discussion (Misc queries) | |||
Keep custom format in new worksheet | Excel Discussion (Misc queries) |