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?


Start a Formula with = or + »

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.


Get Free Excel Help »

November 16, 2021

I have a question which is not answered in this book.


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.