Excel help (page breaks)

[NJDevil]

I'm working on a project where I need to insert a page break in between some data, however, I cannot do it. I open a new excel file enter some data and hte page break utility works fine, just not in the file I need it in. Any suggestions? Is there a possibility of that option being disabled in that file?

Thank you for your help

 

[imported_Pressure]

I suggest totally remaking the file.

 

[NJDevil]

that's not really an option

 

[Googer]

This thread belongs in the software forum.

 

[NJDevil]

Originally posted by: Googer
This thread belongs in the software forum.

I know, i asked there too but this is urgent and I know many more check general than software. Sorry

 

[imported_Pressure]

If there's no other way to get it to work then it is an option.

 

[dullard]

More info needed.
1) Why can't you just print what you need manually since you are under a important deadline and then fix the problem later?
2) Is the page break option disabled (note it is always disabled if the cell A1 is selected), or does the menu option it simply not function?
3) If the menu option functions, are your page breaks ignored?

Fix for #2 if it is disabled:
A) Try selecting another cell.
or
B) Go to menu: View / Page Break Preview. Try them manually there.

Fix for #3 (from Excel help file):

Excel ignores the page breaks I set.

If your workbook is set up so that Excel fits your printed work on a specific number of pages, Excel ignores the manual page breaks you've set and reduces the size of the printed worksheet. (To see whether this is the case, click Page Setup on the File menu, click the Page tab, and check the Fit to option under Scaling.)

Use Adjust To instead of Fit To To fit the worksheet to the specified number of pages and use the manual page breaks you inserted, click Page Setup on the File menu, click the Page tab, and then click Adjust to.

Set each page as a separate print range If Adjust to doesn't produce the results you want, you can set a print area with each page selected as a separate range. Excel prints nonadjacent ranges in a print area on separate pages.

Insert a blank row or column in each location where you want a manual page break.
Select the range you want to include as the entire first page, omitting the blank row or column.
Hold down CTRL and select the range for the second page, omitting the blank rows or columns. Continue until you've selected all pages that you want to print.
On the File menu, point to Print Area, and then click Set Print Area.
On the File menu, click Page Setup, click the Page tab, click Fit to, and enter the number of pages you want.