Excel Tips


Where Are My Macros? »

July 13, 2021

Did Microsoft abandon the macro facility? Where are the buttons to record a new macro, run a macro, and so on? How do I get to the Visual Basic Editor?


Where is File, Exit? »

July 12, 2021

What happened to the old Exit command?


Find Icons on the Ribbon »

July 9, 2021

I know a certain feature exists in Excel, but I can not find it in the Ribbon.


How Can I Use Excel on Dual Monitors? »

July 7, 2021

Why is it so hard to use Excel on two monitors?


Should I Buy Office 2019 or Subscribe to Office 365? »

July 6, 2021

The Office 365 website is super-confusing. I don’t want to buy the wrong version.


Why Does Office 365 Have Better Features? »

July 5, 2021

I have Geography and Stock Data Types at home, but not at work, What is going on?


List Combinations Of N Items Taken M At A Time »

July 2, 2021

You want to list all unique combinations of m items from a population set of n items. For example, you might want to generate all possible unique groups of 4 employees from a set of 10.


Magnify A Section Of Your Screen »

June 30, 2021

You would like to display 48 months of data across your monitor. When you zoom down to 40%, you can see all the columns, but you cannot make out any numbers on the screen.


Self-sign Your Macros For Co-workers »

June 28, 2021

You’ve created some macros for co-workers to use. Having them click Enable Macros each time is tiresome, but you don’t want them to drop their macro security settings too low.