Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jose Mourinho
 
Posts: n/a
Default 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   Report Post  
Jason Morin
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why won't formulas obey vertical alignment commands? imoux1 Excel Discussion (Misc queries) 2 December 28th 04 05:45 PM
Removing Hidden But Keep Values Wayne Excel Discussion (Misc queries) 2 December 11th 04 03:05 AM
In Exel 2000, stop the blank cells (with formulas) from printing. tonyoc Excel Discussion (Misc queries) 1 December 10th 04 01:38 AM
delete values in several cells without deleting the formulas dranreb Excel Discussion (Misc queries) 4 December 9th 04 02:15 AM
How do I view formulas by values not by which cells they use to c. excelhelp Excel Discussion (Misc queries) 1 December 6th 04 01:30 AM


All times are GMT +1. The time now is 10:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"