Tuesday, April 5, 2011

How to customize the workbook in Microsoft Excel: default

Gets the standard workbook when you create a new Excel workbook. But what if that book do not like or? For example, maybe print page always (or almost) to use has a standard header. Prefer a different default font style or new worksheet created sizes, number formats, change the width of a column layout often.

To do this, the appearance and layout of the Excel worksheet to give quite a bit of control. Very much, is to create a completely customized default workbook is easy. If you create in Microsoft Excel 2010 and Excel 2007 is behind this magic trick template file named book.xltx (book.xltm) on the default workbook contains macros, the file saves to the appropriate location on your hard drive.

To create a new default workbook template.

Open a new blank Excel workbook. Customize exactly to the blank workbook. Save the workbook in the folder specified in the specific file name. Additional ideas and procedures are as follows.

Excel workbook might change some elements:

Font styles and font sizes: highlight part of a worksheet and select the number, alignment, and font formatting settings from the home tab, in the font . Print settings: one or multiple worksheets selected, page layout] tab > page settings group headers and footers, margins and print orientation, such as of specify print settings, and other page layout choices to indicate. Removes thenumber of seats: additional or worksheet name sheet tab to change the color of the worksheet tabs. : Column widths and layout change the width of the column otherwise usually prefer different column widths, select the column, or an entire worksheet.

Note: your custom default workbook to insert the back in a new worksheet, to return to the original formatting and layout. You may book a source workbook, extra worksheet, you can copy on additional demand, extra or master worksheet.

How to apply changes to multiple cells or worksheets

To apply formatting changes to all cells, columns, or rows, first of all to all cells in the selection (press Ctrl + A) highlight. When you are finished, press [Ctrl] + [home] highlight the cell clears.

To print multiple worksheets in the workbook settings apply, such as formatting changes, right-click any sheet tab, select all sheets on the] and click. Complete the change, all sheet tabs in the group the worksheets off click again.

You do not need to create a new workbook by default all (the default is 3), if you want to change the number of worksheets in a new workbook. Select the file in Excel 2010, > options, in the General category to select, and then sets number of sheets needed for this many sheets. In Excel 2007, select the Microsoft Office button, click Excel Options. This many sheets specifies the number of sheets for setting, and then select popular categories.

To save your new default workbook.

If the default new workbook are your favorite files tab or the Microsoft Office button, then choose Save as to save > Excel workbook. Save as] dialog box, select the Excel template (.xltx), and select the file type drop-down list. Name the file as book.xltx. Need to save files in the XLSTART directory on the local c: drive. Location of this directory varies depending on the version of Windows and Microsoft Office; to find the hard drive folder. You can close it after you save the template file. Close Excel. See new books to start Excel.

Each time you start Excel now, a new blank workbook create template based on. In addition to clicking the new toolbar button (or press [CTRL] + N), a new workbook created from the template.

Like usual, this or other default workbook can be customized individually if necessary.

No effect on workbooks, create, and change the default on your computer only save active workbook custom default Excel workbook to use computers on the network by other users. To share the default workbook book.xltx files copy to the appropriate location on another computer, however, can.

XLSTART directory is on your network if you are storing files, you must access permissions. Instead, this new alternate startup directory book.xltx save file, and then any name that you can create unique system startup directory. Select Directory names are unimportant, but need to tell it to Excel.

In the other directory to save the default workbook.

Create a new folder in book.xltx file containing the C drive. File selection in Excel 2010, > options], click the Advanced category, and click. In Excel 2007, click Microsoft Office button and choose Excel Options, and then select the Advanced category. Enter the full path of the section of general use as the alternate startup folder at startup, open all files in box. Book of the same name opens a file in the XLSTART folder if in both the XLSTART folder and the alternate startup folder.

??: Only be able to try to Excel open all files in the alternate startup folder, open the Excel files and determine whether or not to specify folders that contain only files each time you start Excel.

To save effort and time in Microsoft Excel, creates its own custom books today.

Dawn Bjork Busby Microsoft Office Specialist (MOS) master certified instructor and certified expert certified instructors, Microsoft application professionals (paid), Microsoft Office and as the software Pro ? and Microsoft Certified Trainer (MCT) is. Dawn software speakers share smart ways to use software effectively through her work as a trainer, consultant, and author of six books. Software for more tips, tricks, strategy and technology the found at http://www. SoftwarePro.com.

No comments: