ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Extra pages (https://www.excelbanter.com/new-users-excel/4560-extra-pages.html)

Loi

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

Don Guillett

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




Gord Dibben

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




All times are GMT +1. The time now is 09:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com