F4 key

I use the F4 key alot to repeat actions. But when I copy and paste,then
go to a new area and paste using the F4 key it only does it once. I
then have to use the copy and paste command again and then I only get 1
paste again with the F4. Is there a way to have the F4 key not run out
of pasting?I know it's mainly to repeat formatting but it does seem to
paste,at least once.


---
Message posted from http://www.ExcelForum.com/

I don't think you can change F4's behavior, but try shift-insert (on the numeric
keypad).

(ctrl-insert does a copy, too)

"light " wrote:

I use the F4 key alot to repeat actions. But when I copy and paste,then
go to a new area and paste using the F4 key it only does it once. I
then have to use the copy and paste command again and then I only get 1
paste again with the F4. Is there a way to have the F4 key not run out
of pasting?I know it's mainly to repeat formatting but it does seem to
paste,at least once.

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson

Use Control-V to paste


"light " wrote in message
...
: I use the F4 key alot to repeat actions. But when I copy and paste,then
: go to a new area and paste using the F4 key it only does it once. I
: then have to use the copy and paste command again and then I only get 1
: paste again with the F4. Is there a way to have the F4 key not run out
: of pasting?I know it's mainly to repeat formatting but it does seem to
: paste,at least once.
:
:
: ---
: Message posted from http://www.ExcelForum.com/
: