Excel Guides

Reducing the Size of the Save As Dialog Box in Excel

Reducing the size of the Save As dialog box in Excel can be done by following these steps:

  1. Open Excel and go to File > Options. In the General tab, uncheck the Show all recently used files in each folder option.
  2. Now go to View, and under the Advanced Settings, uncheck the Display file name extensions. This will reduce the size of your file names and make it easier to read them.
  3. In the same tab, uncheck the Display hidden files, folders, and drives. This will help you focus on the task at hand and not get distracted by other files on your computer.

  4. 4. Under the View, go to the bottom and check the option that says Always show full menus. This will help you see all of your options when you right click on a file or folder.

  5. 5. Under the same tab, go to "Other settings" and check "Launch folder windows in a separate process".
    This will help improve your computer's performance when working with large files or folders.

  6. 6. The last thing we can do to improve performance is to change how often Excel saves AutoRecover information. By default, this is set to 10 minutes. You can change this by going to "Save" under File         Options.(1)(2)(3)(4)

    1. (8)

      1. < li class =MsoNormal value =8 >< div align =justify >< a name="" > (1 ) In Excel 2010 , got to File Options . Click Save in left navigation pane . ( 2 ) Change AutoRecover save interval from 10 minutes (the default ) to 1 minute or less if desired . ( 3 ) Set " Keep The Last Autosaved Version If I Close Without Saving " . This ensures you won't lose more than one version if Excel crashes . ( 4 ) Set " Prompt To Save AutoRecovered Files " so you will be prompted before saving any recovered versions of your workbook . ( 5 ) Set " Keep The Last Autosaved Version If I Close Without Saving " so you won't lose more than one version if Excel crashes . ( 6 ) Set " Prompt To Save AutoRecovered Files " so you will be prompted before saving any recovered versions of your workbook . ( 7 )
( 8 ) < br clear =all class ='page - break - before : always' / > < ol start =9 type =a class ='liststyle__bullets___2J7mN' > < li class =MsoNormal value =9 >< div align =justify >< a name="" > ( 1 ) In Excel 2010 , got to File Options . Click Save in left navigation pane . ( 2 ) Change AutoRecover save interval from 10 minutes (the default ) to 1 minute or less if desired . ( 3 ) Set " Keep The Last Autosaved Version If I Close Without Saving " . This ensures you won't lose more than one version if Excel crashes . ( 4 ) Set " Prompt To Save AutoRecovered Files " so you will be prompted before saving any recovered versions of your workbook . ( 5 ) Set " Keep The Last Autosaved Version If I Close Without Saving " so you won't lose more than one version if Excel crashes . ( 6 ) Set " Prompt To Save AutoRecovered Files " so you will be prompted before saving any recovered versions of your workbook . ( 7 )
( 8 )

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.