Repeating Last Action

H

Haseeb

I used to be able to hit F4 to repeat my last action as many times as I could
if i didnt type anything else. I only seem to be able to do this once in my
excel right now. Is there anything I can change in my prefernces to make it
work. I hope I am being clear. Please someone let me know. This is driving
me nuts and need to figure it out.
 
H

Haseeb

I did but that only repeats it once. I want to be able to repeat it more
than once. E.g. I paste the format through paste/special in one cell move
over three or four cells hit f4 and then three or four more and hit f4 again.
But I cant seem to repeat it after the first f4 or Crtl Y for that matter.
 
Top