About Us

sumesh56

Quote:

Originally Posted by Spencer101

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 :)

thanks for the suggestion. i tried your suggestion in the following and failed to get the result. make me correct plz.

in A1 i put 1
in A2 =A1+1 pressed enter
then i copied cell A2 then p f5 entered A50
the p control shift pageup and p control v
i got 1 instead of 50.
ok dear , i tried with <up arrow and succeed. thanks for the suggestion, have a nice day.

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