If you want to have one style for one sheet, and another style for three other sheets, just keep going, applying the appropriate style each time. Then click on the tab for the next sheet, and double-click the style for that sheet. Click on the tab for the first sheet, and in the Styles and Formatting window, double-click the page style you want to apply. The style will appear in the Styles and Formatting window. (Here's how you'd change content in the header.)Ĭlick OK. The style appears in the Styles and Formatting window. Right-click in the window and choose New.Ĭlick OK. The first tab has a few pages of sales data the second sheet, with different and less data, is more of a summary set of data.Ĭhoose Format > Styles and Formatting. Just so you see the sample, here's my spreadsheet. Step 2: Apply a different page style to each sheet That way when you modify one page style, you're not affecting the other sheets because the page style is only applied to that one sheet.Īll right. How to get around this? Well, you just need to have one page style on the first sheet, one page style on the second sheet, and so on. (A page style is just a group of formatting attributes associated with a style name.) And when you choose Format > Page, even though you might not be thinking about styles at all, you're modifying the Default page style. The reason that the changes apply to the entire spreadsheet is because the Default page style is applied to every sheet in the spreadsheet. Well, the way I just showed you won't work because the changes apply to the entire spreadsheet. You want different page layout in each sheet of your spreadsheet. Let's say that the data in the first sheet is pretty wide so you'd like a landscape layout, and the data in the second sheet is narrow and a different type of information, so you'd like it not just portrait but with a different header. Margins and orientation in the Page tab Headers in the Header tab Borders around the content in the Border tab etc.īut.what if you've got content in a couple different sheets of your spreadsheet, or more. Choose Format > Page, and make your changes.
0 Comments
Leave a Reply. |