Excel Tips
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.
October 12, 2023
I have a thousand rows of data. I want to apply red and blue to every other row. Nothing in the Format as Table looks exactly like I want it to look and I don’t want to define my own table style.
