Excel 2003 -- copy/paste error

[Joe]

I'm using XP and Excel 2003...everything is current.

I'm copying a cell's formula using ctrl-c, then pasting
to many cells using ctrl-v after selecting the target
cell range.

Upon hitting ctrl-v to paste, I get the following error
message: "Selection too large." I get 1 option: "OK".
Nothing else...no help, no nothing. Very cryptic error
message.

Has anyone else come across this problem? If so, how did
you solve the problem?

Thanks!

 

[Quaoar]

I'm using XP and Excel 2003...everything is current.

I'm copying a cell's formula using ctrl-c, then pasting
to many cells using ctrl-v after selecting the target
cell range.

Upon hitting ctrl-v to paste, I get the following error
message: "Selection too large." I get 1 option: "OK".
Nothing else...no help, no nothing. Very cryptic error
message.

Has anyone else come across this problem? If so, how did
you solve the problem?

Thanks!

Paste in the top left cell of the range which is selected as you did.
Ctrl-d to copy down the leftmost column, followed by Ctrl-r to copy
right into the rest of the columns. This works if every cell reference
is relative.

Q