A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
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,
- PressF5, type in AA100 and hit*<enter>*. That is the cell one down and one right of Z99.
- PressCtrl+Shift+<right arrow>. Release and pressCtrl+<spacebar>. Release and pressAlt+EthenD or right-click the highlighted columns and tap*****Delete*.
- PressHome, then pressCtrl+Shift+<down arrow>. Release and pressShift+<spacebar>. Release and pressAlt+E thenD or right-click the highlighted rows and selectDelete.
- PressCtrl+Home to return to A1. ImmediatelySave orSave As if you don't trust your keystrokes.
- 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.