Excel Tips
Three Methods of Entering Formulas »
November 18, 2021
I’d like to enter formulas faster. What are the three ways of entering simple formulas?
November 17, 2021
Every Excel formula has to start with an equals sign. There is no equals sign on the numeric keypad. It’s a pain to type the equals sign.
Change the Default File Location »
November 13, 2021
Most of the time, I want to save or open files from a certain folder.
Use a Macro to Change Case to Upper, Lower, or Proper »
November 12, 2021
Microsoft Word offers a command to convert text to UPPER or lower case. How can you do that in Excel?
Assign a Macro to a Toolbar Icon »
November 11, 2021
I want to run a macro from an icon in the Ribbon or the Quick Access Toolbar.
Assign a Macro to a Shortcut Key »
November 10, 2021
I need a fast way to run a macro that I’ve added to the Personal Macro Workbook.
Macro to Toggle Positive to Negative »
November 9, 2021
My debits came in as credits. I need to quickly change the sign on all numbers in a range.
November 6, 2021
It was another Tuesday last week that the Excel Development Team made their huge move about creating Custom Data Types. Although it is still in beta mode and you may need to join the Office Insider program to follow the rest of this article, it is certainly a big step that gives developers a huge power to represent data in Excel.