Category Archives: Excel
Tip #006 – Excel
COUNT is Good Excel formula but it has Limitations
If you want Excel to count how many cells contain numeric entries – use the COUNT function (ie, =COUNT(range)). Cells containing non-numeric entries (ie, text) will NOT be included in the answer…
Read More
Tip #008 – Excel
Speed up your data entry
If you need to enter the same data (text, numbers or equations) into a range of cells – rather than type it then copy it to the adjacent range of cells – type it into the entire range at once…
Read More
Tip #011 – Excel
Repeating an Entry…Quickly
Hopefully you are already familiar with Excel’s AutoFill feature: if you are typing a list and start to type an entry that matches a previous entry in that column/list – Excel will try to facilitate quick data entry by displaying (in black) the rest of the entry. If that IS what you were intending to type – press [ENTER] and Excel will complete the entry for you. If that wasn’t what you intended – then finish the entry yourself.
HOWEVER…
Read MoreTip #068 – Excel
Excel: More Ways to Play with the Fill Handle
Yet another use for the ever-flexible Fill Handle…
Read More
Tip #002 – Excel
The Fastest Copy Method
You have typed a formula into a cell near the top of a column. You would like to COPY that equation to all the blank cells below you (stopping at the lower boundary of the other columns in your spreadsheet)…
Read More