Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to copy into 1000s of cells?
Suppose I put a formula into A1, and I want to "copy down" through
A5000. What is the easiest way to do that? (By the way, A5000 is just an example. I might want A10000 or more.) I know that I could drag the cell down through A5000. But that is tedious and error-prone. It is easy to overshoot A5000. I know that I could copy A1, click on A2, scroll down to A5000 and shift-click the cell to highlight the range A2:A5000, then paste. But that, too, is tedious. I would be content to copy A1, click on A2, then "go to" (ctl-G) A5000 and shift-click the cell in order to highlight the range A2:A5000, then paste. But that does not seem to work. (I am using Office Excel 2003.) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating only non-empty cells... | Excel Worksheet Functions | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
copy a block of cells | Excel Discussion (Misc queries) | |||
How to use macros to copy a range of cells which can exclude some cells which I didn't want to be copied? | Excel Worksheet Functions | |||
Using Command Button to copy cells | Excel Discussion (Misc queries) |