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.

Outlook 2007 - How to Export 1 Folder

To export just one folder in Outlook 2007.

• Click the File menu.
  
  
  
• Click Import/Export.
  
  
  
• Choose Export to a file.
  
  
  
• Click Next.
  
  
  
• Choose Personal Folder File and click Next.
  
  
  
• Select the folder you wish to export from the list, click the include subfolders box if you want to include subfolders.
  
  
  
• Create the name you'd like to use for your exported file. Decide if you want duplicated items created.
  
  
  
• Click Finish - and you're done.
  

For additional information on Outlook 2007, please see our webinars: Clearing Inbox Clutter and Mastering Outlook Tasks.

MS Access 2003 - Adding Tables from Another Database into a Query

The traditional way of adding a table from an external database into a query is by linking the table to your database.

There is another way, however.

In the query design grid, right click anywhere in the grey area.

Click Properties.

When the properties window pops up, type the full path of the external database in the Source Database box.

For additional information about designing Access Queries, see our course: Access Queries from A to Z.