Understand how to modify page scaling and margins.On this particular exercise, it requires to set my computer to work with utf-8 files, but I am not able to configure this. Add cells to an existing print area On the File menu, click Print. On the File menu, point to Print Area, and then click Set Print Area.This worksheet will be printed and presented to investors, so it needs to be prepared for printing as well. Formatting Worksheet DataData File: Continue working with CH2 Personal BudgetYou have been given sales data that needs to be formatted in a professional manner. A new data file will be used in this section. We will also preview a two-page worksheet and set page setup options to present the data in a professional manner. Create custom headers and footers to automatically update information.In this section, we will review some of the formatting techniques covered in Chapter 1, as well as learn some new techniques.
![]() ![]() ![]() Configure An Excel Workbook For Printing Format Mac Users ShouldJust click the checkbox for “Scale to fit”Figure 2.46 Settings section of Print Preview Creating a Footer using Page SetupNow that the entire worksheet is printing on one page, you need to add a footer with information about the date the file was printed along with the filename. Click the Scaling drop-down arrow in the Settings section ( Figure 2.46).Mac Users: there is no “Scaling drop-down arrow”. Next you will use Page Scaling to fix this while still in Print Preview. Changing the margins brought the May column onto the same page, but the June column is still on a separate page. Type in 0.5 for the Left Margin and 0.5 for the Right Margin. Select Custom Margins… at the bottom of the list.Mac Users should select “Manage Custom Margins” Figure 2.47 Page Setup Dialog Box Just click the Page Setup button and continue with Step 3 below. Click the dialog box launcher in the Page Setup group. A window similar to Figure 2.47 should appear.Mac Users: there is no “dialog box launcher”. Click the Page Layout tab on the ribbon. You can also create headers and footers using the Custom Header/Footer dialog box. Idoctor mac torrentClick in the Right section: box and type Filename. Making sure to leave a space after the word on, click the Insert Date button. Click in the Left section: box and type Printed on. The Footer dialog box should appear (see Figure 2.48). Click the Custom Footer button. Go to Print Preview to see that the current date and file name are displayed in the footer. Click OK again to close the Page Setup dialog box. The Footer dialog box should look like Figure 2.49. Compare your work with the completed worksheet shown in Figure 2.42 and then submit the CH2 Personal Budget workbook as directed by your instructor.Figure 2.
0 Comments
Leave a Reply. |
AuthorShonta ArchivesCategories |