Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() Not sure how to fill down formulas, with either dragging or CTRL-D,without taking along formats, colours, borders (especially) etc with them. A real pain having to re-format a sheet every time I auto-fill...surely there is an easier way to do this. Cheers! M |
#2
![]() |
|||
|
|||
![]()
Have you tried copying and using Edit Paste Special
Formulas? HTH Jason Atlanta, GA -----Original Message----- Not sure how to fill down formulas, with either dragging or CTRL-D,without taking along formats, colours, borders (especially) etc with them. A real pain having to re-format a sheet every time I auto-fill...surely there is an easier way to do this. Cheers! M . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Why won't formulas obey vertical alignment commands? | Excel Discussion (Misc queries) | |||
Removing Hidden But Keep Values | Excel Discussion (Misc queries) | |||
In Exel 2000, stop the blank cells (with formulas) from printing. | Excel Discussion (Misc queries) | |||
delete values in several cells without deleting the formulas | Excel Discussion (Misc queries) | |||
How do I view formulas by values not by which cells they use to c. | Excel Discussion (Misc queries) |