"freeze pane" effect

B

BandHPhoto

I've received several excel spreadsheets I need to convert to html and post on
our intranet. Some have the top row (or rows) fixed so when scrolling, the
column headers remain visible.

How can I retain this fixed-header feature when converting to html?

TIA
- Henry
 
T

Thomas A. Rowe

You can't as that is function of the Excel application. You would have to leave the file in Excel
format and have the user's download it, etc.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
R

Rich Osborne

What if .....

You used frames or iframes to set up the page. Save the header rows as a
separate file and save the rest in the area below it. Wouldn't that simulate
the effect?

Rich
 
T

Thomas A. Rowe

1. Yes it would simulate the effect to a minor degree, as the it is very difficult to have a page in
one frame line up with the frame in the bottom cell, so the columns would be misaligned.

2. If the spreadsheet is more than 600 pixels wide, then you will need to have a horizontal
scrollbar in top frame which then have to manual aligned with the content in the bottom frame.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
Top