#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default copy a range

Select the cell with the formula............say A1

In NameBox type A1:A1200 and ENTER

CTRL + d to copy down.


Gord Dibben MS Excel MVP

On Thu, 2 Oct 2008 11:55:03 -0700, Dave
wrote:

I want to copy a formula to a range that is 1200 cells down
is there a quick copy command to di it


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
RANGE EXCEL copy cell that meets criteria in a range confused Excel Worksheet Functions 3 March 27th 08 01:41 PM
copy range and paste into every 3rd cell of new range thomsonpa New Users to Excel 4 December 3rd 07 01:47 PM
Copy Range Jeff Excel Discussion (Misc queries) 3 May 31st 07 06:55 PM
How do I copy formulas but using the same range each time I copy Laffin Excel Worksheet Functions 2 June 22nd 06 04:17 PM
copy a range without the same value antoine Excel Discussion (Misc queries) 1 May 4th 05 12:18 PM


All times are GMT +1. The time now is 09:52 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"