Figure 1291 Word can do a replace without changing the bold.

5. In Word, use Ctrl+A to select all, Ctrl+C to copy. Switch back to Excel with Alt+Tab. 6. Ctrl+V in Excel to paste. The cells are pasted correctly.

Figure 1292 The data is pasted back to Excel correctly.

7. Don’t forget to close Word.

CHANGE THE LOOK OF YOUR WORKBOOK WITH DOCUMENT THEMES

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

4

Figure 1293 The colors can start to look old.

Strategy: Excel 2010 offers 40 built-in themes and adds a dozen more from Office Online.

When you choose a new theme from the Page Layout ribbon tab, Excel changes the accent colors, fonts, and effects in the workbook.

Figure 1294 Choose a new theme for new colors, fonts, and effects.

Excel, Word, and PowerPoint offer the same themes. If you choose the same theme in all three products, your documents should have a similar look and feel.

Additional Details: A theme comprises six accent colors, title and body fonts, and a series of effects.

The Effects dropdown is confusing. For each theme, Excel shows the effects for a circle, an arrow, and a rectangle. The circle gives an indication of the format used for simple formats. The arrow shows the effects used for moderate formatting. The rectangle shows the effects used for intense formats.

From the thumbnails here, you can guess that Module will offer double lines in simple effects, the

Paper theme will offer muted or flat moderate ef- fects, and the Opulent theme is going to offer glass effects when you choose intense formatting.

When you open many galleries such as the Shape Styles Gallery, the last three rows will be labeled “Simple”, “Moderate” and “Intense”. These corre-

spond to the circle, arrow, and rectangle icons in Figure 1295 3 shapes indicate 3 levels of effects. the Effects dropdown.

CREATE YOUR OWN THEME

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

Strategy: Create a new theme and save it on your computer. You can then share it with others in your company.

Follow these steps:

1. Select one of the built-in themes from the Effects dropdown on the Page Layout tab.

2. Open the Fonts dropdown on the Page Layout tab and choose Create New Theme Fonts. Choose a font for headings and a font for body copy. Tip: If you have a stylized logo with “OurCo” and want a font to provide all 26 letters in a similar font, visit Chank.com to have a custom font designed.

3. Open the Colors dropdown and choose Create New Theme Colors. Specify colors for light and dark text and specify six accent colors for the theme.

4. Open the Themes dropdown and choose Save Current Theme. Give the theme a name that reflects your company name.

Results: Excel will offer the new theme in the Themes dropdown. Your custom themes will appear at the top of the dropdown.

To share a custom theme with others, you can copy the .thmx file from %AppData%\Microsoft\Tem- plates\Document Themes\ to the same folder on other computers.

BRING BACK THE OFFICE 2010 COLORS AND SHINY OBJECTS

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

Figure 1297 The Office 2007-2010 theme components are hidden in three different dropdowns.

To create a theme with the old colors, fonts, and effects, you should choose Office 2007-2010 from all three dropdowns: Colors, Effects, and Fonts. Then, open the Themes dropdown and choose Save Current Theme. Give it a name such as Office 2007-2010. In the future, you can choose this theme to bring back all three components of Office 2010.

To make your newly created Office 2007-2010 theme be the default for future workbooks, follow the steps in "Control Settings for Every New Workbook and Worksheet" on page 25.

Problem: 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?

Strategy: If you have an opening menu worksheet in your workbook, you can change the background to any picture.

You start by selecting Page Layout, Background. Excel will let you browse for any image on your computer. The image will be tiled to form the background.

Figure 1298 Picture as a background.

To present a cleaner view, you can turn off the grid- lines for the worksheet. The Show/Hide group on the View tab allows you to turn off the gridlines, the formula bar, and the row/column headings.

Figure 1299 Turn off gridlines and other elements on the View tab.

You can control other worksheet elements in the

Excel Options dialog. Choose File, Options, Ad- vanced. Scroll down to Display Options for This Workbook. You can turn off the display of sheet tabs and the scrollbars.

Figure 1300 Turn off scrollbars in the Excel Options dialog.

Your worksheet will now look cleaner. Gotcha: Turning off all the scrollbar and sheet tab options will affect the entire workbook. Because someone will have to enter data on the other worksheets, this might make it dif- ficult to actually use Excel when an Excel rookie moves on to the other worksheets in the workbook.

Gotcha: The background will never print. See the next topic for a workaround.

Gotcha: If you zoom in or out, the cell sizes will change, but the picture will stay the same size. You might get a picture that perfectly fills A1:J15, but after zooming out, the picture will cover A1:M20.

Figure 1301 No gridlines.

Additional Details: In order to change the background image on a worksheet, you must first remove the first image by selecting Page Layout, Delete Picture.

ADD A PRINTABLE BACKGROUND TO A WORKSHEET

Problem: 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?

Strategy: You can add a shape to cover the printable area of your worksheet and then change the shape fill to be your picture. Microsoft allows you to alter the transparency of the shape. Follow these steps: