C
Cosmo
Is there a way to set the number of cells for a page break?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Suddes
yes, view - page break preview
then just drag your page breaks to suit
then just drag your page breaks to suit
C
Cosmo
Some of my sheets have 50+ pages so I have to adjust each page. Is there any
way to change all of them to a set size?
way to change all of them to a set size?
C
challa prabhu
Answer: Print using Custom View.
Do the following:
1. Select a range of cells.
2. On the View menu, click Custom Views.
3. In the Views box, click the name of the view
(view: A set of display and print settings that you can name and apply
to a
workbook. You can create more than one view of the same workbook without
saving separate copies of the workbook.) you want to print.
4. Click Show.
The range of cells will be shown as selected
5. Click Print.
6. Under Print What, click Selection
7. Click OK.
Note: You craete as many Custom View as possible, and print only those
views. Most important thing is you must select the range and during print you
must select Selection option. You can chage the Page sige before printing.
Challa Prabhu
Do the following:
1. Select a range of cells.
2. On the View menu, click Custom Views.
3. In the Views box, click the name of the view
(view: A set of display and print settings that you can name and apply
to a
workbook. You can create more than one view of the same workbook without
saving separate copies of the workbook.) you want to print.
4. Click Show.
The range of cells will be shown as selected
5. Click Print.
6. Under Print What, click Selection
7. Click OK.
Note: You craete as many Custom View as possible, and print only those
views. Most important thing is you must select the range and during print you
must select Selection option. You can chage the Page sige before printing.
Challa Prabhu