Excel Tips
Have Excel Always Open Certain Workbook(s) »
August 18, 2021
I always use Excel to work on a particular workbook. Every time that I open Excel, I want this workbook to open automatically
August 17, 2021
I love keyboard shortcuts in Excel. Why isn’t there a keyboard shortcut to open Excel?
August 14, 2021
I have a workbook called invoice.xlsm. I want to keep the original file unchanged and save each new version as a new workbook. However, I tend to forget to use Save As, so I often overwrite this workbook.
My Manager Wants Me to Create a New Expense Report from Scratch »
August 13, 2021
My manager wants me to design a new expense report completely from scratch. It seems intimidating to create this report from scratch.
Use a Trusted Location to Prevent Excel’s Constant Warnings »
August 12, 2021
Excel is more security-conscious than in the past. In fact, many features that I rely on are now disabled, such as links to external files, external queries, and macros.
August 11, 2021
Any time that I download a file from our file sharing site, it opens in Protected mode.
Get Quick Access to Formatting Options Using the Mini Toolbar »
August 10, 2021
Why do I have to always go to the top of the window to reach formatting commands? I loved having floating toolbars in Excel 2003. Why did Microsoft get rid of them?
I Just Want The Old Print Preview Back »
August 9, 2021
I don’t like change. I don’t have time to learn about the backstage view. I don’t like anything new. Just give me the old Print Preview command.
Change All Print Settings in Excel »
August 6, 2021
Print settings appear in many different places in Excel. I am never sure if I should go to Page Setup, the Print dialog, or the Options button in the Print dialog.