User Preferences

C

Catherine

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?
 
D

Dave Peterson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ASK Field Formatting 1
Autofill Date in Word 15.33 for Mac 0
Word 2016 - Difficulties Learning Style Creation/Application 0
Template location changes from user to user 0
Anchor issue with inserting a shape for letterhead 1
Font drop-down menu very slow 0
Wrapping and Anchors 0
Synchronization problems while moving folders to new email 1

Top