Excel Tips

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.

Fit a Slightly Too-Large Value in a Cell »

August 30, 2023

I just printed 10 copies of the 20-page report for a meeting. Some numbers printed as ##### instead of numbers.

Transform Black-and-White Spreadsheets to Color by Using a Table »

August 28, 2023

My worksheet is boring black and white. I want to jazz it up with color.

Double Underline a Grand Total »

August 25, 2023

My boss is a CPA. He says I should double underline the grand total in a report. The Home tab of the ribbon offers a single underline icon. How can I add a double underline?