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.
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.