Page 269 - Excel 2013 All-in-One For Dummies
P. 269
Reorganizing the Workbook 251
the program does this by stretching the graphic so that it takes up all the cells that are visible in the Workbook window. In the case of some smaller images, the program does this by tiling the image so that it’s duplicated across and down the viewing area.)
Keep in mind that a graphic image that you assign as the worksheet back- ground doesn’t appear in the printout, unlike the pattern and background colors that you assign to ranges of cells in the sheet.
To remove a background image, you simply click the Delete Background command button on the Page Layout tab of the Ribbon (which replaces the Background button the moment you assign a background image to a work- sheet) or press Alt+PSB again, and Excel immediately clears the image from the entire worksheet.
You can also turn online graphics into worksheet backgrounds. Simply select the Search Office.com text box (to insert a Clip Art image) or the Search Bing text box (to insert a web graphic). Then, perform a search for the image you want to use. (See Book V, Chapter 2 for details.) When you locate the online graphic you want to use, double-click its thumbnail to download the image and insert it into the current worksheet as the sheet’s background.
Adding and deleting sheets
You can add as many worksheets to the single Sheet1 that comes as part of every new workbook as you need in building your spreadsheet model. To add a new worksheet, click the New Sheet button, which always appears on its own tab immediately after the last sheet tab in the workbook (with the plus inside a circle icon).
Excel then inserts a new sheet at the back of the default Sheet1 worksheet in the workbook (and immediately in front of the tab with the New Sheet button), and the program assigns it the next available sheet number (as in Sheet2, Sheet3, Sheet4, and so on).
You can also insert a new sheet (and not necessarily a blank worksheet) into the workbook by right-clicking a sheet tab and then clicking Insert at the
top of the tab’s shortcut menu. Excel opens the Insert dialog box containing different file icons that you can select — Chart, MS Excel 4.0 Macro, and MS Excel 5.0 Dialog, along with a variety of different worksheet templates — to insert a specialized chart sheet (see Book V, Chapter 1), macro sheet (Book VIII, Chapter 1), or worksheet following a template design (Book II, Chapter 1). Note that when you insert a new sheet using the Insert dialog box, Excel inserts the new sheet in front of the worksheet that’s active (and not at the end of the workbook as when you insert a worksheet by clicking the New Sheet button).
Book II Chapter 4
Managing Worksheets