Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 9th 09, 04:14 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: May 2009
Posts: 8
Default Drag formulas, not formating

I am trying to drag formulas across rows and columns in a table, but I don't
want the formating to be dragged also. Can I drag only formulas, and not
borders?

  #2   Report Post  
Old June 9th 09, 04:18 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2009
Posts: 8,521
Default Drag formulas, not formating

Copy the cell with formula.
Selec the range to be copied
Right clickPasteSpecial
Select Formulas
Click OK
--
If this post helps click Yes
---------------
Jacob Skaria


"Wavequation" wrote:

I am trying to drag formulas across rows and columns in a table, but I don't
want the formating to be dragged also. Can I drag only formulas, and not
borders?

  #3   Report Post  
Old June 9th 09, 04:19 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2009
Posts: 320
Default Drag formulas, not formating

Right-mouse drag the fill handle, then select "Fill without formatting" when
you let go of the right-mouse
Bob Umlas
Excel MVP

"Wavequation" wrote in message
...
I am trying to drag formulas across rows and columns in a table, but I
don't
want the formating to be dragged also. Can I drag only formulas, and not
borders?





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
how do I drag formulas from one column to the next Miles Excel Discussion (Misc queries) 1 October 6th 08 04:10 PM
Complicated insert / drag formulas Ed Excel Discussion (Misc queries) 0 October 6th 06 11:33 PM
Formulas won't drag down the column Sara Excel Discussion (Misc queries) 2 March 28th 06 10:48 PM
How do i drag formulas down derwood Excel Discussion (Misc queries) 2 November 5th 05 02:47 AM
drag and drop formulas Bram Excel Discussion (Misc queries) 3 October 20th 05 07:16 AM


All times are GMT +1. The time now is 10:05 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017