If you’re a spreadsheet jockey, but you’re not keen on Excel’s default settings, reader Curare details how to set up a custom Excel template so the data-wrangling app always uses the workspace you prefer.
I use Excel a lot, and I prefer not to see the gridlines — opting instead to have more of a canvas style look. Instead of changing the viewing settings every time you open Excel, you can set up Excel to open with your preferences already in place. Since Excel’s menu items don’t provide default settings for some items, you can create a template worksheet that Excel will reference before opening.
- Set up a blank worksheet with your preferred viewing settings
- Click on ‘Save As’
- Change the ‘Save as type’ to Excel Template (*.xltx)
- Browse to the XLSTART folder on your computer (C:Program FilesMicrosoft OfficeOffice12XLSTART in my case)
- Change the file name to ‘Book.xltx’ and Save
- Restart Excel to trigger the new settings
This method should work for any display settings of your choice. Thanks Curare!