Excel Tips
Use Excel as a Word Processor »
September 30, 2021
I need to type some notes at the bottom of a report. How can I make the words fill each line as if I had typed them in Word?
September 29, 2021
I need to enter the current date, current time, or current date and time in a cell. I don’t want to use NOW() or TODAY(), because those values will change over time. I want to lock in the current date or time.
Add Total to the End of Jan, Feb, ... Dec »
September 28, 2021
Every time I drag the fill handle to put month headings in my worksheet, I have to type the word total in the 13th column. The four custom lists for months and weekdays can not be edited in the Custom List dialog box.
September 27, 2021
The fill handle can fill weekdays, months, quarters, and now numbers. Why can’t it fill A, B, C?
Have the Fill Handle Fill Your List of Part Numbers »
September 24, 2021
Sure, the fill handle is good for filling months, days, and sequential numbers. But what about other lists I have to type lists of product lines, company regions, sales rep names, and so on.
Enter a Series of Months, Days, or More by Using the Fill Handle »
September 23, 2021
I need to create a new worksheet. My first task is to enter the 12 month names across row 1. Is there a faster way than typing them all?
Mix Formatting In A Single Cell »
September 22, 2021
I’d like to use strikethrough on the text in part of a cell. Is this possible?
Why Can’t Excel Find a Number? »
September 21, 2021
The Excel Find and Replace dialog drives me crazy. I always have to go to the Options button to specify that it should look in Values. In the figure below, the mouse pointer is showing the value that Excel says is not there is actually there. Why can’t Excel find a number?
September 20, 2021
I suspect that there are cells in my data that contain text numbers instead of numbers. I know that numbers entered as text cause a variety of problems. For example, although a formula such as =E3+E4 will include the text number in E3, most functions, such as SUM or AVERAGE, will ignore the text cells. Text versions of a number will sort to a different place than numeric versions. If I use a MATCH or VLOOKUP function, a text version of 3446 will not match a numeric version of 3446. How can I find text entries that need to be converted to numbers?