How can I print out the formulas on my worksheet? I want to print the actual formulas, not the results.
	Whenever I set the Fit To option in Excel's page setup, all my manual page breaks disappear. How can I use this option and retain my manual page breaks?
	How can I make headers and footers default to none whenever I create a new worksheet?
	How can I print my row and column titles on every page?
	What page setup options are available in Excel?
	How do I set my page margins?
	How do I preview and edit my worksheet before I print it?
	How can I print only part of my worksheet?
	How do I insert a manual page break?
	How do I create a Custom Header or Footer?

How can I print out the formulas on my worksheet? I want to print the actual formulas, not the results.
Keywords: Printing, Formulas
Posted December 17, 1996

Excel has a Formula View that shows the formulas on your worksheet rather than the results of those formulas. You toggle between Formula View and Normal View by pressing CTRL ~ on your keyboard. Just toggle to formula view and print your worksheet to see all of your formulas.

Whenever I set the Fit To option in Excel's page setup, all my manual page breaks disappear. How can I use this option and retain my manual page breaks?
Keywords: Fit To Option Manual Page Breaks
Posted November 7, 1996

You can get manual page breaks while using the Fit To option if you only set the Fit To dimension that you need, while leaving the other one blank. For instance, if you want your worksheet to fit on one page wide and set your own page breaks in the long direction, you set the Fit To option like so:

Fit to 1 page(s) wide by <blank> page(s) tall

Then you can set your page breaks in the long direction and they will be retained.

How can I make headers and footers default to none whenever I create a new worksheet?
Keywords: Header Footer Default Startup Xlstart
Posted November 7, 1996

To do this you need to make two templates and store them in your startup directory. The first template, called book.xlt, will override the defaults Excel uses to create new workbooks. The second, called sheet.xlt, will override the defaults Excel uses when creating new worksheets.

For book.xlt

1. Open a new workbook, add the number of blank sheets you want to have as a default and use the page setup command to set the headers and footers to blank for all sheets.
2. Choose File - Save As from the menu, change the file type to Template (this is very important, if you save it as a normal workbook this won't work), navigate to your excel\xlstart directory and save your file there with the filename book.xlt.

For sheet.xlt

1. Open a new workbook, delete all worksheets except one and use page setup to remove headers and footers from that worksheet.
2. Save it in the same manner as step 2 above, but this time use the filename sheet.xlt.

From now on, any new workbooks and any new worksheets that you add to existing workbooks will default to no headers or footers.

How can I print my row and column titles on every page?
Keywords: Print Row Column Titles
Posted May 19, 1996

If the printout of your worksheet extends far more than a single page, your row and column titles will normally only print on the first page. This can make the subsequent pages difficult to read. Excel can print the titles on each page. If you select one or more rows/columns, they will print at the top/left of each page. To define the titles you want to print on every page:

1. From the menu bar choose File - Page Setup...
2. Click on the Sheet tab
3. In the Rows to Repeat at Top edit box, type in the range for the column headings that you want to appear at the top of each page. (You can also select the range with the mouse)
4. Do the same in the Columns to Repeat at Left edit box
5. Click on OK or press Enter

Excel defines the name Print_Titles for the ranges you entered.

To remove this feature and turn off the print titles:

1. From the menu bar choose Insert - Name - Define...
2. Highlight the Print_Titles name and press the delete button, OR,
3. From the menu bar choose File - Page Setup...
4. Delete the references from the Rows to Repeat at Top and Columns to Repeat at Left edit boxes

What page setup options are available in Excel?
Keywords: Page Setup Options
Posted May 19, 1996

Prior to printing your spreadsheet, you need to decide on the appearance of your worksheet. This includes deciding on the page orientation as well as the size of your margins. To choose your options:

1. From the menu bar choose File - Page Setup
2. Select the Page tab

The Page Orientation allows you to determine how Excel will lay out the worksheet data

• To print along the short side (normal orientation), select Portrait
• To print along the long side of the page, select Landscape
• To scale the data to fit a specific page, click on Adjust to... or Fit to...

Next, determine the Paper Size; use the drop-down list to select the size.

• Standard letter size (8 1/2 x 11)
• Legal size (8 1/2 x 14)

Finally, if the document you are printing is part of a larger report, you might want to start your page numbers at a number other than 1. To do this:

• Enter the appropriate number in the Page tab's First Page Number box

How do I set my page margins?
Keywords: Page Margins Setup
Posted May 19, 1996

The page margins are the blank areas that surround the printed text. By default, Excel sets the margins at 1 inch for the top and bottom margins, and 0.75 for the left and right margins. You might want to change these for various reasons. It might be that you have a worksheet that will not quite fit on a page or maybe you need bigger margins so that you are able to make notes on the page. In any case, changing the margins is very simple.

To adjust the margins:

1. From the menu bar, choose File - Page Setup... and the Margins tab
2. The Top, Bottom, Left, and Right edit boxes enable you to enter your new margin values
3. The From Edge option controls how far the Headers and Footers appear from the edge of the page
4. To center your spreadsheet on the page, choose either Horizontally or Vertically
5. Finally, the Preview section of the Margins tab will show you the effects of what you have chosen.

How do I preview and edit my worksheet before I print it?
Keywords: Print Preview Edit Worksheet
Posted March 31, 1996

In Excel's normal screen display, you cannot see page elements like margins, headers, and footers. However, these can be seen using the Print Preview feature. This feature allows you to see a full-page, scaled-down version of your worksheet page. Print Preview also allows you to adjust your margins using the mouse and print from the preview screen as well.

To see the preview screen:

• From the menu bar choose File - Print Preview or use the Print Preview button on the Standard toolbar.
• Excel will display the first page of your printout.

To view other pages in the printout, click on the Next and Previous buttons, or use the following shortcut keys:

• Down arrow - Moves to the next page
• Up arrow - Moves to the previous page
• End - Moves to the last page
• Home - Moves to the first page

To change your page margins and column widths:

• Click on the Margins button.
• The handles at the top of the screen appear. The dotted lines indicate the margins.
• By dragging the handles, you can change the margins and columns visually.

From the Print Preview screen, Excel offers the following additional options:

• To print the worksheet, click on the Print button and the Print dialog box will appear with the options for printing.
• To change your page setup, click on the Page Setup button and the dialog box will appear with the options to change the page setup.

To exit Print Preview:

• Click on the Close button. You will then be returned to your full-sized worksheet.

Hint: To toggle between the full and actual sizes of the worksheet, click on the Zoom button OR move the mouse pointer to the page so that the pointer changes to a magnifying glass. Position the pointer over the area you want to zoom and click.

How can I print only part of my worksheet?
Keywords: Print Portion Worksheet
Posted January 20, 1996

You can set your print area before you print. You can also specify rows or columns that you want to repeat on every page when you set your print area.
To set the print area:

1. Select the range you want to print and from the menu bar choose File - Print
2. Under Print What, select the Selection option
3. Click on OK

Additionally, you could select the range you would like to print and choose the Set Print Area Button. This button is available by customizing your tool bar (button is found in the File category) or by using the Baarns Bonus Quick Tools (part of the Baarns Utilities).
To set both your print area and print titles:

1. From the Menu bar choose File - Page Setup
2. Select the Sheet tab
3. In the Print Area box, select the range or ranges on the worksheet that you wish to print
4. To print, choose the Print button

You can also type cell references or defined names in the Print Area box.
If you want to print titles at the top of every page or titles at the left of every page, follow these steps:

1. Select the Rows To Repeat At Top or Columns To Repeat At Left under Print Titles
2. On the worksheet, select the rows or columns you want printed on each page
3. Choose OK to close the Page Setup dialog box

How do I insert a manual page break?
Keywords: Insert Manual Page Break
Posted January 16, 1996

Excel sets automatic page breaks to delineate the print area for each page. To see the select the Tools - Options - View tab. Page breaks show up as thin dashed lines, you can see the page breaks easily if you turn off the worksheet gridlines. You can not adjust the automatic page breaks, however, you can override them using manual page breaks. This allows you to control which data is printed on each page. To set a manual page break, position the cell pointer where you want to insert the manual page break. Select the Insert - Page Break command. To remove page break, select Insert - Remove Page Break command.

Both automatic and manual page breaks appear as dashed lines on your worksheet. However, you can tell the two kinds of page breaks apart by noting that automatic page breaks use smaller dashes with more space between each dash than the manual page breaks.

How do I create a Custom Header or Footer?
Posted January 16, 1996
Keywords: Create Custom Header Footer

To create a custom Header or Footer select File - Page Setup - Header/Footer tab.

Then choose either the Custom Header button or the Custom Footer button. Choose either the Left Section, Center Section, or Right Section edit box. Enter your own text or select one of the buttons to insert any of the following codes:

& [Page] (page number)
& [Pages] (page count)
& [Date] (date)
& [Time] (time)
& [File] (workbook filename)
& [tab] (worksheet tab name)

If you want to select a different font, click on the Font button in the font dialog box and then click on OK to display the Header or Footer.

Back to Top

Back to the FAQ Table of Contents

You have the right to remain silent. Anything you say will be misquoted, then used against you.