#1   Report Post  
Hendrikkleine
 
Posts: n/a
Default 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.
  #2   Report Post  
vijay
 
Posts: n/a
Default

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.

  #3   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help me! There is problem with cells view... :-) Excel Discussion (Misc queries) 1 April 28th 05 01:16 PM
how do populate empty cells with the contents of populated cells . Jim99 Excel Discussion (Misc queries) 6 April 21st 05 05:44 PM
Macro to copy value in empty cells Esrei Excel Discussion (Misc queries) 3 April 19th 05 03:54 PM
Heps to design Locked/Unlocked cells in protected worksheet Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:09 AM
copy group of cells to another group of cells using "IF" in third Chuckak Excel Worksheet Functions 2 November 10th 04 06:04 PM


All times are GMT +1. The time now is 11:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"