Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help me! There is problem with cells view... | Excel Discussion (Misc queries) | |||
how do populate empty cells with the contents of populated cells . | Excel Discussion (Misc queries) | |||
Macro to copy value in empty cells | Excel Discussion (Misc queries) | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
copy group of cells to another group of cells using "IF" in third | Excel Worksheet Functions |