FastTips for Microsoft Excel 4.0: Printing Q&A

SUMMARY

Questions and Answers: Printing

1. Q. When I choose Page Setup, certain options are grayed or unavailable. How can I access these features?
   
   A. A commonly requested feature for Excel version 3.0 was the ability to use Reduce or Enlarge for any printer, and a fit-to-page option. Excel 4.0 now supports these scaling features for all printers. Other document setting options may, however, not be available.
   
   If certain options are grayed or unavailable, then the currently selected printer driver doesn't support these extended options, or Excel has a way of implementing the option that is more flexible. For example, many printers allow only a few reduction options, such as 100 percent and 50 percent. Using Excel 4.0's new Reduce or Enlarge feature in Page Setup, you can select any percentage, including 100 percent and 50 percent. This allows you more flexibility in your work, so Excel asks the printer driver to gray, or make unavailable, its options in favor of Excel's.



2. Q. I understand that a new feature in Excel 4.0 is the ability to create multiple-line headers and footers. How can I do this?
   
   A. The creation and modification of headers and footers in Excel 4.0 has been greatly simplified. You can insert a page number, date, time, or filename with a simple click of a button. In addition, you can create multiple-line headers and footers by pressing OPTION+ENTER at the point you want to insert a carriage return.
   
   To create a multiline header or footer, follow these four steps:
   
   
   1. From the File menu, choose Page Setup.
   
   
   
   2. Click the Header or Footer button.
   
   
   
   3. Select the Left, Center, or Right section depending on where you want your text aligned on the page. To select the section, click inside the appropriate section box.
   
   
   
   4. Enter some text into the box. At the point where you want to insert a carriage return, hold down the OPTION key and press ENTER.
   
   
   



3. Q. How can I start my page numbering with a number greater than one?
   
   A. To begin page numbering with a number greater than one, you must modify the Header or Footer section in Page Setup. To do so, follow these five steps:
   
   
   1. From the File menu, choose Page Setup.
   
   
   
   2. Click the Header or Footer button.
   
   
   
   3. The default Footer will have Page &P in the Center alignment section. If you prefer to have your page number aligned to the left or the right, delete Page &P from the Center section and select the appropriate section. To select it, click inside the appropriate section box.
   
   
   
   4. Click the button with the pound symbol on it. This will place an &P in the box. You may also manually type &P if you prefer.
   
   
   
   5. To begin page numbering at a number greater than one, after the P, insert a plus sign and the number you'd like the numbering to start with, less one. For example, if you want the page numbering to begin with 3, insert a plus sign and the number 2 after the &P.
   
   
   

Additional query words: noupd

Keywords          : 
Version           : 
Platform          : 
Issue type        : 

Last Reviewed: March 24, 1999