Excel Tips
AutoSum Doesn’t Always Predict My Data Correctly »
January 4, 2022
When I use the AutoSum button, Excel sometimes predicts the wrong range of data to total. Below, AutoSum worked fine in F2 and F3, but in cell F4, Excel thought I wanted to total the rows above F4. How do I enter the correct range?
Use AutoSum to Quickly Enter a Total Formula »
January 3, 2022
I have numeric data in Excel. I need to total the rows quickly.
Add the Worksheet Name as a Title »
December 31, 2021
I have 12 worksheets, labeled January through December. Is there a formula that will put a worksheet name in a cell?
CLEAN Hasn’t Kept Up With The Times »
December 30, 2021
The Excel function CLEAN is supposed to get rid of non-printable characters. It doesn’t seem to get them all. And sometimes I would rather replace the non-printable character with a space.
Fill a Cell with Repeating Characters »
December 29, 2021
I need to fill a cell with asterisks before the number. If the cell gets wider, I want more asterisks to appear.
December 28, 2021
I have a field that can contain numbers and text. I need the numeric entries to sort with the text entries. However, Excel always sorts the numeric entries to the top of the list, followed by the text entries.
Change Smith, Jane to Jane Smith »
December 27, 2021
I have a column of names in last name, first name style. How can I convert the data to first name last name?
December 24, 2021
Someone used the Alt+Enter trick discussed later in this book to build address information with three lines in single cells. I need to break this data into columns.
Parse Data With Leader Lines »
December 23, 2021
Someone sent me data with leader lines (........) between the columns. How can I parse the data?