ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Open Excel files/folders (https://www.excelbanter.com/excel-discussion-misc-queries/32131-open-excel-files-folders.html)

animalfriend7

Open Excel files/folders
 
I am using Micrsoft Excel 2000

When I click on the Open icon, the Open box pops up. It automatically
highlights the first excel file in the directory I am in. All of the folders
listed before the Excel file are to the left. I have to use the scroll bar to
scroll left and find the file folder I need at that time. In almost all
instances, I need a folder instead of a file.

Is there a way to get Excel to default to highlighting the first folder upon
Open instead of the first Excel file?

Dave Peterson

The first thing I do is click on that icon to the far left to show details in
that dialog.

Then I can click on those headings to sort in any order I want.

And I think excel will remember your last settings--until you change it again.



animalfriend7 wrote:

I am using Micrsoft Excel 2000

When I click on the Open icon, the Open box pops up. It automatically
highlights the first excel file in the directory I am in. All of the folders
listed before the Excel file are to the left. I have to use the scroll bar to
scroll left and find the file folder I need at that time. In almost all
instances, I need a folder instead of a file.

Is there a way to get Excel to default to highlighting the first folder upon
Open instead of the first Excel file?


--

Dave Peterson


All times are GMT +1. The time now is 06:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com