![]() |
Opening Files/Folders
I am using Microsoft Excel 2000.
When I click on the Open menu option, the Open box pops up in the directory I normally use. The directory contains a number of folders and a few Excel files. It defaults to highlighting the first Excel file. But, in most instances I need a file folder and have to use the scroll bar to go left to select the folder. Is there a way I can set up Excel so that when I Open, it will highlight the first folder in the directory and not the first file? |
If you click on ToolsOptions and select the General tab, you will see the "Default File Location" that Excel uses. You can edit this to your desired folder location. HTH Bruce -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=381628 |
See one more suggestion at your other post.
animalfriend7 wrote: I am using Microsoft Excel 2000. When I click on the Open menu option, the Open box pops up in the directory I normally use. The directory contains a number of folders and a few Excel files. It defaults to highlighting the first Excel file. But, in most instances I need a file folder and have to use the scroll bar to go left to select the folder. Is there a way I can set up Excel so that when I Open, it will highlight the first folder in the directory and not the first file? -- Dave Peterson |
All times are GMT +1. The time now is 12:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com