LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 36
Default short cuts

Hi, in lotus 123 I used to ( after naming a group of cells) press F4 and type
in a number say 100 and I would be taken too that cell, in XL I can't use a
number so I have to use _100, which means I now have to press F4 then shift
and then _ 100.
Is there a quicker way to do this? can I change a F key to become _ or is
there a macro I could use To open the go to box And put in _ then all I need
to do is press the F key and type in the number, I know it sounds sad but I
need to do this around 900 times in a four hour period.

Thanks in advance, wildauk.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Deleting Macro Short Cuts Jamie Excel Discussion (Misc queries) 3 July 10th 09 03:08 PM
Short-cuts Horacio[_3_] Excel Discussion (Misc queries) 1 April 24th 09 05:11 PM
cant open short cuts chrisbmo2000 Excel Discussion (Misc queries) 1 May 21st 08 06:54 PM
Borders using key board short cuts basavaraj bb Excel Discussion (Misc queries) 0 March 27th 06 08:42 AM
Short cuts? Bob Phillips Excel Discussion (Misc queries) 4 March 31st 05 06:27 PM


All times are GMT +1. The time now is 06:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"