Here are some quick tips to customize parts of Excel to your liking.
One are is the number of worksheets in Excel. The preset setting is 3, which results in the following when you open a workbook.
Suppose you would rather just start with one worksheet? After all, it is easy to add more sheets.
Here is where you change the settings. Go to the Tools menu, then select Options. Next go to the General tab.
In the bottom section, change the Sheets in new workbook setting to 1. Next time you open up a workbook, only 1 sheet will come up.
Here are some of the other settings in the General tab that you might want to customize:
Standard Font and Size. Here we have changed it to Times New Roman and 11.
Default location. If you tend to store your Excel sheets in a one folder most often, then you might want to set that folder as your default location.
Recently used file list (above the center horizontal line). This covers the number of files that are shown when you click on the File menu. You have quick access by clicking on any file name displayed. This is faster than having to open up a folder and drilling down to the file.
We like keeping this at the maximum, which is 9.
There are other options to modify in the General tab, but these are the ones that we find most useful.