ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Opening Files/Folders (https://www.excelbanter.com/excel-discussion-misc-queries/32135-opening-files-folders.html)

animalfriend7

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?

swatsp0p


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


Dave Peterson

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