basic website question

Xalten

New Member
Joined
Oct 10, 2002
Messages
6
Hi, sorry for asking such a easy question, I tried to search for the answer on the boards but all I could find were a ton of questions alot more in depth than mine. Anyhow, I have a excel sheet and basically all I want to do is put it on a web page. I use the "Save as Web Page" but that dosnt keep my frozen cells i have. If I add interactivity it puts it in a small box and allows other people to edit it.. thats not what I want, I just want people to be able to view it and I want the frozen columns and rows to remain frozen. Can anyone help please? thanks.
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

ChrisUK

Well-known Member
Joined
Sep 3, 2002
Messages
675
Make a image of your screen by using the print screen key and pasting it in paint, you can now crop the image to suit. Save as jpg or gif.

On your webpage use the image tag as such:

<img src=myfile.jpg>

Hope this helps

Chris
 

Xalten

New Member
Joined
Oct 10, 2002
Messages
6
i cant do that.. thats basically what the Save as Web Page does.. it is to big to do that and they have to scroll over.. when they scroll over i want their names to stay in one place so its easier to determine what line they are on I can post the basic web page sheet if you want to see what i mean?
 

Von Pookie

MrExcel MVP
Joined
Feb 17, 2002
Messages
13,686
Actually, what Chris proposed was simply making a picture of your screen. Nothing like what "save as web page" does. As it is just a picture, nothing would move.
 

Xalten

New Member
Joined
Oct 10, 2002
Messages
6

ADVERTISEMENT

yea i understand that, but the reason i cant is because it is to big to fit on one page hence i have a frozen A column so when you scroll over you can still keep in line the peoples names with the information in the rest of the excel sheet.
 

Von Pookie

MrExcel MVP
Joined
Feb 17, 2002
Messages
13,686

ADVERTISEMENT

Well, how many columns do you have? If it's not too big, maybe if you set the zoom so that all of the columns show but are still legible and then do the print screen?

Just a thought
shrug.gif
 

Xalten

New Member
Joined
Oct 10, 2002
Messages
6
It will wind up having multiple columns for each day of the month, I have already determined that it will not be possible to take still shots. Does anyone know how to put it on a web page and maintain the Freeze Pains? there must be a way somehow
 

ChrisUK

Well-known Member
Joined
Sep 3, 2002
Messages
675
There is another way round this, you could add an excel object and load your sheet into it. This would mean your host would need to support ASP and there would be some tricky programming behind it.

OR

I don't know if you could take a large image of the screen data and a small image of the names, put them together into two HTML frames and let these handle the scrolling - very messy.

The first method is the best but it's very complex I think, take a look at some ASP sites (www.asp101.co or http://www.aspin.com)

Chris
 

attc

Board Regular
Joined
Oct 11, 2002
Messages
87
if you protect your sheet before saving as a web page, will that do the trick?
 

Watch MrExcel Video

Forum statistics

Threads
1,123,158
Messages
5,600,054
Members
414,357
Latest member
Gemma_R

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top