ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How can I access formula bar by using keyboard not mouse? (https://www.excelbanter.com/new-users-excel/74727-how-can-i-access-formula-bar-using-keyboard-not-mouse.html)

Alai

How can I access formula bar by using keyboard not mouse?
 
I want to use keyboad to access the formula bar for enter date instead of
using mouse to get there.

davesexcel

How can I access formula bar by using keyboard not mouse?
 

F2
will get you to the formula bar


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=518032


Gord Dibben

How can I access formula bar by using keyboard not mouse?
 
Alai

With a cell selected hit F2 key to get into Edit mode in the formula bar.

Alternative..........with a cell selected, hit CTRL + ;(semi-colon) to enter
today's date in that cell.


Gord Dibben MS Excel MVP


On Wed, 1 Mar 2006 14:16:31 -0800, "Alai"
wrote:

I want to use keyboad to access the formula bar for enter date instead of
using mouse to get there.




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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com