Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,501
Default Short cut key for 'address' line

Hi,

I think the closet you get is tapping F2.
But if you go
Tools|Options|Edit
Un-Check 'Edit directly in cell'
OK

Now if you tap F2 the insertion point moves to the formula bar.

Look here for a full list

http://office.microsoft.com/en-us/ex...037811033.aspx

Mike

"Abi" wrote:

Is there a short cut key available for getting to the 'address' line in
Excel? Don't know what's it's called but it's the line where cell input also
appears (next to fx). I know in Internet Explorer the short cut key is F6,
but that doesn't seem to be the one in Excel.

  #2   Report Post  
Posted to microsoft.public.excel.misc
Abi Abi is offline
external usenet poster
 
Posts: 20
Default Short cut key for 'address' line

Hi Mike and Jarek,
Many thanks for your quick replies. Both helped!

"Mike H" wrote:

Hi,

I think the closet you get is tapping F2.
But if you go
Tools|Options|Edit
Un-Check 'Edit directly in cell'
OK

Now if you tap F2 the insertion point moves to the formula bar.

Look here for a full list

http://office.microsoft.com/en-us/ex...037811033.aspx

Mike

"Abi" wrote:

Is there a short cut key available for getting to the 'address' line in
Excel? Don't know what's it's called but it's the line where cell input also
appears (next to fx). I know in Internet Explorer the short cut key is F6,
but that doesn't seem to be the one in Excel.

Reply
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
How do I avoid excel change absolute address to relative address Miguel Excel Discussion (Misc queries) 3 May 10th 07 11:18 PM
outlook 3 line street address joe smith Excel Discussion (Misc queries) 2 November 22nd 05 02:32 PM
long address list, name-address-city, listed vertically, how do y. kb Excel Discussion (Misc queries) 2 March 4th 05 12:48 AM
How do I import Office address book to Outlook Express address bo. snnorp Excel Discussion (Misc queries) 2 February 22nd 05 11:47 AM
How do I include cell data in subject line of email address/hyperl gvinnola Excel Worksheet Functions 1 November 18th 04 02:36 AM


All times are GMT +1. The time now is 09:19 AM.

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

About Us

"It's about Microsoft Excel"