Excel Tips


Pasted URLs Don’t Become Hyperlinks »

October 27, 2023

I pasted hundreds of web site addresses into Excel. They did not turn into hyperlinks. I found that I could select a cell, press F2, then Enter to make the hyperlink. But I don’t want to have to do that hundreds of times.


Remove Hyperlinks Automatically Inserted by Excel »

October 24, 2023

Excel has an annoying habit. Whenever you type something in a cell that looks like an e-mail address or a Web site URL, Excel will underline the value, change the font color to blue, and make it a clickable hyperlink.


Make any Picture Transparent »

October 23, 2023

The image I added as a background using the instructions in the previous topic will not print. How do I add a background image that will print?


Change the Background of a Worksheet »

October 20, 2023

Excel looks boring. It generally has black text on a white background, with gray lines. Can I change the background of a worksheet to liven it up?


Bring Back the Office 2010 Colors And Shiny Objects »

October 19, 2023

When Microsoft introduced themes in Excel 2007, the Office theme was comprised of six bold colors: blue, red, green, purple, aqua, and orange. Millions of workbooks were created using these colors. Suddenly, in Excel 2013 and 2016, the Office theme changed to flat colors: blue, orange, grey, yellow, light blue, green. Because Microsoft named the new theme “Office”, there is no obvious way to get the old colors back.


Create Your Own Theme »

October 18, 2023

There isn’t a theme to match our company colors.


Change the Look of Your Workbook with Document Themes »

October 17, 2023

The new Excel has a lot of nice-looking features. It uses new colors, new fonts, new chart colors. But after a while, the blue, red, green, purple, teal, and orange colors get old. Here is a worksheet with a table, SmartArt, a chart, a picture, and shapes.


Replace Partially Bold Cells »

October 16, 2023

I have some cells that are partially bold. When I use Find and Replace to change the text in these cells, I am losing the bold.


Change All Red Font Cells to Blue Font »

October 13, 2023

I’ve marked a few hundred cells in a large workbook using a red font. My manager is superstitious and wants all the red cells changed to blue. The red cells are not contiguous. I did not use cell styles to apply red.