Solved Can't add another page to an xlsx spreadsheet

Microsoft Excel 2010 - complete product...
May 29, 2014 at 08:43:35
Specs: Windows 7, Falcon Talon 3.1 GH
I have nine pages in my xlxs document, when I go to add additional
data, it won't set up another page

See More: Cant add another page to an xlsx spreadsheet

Report •

#1
May 29, 2014 at 10:56:37
What do you mean by "it won't set up another page"?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
May 29, 2014 at 11:59:27
I enter the data but it doesn't create the next page.

Report •

#3
May 29, 2014 at 12:45:57
✔ Best Answer
I still don't know what you mean.

Excel doesn't really create "pages". Pages only enter into the discussion when it comes to printing the spreadsheet.

There are default Page Breaks and users can also insert their own Page Breaks. The user can also set a Print_Area so that only portions of the spreadsheet will actually be printed.

Is it possible that someone has set a Print_Area that only includes a part of the spreadsheet, enough to print the "9 pages"? If that's the case, then anything entered outside that Print_Area won't be printed unless you expand the Print_Area or delete it entirely. Deleting the Print_Area will allow Excel to print the entire spreadsheet.

Click the drop down in the Name Box above Column A. If you see the string Print_Area, select it. This should highlight the area that will be printed if a Print_Area has been manually set.

If you don't see Print_Area in that drop down or if I am way off base regarding your issue, you'll need to explain what is happening (or not happening) in more detail.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question