When you open a new workbook, Excel creates a copy of a template file named book.xlt (the.xlt extension denotes a template file). If you normally make the same changes to every new workbook, I recommend that you make those changes as defaults in book.xlt. That way, every new workbook will open with the settings you need and you can go right to work!
Experience the best of Office with the latest versions of Word, Excel, PowerPoint, and more.
To customize book.xlt, open Excel, choose Open from the File menu, and navigate to one of the following folders to find book.xlt:. C: Documents and Settings Administrator Application Data Microsoft Templates. C: Program Files Microsoft Office OFFICE x XLSTART where x is the version number. For instance, if you're using Office 2003, that folder would be OFFICE11.
If you can't find book.xlt, use Windows Search feature. UPDATE If you still can't find book.xlt, see the section below for instructions on creating it. Once you have book.xlt open in Excel, make the necessary changes to bring the template into compliance with your organization. You might alter the font, borders, and alignment defaults.
Or you might delete or add sheets to control the number of sheets each new workbook offers. You might even add a generic header or footer. For instance, you can enter a header that will display each new workbook's name, as follows:. Choose Header And Footer from the View menu. From the Header control, choose Book1. Click OK and Excel will display the workbook's name in the header. This header trick works in any workbook, not just Excel's template file.
When you've finished customizing book.xlt, save it as book.xlt. Don't change the filename. Specify Template (.xlt) in the Save As Type control and be sure to save the altered template in the same folder where you found it.
Customizing book.xlt makes sense. By reducing the amount of work necessary to get each new workbook file ready, you'll be more efficient and productive. MIssing book.xlt?
UPDATE If your Windows search for book.xlt doesn't turn up a file, don't worry. Depending on how you installed Office, the built-in template might not be on your local system.
If this is the case, just create the file yourself. Open a new workbook file and apply all the settings and formats you want. Then, save the file using the name book and make sure you specify Template (.xlt) in the Save As Type control. In addition, you must save the file in one of two folders: C: Documents and Settings Administrator Application Data Microsoft Templates C: Program Files Microsoft Office OFFICE x XLSTART.
The Excel page break option helps you see where page breaks will appear when your worksheet is printed. In this article I'll show you several ways to insert them manually or by condition. You'll also learn how to remove page breaks in Excel 2010 - 2016, where to find the Page Break Preview, hide and show the marking lines. Page breaks are separators that divide a worksheet into individual pages for printing. In Excel, page break marks are inserted automatically according to the paper size, margin and scale options. If the default settings don't work for you, you can easily insert page breaks in Excel manually.
It's really helpful for printing a table with the exact number of pages you want. In this post, I'll show you how to use the Excel Page Break Preview to easily see the changes you make. Also, you'll see how you can adjust the page breaks in the worksheet before printing, how to remove, hide or show page breaks.
How to insert a page break in Excel manually If you go to the Print Preview pane and don't like the way your Excel data is laid out for printing across several pages, you can manually insert page breaks where you need them. Below you'll find the steps showing how to do it. Pick your Excel worksheet where you need to insert page breaks. Go to the View tab in Excel and click on the Page Break Preview icon in the Workbook Views group.
If you get the Welcome to Page Break Preview dialog box, click OK. Tick the Do not show this dialog again check box to avoid seeing this message again. Now you can easily view the location of page breaks in your worksheet. To add a horizontal page break, select the row where the marking line will appear. Right-click on this row and select the Insert Page Break option from the menu list. If you need to insert a vertical page break, pick the necessary column to the right. Right-click on it and pick Insert Page Break.
If manual page breaks that you add don't work, you may have the Fit To scaling option selected (Page Layout tab - Page Setup group - click Dialog Box Launcher Button image - Page). Change the scaling to Adjust to instead. On the picture below, you can see 3 horizontal page breaks added. Therefore, if you go to Print Preview, you'll see different parts of data on separate sheets. Insert a page break in Excel by condition If you often print your data tables, you may want to learn how to automatically insert page breaks in Excel by condition, for example when a value in certain column changes. Say you have column named Category and you want each category to be printed on a new page. Below, you'll find several helpful macros and the steps how to add page breaks using the Excel built-in Subtotal functionality.
Use macros to add the marking lines Below you can find two really useful macros. They will remove all default page breaks in your table and will easily add new marking lines at the appropriate locations. Just select the range of cells you want to use for splitting and avoid the headers. InsertPageBreaksIfValueChanged - inserts page breaks if the value in the column changes. InsertPageBreaksByKeyphrase - adds a page break each time it finds a cell that contains 'CELL VALUE' (it's the entire cell, not part of it, don't forged to replace 'CELL VALUE' in macro with your actual key phrase).
If you are novice in VBA, feel free to read. After you move an automatic page break, it becomes a manual one. Hide or show page break marks Below you'll find how to display or hide page breaks in the Normal view. Click the File tab.
Go to Options - Advanced. Scroll down to the Display options for this worksheet group and tick or clear the Show page breaks check box. Now you know how to easily turn page breaks on or off in the Normal view. Reset back to the Normal view Now that all your page breaks found the correct location, you can return to Normal view. It's as simple as clicking on the Normal icon under the View tab in Excel.
You can also click Normal Button image on the status bar. In this article I showed how to use the Excel page break option. I tried to cover all its options and now you know how to insert, remove, show, hide and move page breaks to adjust them before printing.
You've also got several helpful macros to add marking lines by condition and learnt to work in the Excel Page Break Preview mode. Please let me know if you have any questions. Be happy and excel in Excel! I am attempting to manually move a page break, as I've always done, but instead of the page accommodating with the move by scaling down a bit, as it usually does, I get about 100 individual page breaks on my page. This has never happened before.
The page automatically scales down to 10% and it has like I said about 100 page breaks. I have to undo to remove or scale the page back to 100%. I am not sure if I accidently changed something in my settings but I don't recall doing anything differently with the document. Is there anything I can do to avoid this?