4 Excel Settings to Review Now to be more Productive

Some of these will improve productivity and some are for convenience. Examples are Excel Custom Lists, AutoCorrect. If you find yourself typing the same text or lists often these settings will improve your life. Other settings to review is the ability to define a default layout for your Pivot Tables and change your Excel startup options. Another one I like is to stop the selected cell from moving down when I press enter.

In this Video

00:00 Change These Excel Settings Now!

00:18 What Happens on Enter

01:46 Long Phrases with AutoCorrect

03:05 Custom Lists

05:03 Pivot Table Settings

07:21 Startup Settings

08:17 Keep Leading Zeros

09:47 Wrap Up

Tipps from Microsoft

Follow these tips for optimizing many frequently occurring performance obstructions in Excel.

https://docs.microsoft.com/en-us/office/vba/excel/concepts/excel-performance/excel-tips-for-optimizing-performance-obstructions

More about this topic

• Excel-fficiency: 10 tips for boosting productivity in Excel
  https://www.benlcollins.com/spreadsheets/10-productivity-tips-excel/
• 4 Excel Settings to Review Now to be more Productive
  https://www.youtube.com/watch?v=jLHqGRpGOPk
• 10 ways to be more productive with Microsoft Excel
  https://www.amaxra.com/10-ways-to-be-more-productive-with-microsoft-excel