Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Format & formula retained
I have some formattings and formulas on cells of each row and I have an open
spreadsheet that can be updated by a few peoples. If someone wants to add rows, how can the formats and formulas be retained automatically. Your guidance is appreciated. Thanks, Ray |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Format & formula retained
Hi Ray............
What I do is to have a hidden row at the top of my sheet with the proper formats and formulas in the respective cells............then, in my visible header, I have a pushbutton marked "FORMAT" which fires a macro that goes and gets the hidden row and inserts it in the next blank row at the bottom of the sheet........the macro even increments an item number in column A for me. Vaya con Dios, Chuck, CABGx3 "Ray" wrote: I have some formattings and formulas on cells of each row and I have an open spreadsheet that can be updated by a few peoples. If someone wants to add rows, how can the formats and formulas be retained automatically. Your guidance is appreciated. Thanks, Ray |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
display USA phone format in formula bar | Excel Discussion (Misc queries) | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Conditional Format - Formula to Colour Every 3rd Cell in Offset Range | Excel Discussion (Misc queries) | |||
How do I copy a conditional format that uses a formula in a serie. | Setting up and Configuration of Excel | |||
How do I format a character from a result of formula in excel? | Excel Discussion (Misc queries) |