Excel Tips
Copy a Formula That Contains Relative References »
November 23, 2021
I have 5,000 rows of data. After entering a formula to calculate gross profit percent for the first row, how do I copy the formula down to other rows?
Long Formulas in the Formula Bar »
November 22, 2021
In legacy versions of Excel a long formula would spill out of the formula bar, covering part of the grid. This is particularly annoying in row 1 because the formula covers the value from the formula.
Use Parentheses to Control the Order of Calculations »
November 19, 2021
In what order does Excel perform calculations? For example, is 2+3*4 equal to 20 or 14?
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.