ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   editing cells without using mouse (https://www.excelbanter.com/excel-discussion-misc-queries/35795-editing-cells-without-using-mouse.html)

thomasF

editing cells without using mouse
 

Hi,

I try to use the mouse as little as possible, and I can navigate in the
spreadsheets just fine with the arrows on the keyboard, but I haven't
found a way to edit a cell, e.g. insert some $-signs in a long formula,
without mouseclicking the formula-bar above the sheet. I can type in the
whole formula once more using only the keyboard of course, but that is
not a very simple way to go if the formula is long and hard to
remember.

Anyone know how to edit the contents of a cell using only the
keyboard?

Thomas F


--
thomasF
------------------------------------------------------------------------
thomasF's Profile: http://www.excelforum.com/member.php...o&userid=25314
View this thread: http://www.excelforum.com/showthread...hreadid=387972


HiArt


Press F2

Art

PS
depending upon your settings the cursor will appear eiother in the cell
or the forumla bar.


--
HiArt
------------------------------------------------------------------------
HiArt's Profile: http://www.excelforum.com/member.php...o&userid=19953
View this thread: http://www.excelforum.com/showthread...hreadid=387972


thomasF


you're saving my tired hand many a trip to the mouse
:)


--
thomasF
------------------------------------------------------------------------
thomasF's Profile: http://www.excelforum.com/member.php...o&userid=25314
View this thread: http://www.excelforum.com/showthread...hreadid=387972



All times are GMT +1. The time now is 06:35 AM.

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