Excel Tips


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?


Use the Border Tab in Format Cells »

August 24, 2023

Borders drive me insane. How can I take control of my borders?


Show Checkmarks in Excel »

August 21, 2023

I have to show checkmarks in a list. How do I create a checkmark in Excel?


There is a Font Optimized for Excel »

August 18, 2023

I am looking at numbers all day long. Is there a better font?


Highlight Items Above Average »

August 17, 2023

Sometimes I need to use conditional formatting to choose all the cells that are above average or I need to highlight cells in the top fifth percentile.


Comparative Histogram »

August 16, 2023

I want to compare two populations of data.


Data Bars Options »

August 15, 2023

Cells that contain 0 will get no data bar.