Wednesday, May 16, 2012

Default Settings on Excel 2010 under Windows 7

How to set row height and column width, or font, or whatever, to what you always want, and get it automatically every time.

Create an ideal Excel spreadsheet, blank but with all the settings you like.
Control Panel --> Folder Options --> View --> Show hidden files, folders, and drives --> Apply
Save your ideal blank spreadsheet, selecting Excel Template (*.xltx) from the Save As Type: pop-up menu. Save it into C:\Users\[your user name]\AppData\Roaming\Microsoft\Excel\XLSTART.
Control Panel --> Folder Options --> View --> Don't show hidden files, folders, and drives --> Apply
(Unless you like having the hidden folder visible.)
All new Excel spreadsheets should have your desired features automatically.