Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Extra pages
Hi,
please show me to remove empty pages. -------------- I selected all cells which are under my needed parts and hit delete or cut, but I didn't work. When I used printview or pagebreak, I still see 14,178 pages. Ex: the worksheet has 100 rows which stored data. I select row from 101 to 8,000 or more and hit delete, but nothing happen. Thank you loi |
#2
|
|||
|
|||
You are deleting the data. Delete the ROWS and SAVE.
-- Don Guillett SalesAid Software "Loi" wrote in message ... Hi, please show me to remove empty pages. -------------- I selected all cells which are under my needed parts and hit delete or cut, but I didn't work. When I used printview or pagebreak, I still see 14,178 pages. Ex: the worksheet has 100 rows which stored data. I select row from 101 to 8,000 or more and hit delete, but nothing happen. Thank you loi |
#3
|
|||
|
|||
Loi
Select row 101 then SHIFT + END + Downarrow. EditDeleteEntire Row NOW!! IMPORTANT!! SAVE the workbook then close and re-open. Gord Dibben Excel MVP On Wed, 1 Dec 2004 11:17:56 -0800, "Loi" wrote: Hi, please show me to remove empty pages. -------------- I selected all cells which are under my needed parts and hit delete or cut, but I didn't work. When I used printview or pagebreak, I still see 14,178 pages. Ex: the worksheet has 100 rows which stored data. I select row from 101 to 8,000 or more and hit delete, but nothing happen. Thank you loi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Single worksheet, multiple pages? | Excel Discussion (Misc queries) | |||
How do I remove pages in Excel? | Excel Discussion (Misc queries) | |||
How do I delete pages? | Excel Discussion (Misc queries) | |||
combining multiple pages from Web automatically | Excel Discussion (Misc queries) | |||
Limiting the # of pages for Repeat Column Labels | Excel Discussion (Misc queries) |