User Preferences

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Catherine - 02 Mar 2004 13:21 GMT

How can you set up Excel so that when you open a file, it is automatically directed to the folders you save your files in? Also, how do you change the user preferences so that when you hit "enter", the cursor moves down one cell. This used to be in a user preference menu I believe, but since I've been upgraded to XP, I can't find these features. Can anyone help?

Reply to this Message

Dave Peterson - 03 Mar 2004 02:14 GMT

xl2k was the first version to try to save to the folder of that open workbook.
(xl97 opened the saveas dialog in the default folder.) I don't think this is an
option you can modify.

Tools|options|Edit tab
look for move selection after enter

> How can you set up Excel so that when you open a file, it is automatically directed to the folders you save your files in? Also, how do you change the user preferences so that when you hit "enter", the cursor moves down one cell. This used to be in a user preference menu I believe, but since I've been upgraded to XP, I can't find these features. Can anyone help?

Signature

Dave Peterson
ec35720@msn.com

Reply to this Message