| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
fill formulas and values
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 | |
|
|
Similar Threads
|
||||
| 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) | |||
Linear Mode
