LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.misc
PPM at Brackmills
 
Posts: n/a
Default copying formula down

One more to try. Assuming you do want all the rows to have the formula.
Click on the cell with the formula, put cursor over the bottom right corner
to display the fill handle (crosshair), double click left mouse button. this
should fill all the rows in the column with the fomula.

HTH

Mark

"iculookn2" wrote:


thanks for all your help! the keyboard shortcut rocks dave o.


--
iculookn2
------------------------------------------------------------------------
iculookn2's Profile: http://www.excelforum.com/member.php...o&userid=33783
View this thread: http://www.excelforum.com/showthread...hreadid=535523


 
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
Copying a formula to multiple worksheets RobHan Excel Worksheet Functions 1 February 16th 06 05:21 PM
Returned: Copying a formula horizontally, the source data is verti Shannon Excel Discussion (Misc queries) 5 December 21st 05 10:27 PM
Formula Problem - interrupted by #VALUE! in other cells!? Ted Excel Worksheet Functions 17 November 25th 05 05:18 PM
How do I prevent a formula element from incrementing when copying Copying Excel Formulas Excel Worksheet Functions 3 September 8th 05 05:15 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM


All times are GMT +1. The time now is 01:22 PM.

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"