| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
shading alternate rows, but losing format when one row is deleted
I have my sheet rows shaded alternately gray/white, but when I delete a row,
the shading does not update, I have to re-format manually.... I wrote a macro: select all autoformat and that works, but I am wondering if there is a setting that will just auto adjust the row shading after I delete or ad a row without having to run the macro or re-auto format? Any suggestions will be greatly appreciated. Thanks, Candice |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How Do I format an Excel sheet to have a 3D effecrt in rows? | Excel Worksheet Functions | |||
| Format to hide empty rows | Excel Discussion (Misc queries) | |||
| Count Rows with Conditional Format? | Excel Discussion (Misc queries) | |||
| How do I set a Conditional Format for ROWs based on the value of . | Excel Discussion (Misc queries) | |||
| how to format pull down rows | Excel Worksheet Functions | |||
Threaded Mode
