Excel Tips
Use Cell Styles to Change Formats »
September 13, 2023
Gurus of Microsoft Word have known about using styles for two decades. Microsoft promotes styles in Excel, adding a dropdown right on the Home tab offering 42 built-in styles.
September 12, 2023
In my copy of Excel, I type 152 and Excel enters 1.52. What is going on?
September 8, 2023
I want to fill the blanks to the left of a number with asterisks like a check-printer would do.
September 7, 2023
I work in an industry that reports values in fractions. Stockbrokers used to deal in increments of 1/8, and tire engineers still measure tread depth in increments of 1/32 inch.
For Each Cell in Column A, Have Three Rows in Column B »
September 6, 2023
For each cell in column A, I want to have three rows in columns B and C, as here. I also want to be able to perform calculations with the values in column C.
Show Two Values in a Split Cell »
September 5, 2023
My manager wants me to show two values in one cell, as shown here.
Prevent Long Text from Spilling »
September 4, 2023
I have a column with long comments. When the adjacent column is blank, the text from the comment spills over into the adjacent cell.
Delete All Pictures in Pasted Data »
September 1, 2023
I copy data from my bank’s Web page into Excel. On the Web page, the bank has little check icons that let me view a physical copy of a check. These check icons show up as annoying images in my Excel workbook. How can I delete all these images in one step?
Turn Off Wrap Text in Pasted Data »
August 31, 2023
I regularly paste information from Web pages, and I am frustrated by the way Excel wraps text in cells.