Excel 2007 - Control Enter Key Action

In a previous post,I showed how to change which cell is selected after your hit your Enter key in Excel 2003.



Here are the instructions for Excel 2007.



Click the Office Button in the upper left hand corner of your screen.



In the bottom right hand corner of the screen that pops up, click Excel Options.



Click the Advanced link on the left hand side of the box.



Under Editing Options, make sure a check mark is next to After
pressing Enter, move selection.



Next to Direction, select Right.



Click OK.

Excel 2003 & 2007 - Quickest Ways to Copy Worksheets.

Copying worksheets is one of my favorite Excel time savers. If you have an Excel file (workbook)  that has similar worksheets, such as a budget workbook with a sheet for every month, copying worksheets will save you time. 

This tip works with Excel 2003 and 2007.

Some of you may know the traditional way to copy a worksheet (Excel 2003 instructions):

• Click the Edit menu.


• Choose Move or Copy Sheet.


• Make certain the Create a Copy box is checked.


• Select where you want to place the sheet (in a new workbook file, or in the current workbook).


• Click OK.

 

Did you know that there's an even quicker way to do this? This works in Excel 2003 and 2007.

 

To copy a worksheet in the same workbook.

• Hold down the Ctrl key.


• Left-click and drag the worksheet.

 

To copy a worksheet to another workbook. Excel 2003 and 2007.

• Make sure both workbooks are open.


• Click the Window menu, then Arrange. In Excel 2007, Click the View Tab, and then Arrange All.


• Choose Vertical, and then OK.


• At this point, both workbooks should be open side-by-side.


• Left-click and drag the worksheet from one workbook to another.

For additional information:

Intro to Excel 2007 - Atlanta Training class.

Excel 2003 Basics - Atlanta Training Class.


Excel 2003 Intermediate - Atlanta Training Class.

Excel 2003 - Control Enter Key Action

Question:
When I hit enter after typing an item, Excel automatically takes me to the cell below the current cell. Is there anyway to change this so that it
moves to the cell on the right?


Answer:
Changing this feature can be valuable, particularly when you have to do a lot of data entry.
 

Here's how you make the change.


Click on the Tools menu, and select Options.


Click the Edit tab.


Make sure Move selection after Enter is
checked.

Next to Direction,
choose Right.


Click OK.


This works with Excel 2003 only. For the Excel 2007 instructions, click here.