Lost the F4 function of repeat on some of my spread sheets. What did I do?

thanks

Did you get an answer for this? Sorry I can't help but I am having the same
issue and am about to start another project where i use this function about
150 times. My only solution so far was to e-mail the file someone who is not
on Excel 2007 and sit at their desk and complete my task, then send it back.

"pgarcia" wrote:

Lost the F4 function of repeat on some of my spread sheets. What did I do?

thanks

Make sure you haven't accidentally toggled your F Lock key (some keyboards have it, some don't).
See

http://en.wikipedia.org/wiki/F-Lock

HTH,
Bernie
MS Excel MVP


"Rugdoody" wrote in message
...
Did you get an answer for this? Sorry I can't help but I am having the same
issue and am about to start another project where i use this function about
150 times. My only solution so far was to e-mail the file someone who is not
on Excel 2007 and sit at their desk and complete my task, then send it back.

"pgarcia" wrote:

Lost the F4 function of repeat on some of my spread sheets. What did I do?

thanks

Bernie, Thanks for the help, the shortcut still works in my case for some
things, such as inserting rows. However my problem is really sorting data.
When you repeat it sorts the same data you originally selected. I have
multiple groups of say 10-15 rows that i need to sort individually, but
always by the same column. Also on multiple sheet tabs. It was always really
easy to select the rows and set the sort function, then keep selecting the
rows and hit the F4 button to get through the data quickly. Any help is very
much appreciated.

Thanks

"Bernie Deitrick" wrote:

Make sure you haven't accidentally toggled your F Lock key (some keyboards have it, some don't).
See

http://en.wikipedia.org/wiki/F-Lock

HTH,
Bernie
MS Excel MVP


"Rugdoody" wrote in message
...
Did you get an answer for this? Sorry I can't help but I am having the same
issue and am about to start another project where i use this function about
150 times. My only solution so far was to e-mail the file someone who is not
on Excel 2007 and sit at their desk and complete my task, then send it back.

"pgarcia" wrote:

Lost the F4 function of repeat on some of my spread sheets. What did I do?

thanks

On May 16, 6:56*am, Rugdoody
wrote:
Bernie, Thanks for the help, the shortcut still works in my case for some
things, such as inserting rows. *However my problem is really sorting data. *
When you repeat it sorts the same data you originally selected. *I have
multiple groups of say 10-15 rows that i need to sort individually, but
always by the same column. Also on multiple sheet tabs. It was always really
easy to select the rows and set the sort function, then keep selecting the
rows and hit theF4button to get through the data quickly. Any help is very
much appreciated.

Thanks



"Bernie Deitrick" wrote:
Make sure you haven't accidentally toggled your F Lock key (some keyboards have it, some don't).
See

http://en.wikipedia.org/wiki/F-Lock

HTH,
Bernie
MSExcelMVP

"Rugdoody" wrote in message
...
Did you get an answer for this? *Sorry I can't help but I am having the same
issue and am about to start another project where i use this function about
150 times. *My only solution so far was to e-mail the file someone who is not
onExcel2007and sit at their desk and complete my task, then send it back.

"pgarcia" wrote:

Lost theF4function of repeat on some of my spread sheets. What did I do?

thanks- Hide quoted text -

- Show quoted text -

Seems this is a feature of 2007. Agree it is a complete pain that F4
has lost a lot of its former functionality. But it is so.