Share via

When printing in Excel, I get 8 extra pages, how do i delete them?

Anonymous
2012-04-28T23:32:32+00:00

in printing out an 8 page file i get 8 blank pages.  how do i delete them?  i am working in excel.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

  1. Anonymous
    2012-04-29T02:26:11+00:00

    in printing out an 8 page file i get 8 blank pages.  how do i delete them?  i am working in excel.

    You probably had a value in a cell outside your current UsedRange that is now deleted but Excel still considers to be the extent of your worksheet information. You can test this by tapping Ctrl+End. This takes you to what Excel thinks is the extent of your worksheet.

    If you need to reset the Last_Cell in a worksheet, first locate the intersection of the right-most column and greatest row. Let's call that Z99. If you are absolutelysure that Z99 is the last cell will data in it, walk through these steps,

    1. PressF5, type in AA100 and hit*<enter>*. That is the cell one down and one right of Z99.
    2. PressCtrl+Shift+<right arrow>. Release and pressCtrl+<spacebar>. Release and pressAlt+EthenD or right-click the highlighted columns and tap*****Delete*.
    3. PressHome, then pressCtrl+Shift+<down arrow>. Release and pressShift+<spacebar>. Release and pressAlt+E thenD or right-click the highlighted rows and selectDelete.
    4. PressCtrl+Home to return to A1. ImmediatelySave orSave As if you don't trust your keystrokes.
    5. TapCtrl+End and you should be in the newLast_Cell (e.g. Z99).

    It might seem like a lot, but it takes a lot more time to type it than it does to actually do it.

    Alternately, you can simply specify a Print Area on the worksheet from the Page Layout tab's Page Setup group. Both of these methods can be tested with Print Preview prior to printing.

    10+ people found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful