Open Excel and go for the File tab.
On the bottom left, pick “Options.”
This opens the Excel Options where each of the prefs reside.
This handy spot is ideal for getting things done quickly.
Click “OK” to stash your change.
You may prefer aspecific fontstyle or are required to use a certain size with each new workbook you open.
You’ll see the top two parameters here for the default font style and then the size.
Make your selections in these drop-down boxes and click “OK” to save them.
Maybe you always work in Page Layout View or just want to open new sheets in Page Break View.
Select “General” and go to the When Creating New Workbooks section.
choose the Default View for New Sheets drop-down box and choose the view you want.
Along with the two mentioned options, you could pick “Normal View.”
Click “OK” to secure your change.
Workbook to Open
Do you almost always launch the same workbook in Excel?
you could make a change so that the workbook you need opens automatically when you launch Excel.
There are two different ways to make this happen.
Select “Advanced” and go to the General section.
Click “OK” to back up your change.
Select “Advanced” and go to the Display section.
Click “OK” to preserve your change.
Rather than add them as you go, you might open new workbooks with a certain number of spreadsheets.
Select “General” and go to the When Creating New Workbooks section.
Next to Include This Many Sheets, enter a number or use the arrows to choose the number.
Click “OK” to secure your change.
This may be especially useful if you collaborate with international colleagues.
Select “Advanced” and go to the Display section.
Use the drop-down box next to Ruler Units to pick the one you prefer.
Click “OK” to stash your change.
Related:How to Convert Almost Any Unit in Microsoft Excel
8.
But in your case you might put in your data horizontally to the right or left.
You canchange the default directionupon hitting the Enter key.
Click “OK” to preserve your change.
Select “Advanced” and go to the Editing Options section.
Click “OK” to store your change.
Calculation Method
By default, calculations in Excel workbooks are automatic.
On the left side of the section, mark the option you want to use for your workbook calculations.
Click “OK” to store your change.
This saves you time from changing the Save As file jot down for new workbooks.
Select “Save” and go to the Save Workbooks section.
Next to Save Files in This Format, choose the format from the drop-down list.
You’ll see options like older Excel versions,CSV, text, and many more.
Click “OK” to preserve your change.
Pivot Table Layout
Maybe you use pivot tables often in Excel foranalyzing large amounts of data.
If you’re constantly changing specific controls for your pivot tables, adjust the defaults instead.
Click “Edit Default Layout” next to Make Changes to the Default Layout of PivotTables.
When the Edit Default Layout box opens, use the drop-down boxes and checkbox items to make your changes.
For instance, you might adjust how subtotals and grand totals appear in your table.
Click “OK” in the small window and Excel Options window to keep your changes.
Save a little time from adjusting the same configs every time you open Excel by changing the defaults instead.
Related:7 Handy Microsoft Excel Features You May Have Missed
