Excel

The UK's most regular instructor-led training courses.
Training information: vba-excel-training · Excel-courses-london · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version Standard

Excel

Siobhán has attended:
Excel Intermediate course
Excel Advanced course

by - delegate Siobhán [2 posts] (2008 Feb 7 Thu, 15:50) Reply

Once I've finished typing in a cell and press enter the cursor stays in the same cell. What do I need to change to make the cursor move to the next cell once I have pressed enter ?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 9 Fri	Bloomsbury	1	book now	£240	£245
2007	2009 Jan 14 Wed	Bloomsbury	5	book now	£235	£245
2002/XP	2009 Jan 14 Wed	Tooting	0	FULL
2003	2009 Jan 16 Fri	Southwark	0	FULL
2007	2009 Jan 21 Wed	Bloomsbury	3	book now	£240	£245
2003	2009 Jan 21 Wed	Southwark	2	book now	£235	£240
Full Schedule: See all 114 Excel Advanced course dates. Bookings currently available until 31st March 2010.

RE: Excel

by - trainer Pete platinum contributer [864 posts] (2008 Feb 8 Fri, 22:08) Reply

Hi Siobhan, thank your for the post, in answer to your question, you will need to change the cursor direction, go to the Menu Command Tools, Options, and then in the tab Edit, choose the direction that you wish your cursor to move, Left, Right, Down or Up, in your case you will need to click in the box to ensure the cursor does not stay in the cell. hope that helps, best regards Pete

· Excel Macros for the Non-Programmer
· Excel and Inventory Management
· Do You Really Need Excel VBA Training?
· Benefits of learning about Excel charts
· Improve Performance Of Your Excel Macros

Please browse our web site to find out more about
vba-excel-training and other Microsoft training courses.

Excel tip:

Adding date and time

Here are two quick ways to add the date and time to your spreadsheet:

1) Type =NOW(), which displays both date and time in the same cell
or
2) Hold Ctrl and type the colon (:) into one cell for the date and the semi-colon(;)into another for the time.

Note that =NOW() updates to the current date/time whenever the spreadsheet recalculates.

View all Excel hints and tips

Rate this page: