Excel Tips


Set up Excel Icons to Open a Specific File on Startup »

August 19, 2021

I routinely use the same five files in my job. I want a series of five icons on my Desktop so I can easily open these five files.


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


Open Excel with Ctrl+Alt+X »

August 17, 2021

I love keyboard shortcuts in Excel. Why isn’t there a keyboard shortcut to open Excel?


Open a Copy of a Workbook »

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.


What Is Protected Mode? »

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.