About Us

Spencer101

Quote:

Originally Posted by sumesh56

i have a formula on B4 cell. i want to copy this formula to the 2024th row. holding the shift key and drag is a tiresome job.how can we do this with a few stroke? thanks

Put your formula in the first cell, B4 in this instance, and copy it (Ctrl+C) then press F5 and in the box that appears type the cell you want to go to, B2024 in this instance and press enter or click OK. Then press Ctrl+Shift+Up then paste (Ctrl+V).

Sounds like a long way round but once you've done it a few times it's second nature and very quick. Far quicker than playing "Excel YoYo" where you keep dragging up and down up and down until giving up and starting again :)

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Is there a shortcut to copy data from Formula Bar?	mcmilja	Excel Discussion (Misc queries)	4	May 8th 08 07:33 PM
shortcut: copy cell right down	Khoshravan	Setting up and Configuration of Excel	1	July 19th 06 08:26 AM
Copy/Paste how to avoid the copy of formula cells w/o calc values	Dennis	Excel Discussion (Misc queries)	10	March 2nd 06 10:47 PM
Copy shortcut	BJH	Excel Worksheet Functions	0	August 10th 05 12:41 AM
Copy a formula to a range of cells via VB6 using .Range(Cells(row,col), Cells(row,col)).Formula= statement	Kevin	Excel Programming	7	October 5th 04 08:11 PM

Menu

About Us