Computing.Net > Forums > Office Software > Enter text in Excel without a mouse

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Click here to start participating now! Also, check out the New User Guide.

Enter text in Excel without a mouse

Reply to Message Icon

Name: nylander
Date: April 20, 2004 at 03:53:09 Pacific
OS: winxp
CPU/Ram: 1600/256
Comment:

Hello!
This one has irritated me for long. How does one get to enter new data in a text cell without using mouse? Is there something like a hotkey or anything to move the cursor to the highlighted cell and getting to edit it without this mousedragging?



Sponsored Link
Ads by Google

Response Number 1
Name: Report_2
Date: April 20, 2004 at 04:06:26 Pacific
Reply:

Ctrl+G or Alt, E, G will allow you to select a cell but I know of no way of editing or adding additional text to already existing text within a cell.
I suspect MS figures that you should do it right the first time and then won't have to edit the current text within a cell.

Of course there is Ctrl+H or Alt, E, E that envokes the Find and Replace dialog box that can be used without the mouse but that is no different than retyping the cell's text that can be done with the previous method.

Bryan


0

Response Number 2
Name: brizboy
Date: April 20, 2004 at 12:31:43 Pacific
Reply:

Hi

I'm not sure about other versions but in Excel 2000 the following works.
Use arrows to move to the cell then press F2. It will place the cursor at the end of the text in the cell and you can use the left right arrows to move within the text in the selected cell.

Kind regards
brizboy


0

Response Number 3
Name: Report_2
Date: April 20, 2004 at 13:01:40 Pacific
Reply:

Brizboy, F2 works in Excel 97 too.

Thanks,
Bryan


0

Response Number 4
Name: Report_2
Date: April 20, 2004 at 13:28:48 Pacific
Reply:

See http://www.cpearson.com/excel/ShortCuts.htm for the Excel Keyboard Shortcuts in HTML or downloading a Zipped .xls file.

Regards,
Bryan



0

Response Number 5
Name: Nigel Spike
Date: April 21, 2004 at 06:53:07 Pacific
Reply:

F5=Goto cell no.
F2=Edit current cell
When editing use Home or End to BOL or EOL
Those are standard keys within spreadsheet programs.
You may also try the Help function = F1 to find out what quick keys to use.

HTH
Nigel


0

Related Posts

See More



Sponsored Link
Ads by Google
Reply to Message Icon

Outlook 2000 problem outlook stops responding



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links

Ads by Google


Results for: Enter text in Excel without a mouse

Excel highlight without a mouse www.computing.net/answers/office/excel-highlight-without-a-mouse/7142.html

Turning Time into Text in Excel!!! www.computing.net/answers/office/turning-time-into-text-in-excel-/4074.html

Generate a List of Text in Excel www.computing.net/answers/office/generate-a-list-of-text-in-excel/7102.html