ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   To many empty cells (https://www.excelbanter.com/excel-discussion-misc-queries/36389-many-empty-cells.html)

Hendrikkleine

To many empty cells
 
I am creating a website (yes with excel) but for example my data reaches
until row 75 on the first sheet. but in the browser (i saved it as a webpage)
it goes to 400 rows! This is not a huge problem but we have slower computers
in our business network and i think (even though the cells are empty) it even
slows them down (just a tiny bit) when loading the page. My question is, how
can i make sure the blank rows do not appear in the browser?

PLease help.

vijay

Can you tell me the version on MS Excel and at the same time the version of IE?

It works fine on IE 6.0.

Other wise, what you can do is manually select all the blank rows that
appear to be, at the end of the sheet. Then save the webpage and view it in
explorer.

If the problem persists, check for the versions as stated above.
--
vijard


"Hendrikkleine" wrote:

I am creating a website (yes with excel) but for example my data reaches
until row 75 on the first sheet. but in the browser (i saved it as a webpage)
it goes to 400 rows! This is not a huge problem but we have slower computers
in our business network and i think (even though the cells are empty) it even
slows them down (just a tiny bit) when loading the page. My question is, how
can i make sure the blank rows do not appear in the browser?

PLease help.


Dave Peterson

First, I don't create websites.

But if you hit ctrl-end in excel, does the cursor move to that same last cell
that shows in your web page?

If yes...
Debra Dalgleish has some techniques to reset that last used cell if it's way
past what you think it should be.

http://www.contextures.com/xlfaqApp.html#Unused

Hendrikkleine wrote:

I am creating a website (yes with excel) but for example my data reaches
until row 75 on the first sheet. but in the browser (i saved it as a webpage)
it goes to 400 rows! This is not a huge problem but we have slower computers
in our business network and i think (even though the cells are empty) it even
slows them down (just a tiny bit) when loading the page. My question is, how
can i make sure the blank rows do not appear in the browser?

PLease help.


--

Dave Peterson


All times are GMT +1. The time now is 08:51 PM.

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