Daily posts of Excel tips…and other stuff
Archive for the ‘UI File Operations’ Category.
Let’s say that you want to open a specific file when you start Excel. Here are some options:
XLSTART
If you have Excel installed, you have a folder called XLSTART. Mine’s here C:\Documents and Settings\Dick\Application Data\Microsoft\Excel\XLSTART. On my Windows 7 machine running Office 2010 Beta, it’s here C:\Program Files\Microsoft Office\Office14\XLSTART\. (Are we putting [...]
On the left side of the File Open dialog (and the File Save dialog), there is an area called My Places.
My Recent Documents, Desktop, My Documents, My Computer, and My Network Places must be the default, because I’m sure I’ve never added or deleted anything from this list. Recently, Bob Phillips alerted me to [...]
CSV, or comma-separated-values, files are native Excel file formats. That is, Excel can open and read them without any special converters. To create a CSV file, change the "Save as type" box in the Save As dialog box. Take a spreadsheet like this
From the File menu, choose Save As and change the type to CSV.
Excel [...]
When you select New from the File menu, the New dialog box is displayed. Usually, the New dialog will have some tabs that organize the templates that are available. This example has the General, Spreadsheet Solutions, and Office 97 Templates tabs.
You can add your own tabs to this dialog by adding subfolders to [...]
