Link to home
Create AccountLog in
Avatar of Mark
Mark

asked on

How to freeze pane on broswer downloaded spreadsheet

I have an annoying problem. When I download a CSV file from my IE browser, it opens in my Excel 2003 fine, but the menu bar is missing 'Window' and has 'Go to' and 'Favorites' instead.  I could care less about having 'Go to' and 'Favorites' (I find those of zero use on a spreadsheet), but I really miss not having 'Window' selection. Normally, I want to download a spreadsheet and scroll down to examine some particular value. I have to try to remember the column headers because those scroll off the screen. I believe the same phenomenon occurs if using Excel 2010. It would really be nice if I could freeze the header row and then scroll. Surely there is a way to do this?
Avatar of jsdray
jsdray
Flag of United States of America image

try saving it as an excel spreadsheet then reopen.  There is an option  to freeze the header row and there is also a split screen option you may find helpful in excel.
i'm still using 2007 but I think it's the same.  Got to view... freeze panes.... freeze top row
Avatar of Mark
Mark

ASKER

jsdray: yes, I know that feature is available when opening a regular spreadsheet using Excel directly. I don't want to save the brower-opened version, then re-open it with Excel. I'm looking for a way to avoid the whole download, save, re-open, close, delete process.

You are right, that feature is available under 'View' for Excel 2007 and 2010 when opening from a browser, but not from the 'view' selection in 2003 :(

Is 'freeze' possibly hiding somewhere else? Microsoft gives me quite a lot of largely useless features in this brower view, but the one feature that is used in almost any spreadsheet of more than 50 columns is missing? Seems crazy.
http://spreadsheets.about.com/od/exceltools/ss/81027freezepane.htm

This shows how to do it in 2003... not sure if it helps with the way you are viewing...
Avatar of Mark

ASKER

Thanks for the response. Perhaps I am not being clear enough about the problem. I know how to freeze a pane when opening a spreadsheet from Excel. This problem occurs when clicking on an Excel or CSV link in Internet Explorer. The 'Windows' menu (which is where the 'Freeze' option is located) is not visible. So, all the instructions on "choose Window > Freeze Panes from the menu" do me no good. I need to know how to either get the 'Window' menu on the browser downloaded Excel, or if there is some other way (control keys?, a different menu? ...) to freeze the pane when opening spreadsheets from the Internet browser.

Excel from browser (no Window menu)

User generated image
Opening Excel locally. Note circled Window menu - this is where the 'freeze' option is.

User generated image
ASKER CERTIFIED SOLUTION
Avatar of jsdray
jsdray
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Mark

ASKER

Here's the story ... your link appeared a bit dated at first. It made reference to WINNT, WIN2000 and SBS2003, but no OS more recent and I saw no actual dates. Furthermore, the instructions in Method 1 on using the folder options tool were clearly outdated. It referenced the 'Tools' or 'View' menu on 'My Computer'. It was called 'My Computer' in XP. WIN7 just calls it 'Computer'. And, there is no 'Tools' or 'View' menu in WIN7 Computer (at least not on mine). There is, however, a 'default programs'  selection on the Start Orb, so I checked that. Unfortunately, I found that .csv files were already associated with Excel, so your link's method 1 was a dead end for WIN7 users.

Next, I tried Method 2: Edit the Windows Registry. The solution here was to add a DWORD named BrowserFlags to subkey HKEY_LOCAL_MACHINE\SOFTWARE\Excel.Sheet.8 with a value of 8.

Well whatdayaknow! That WORKED! I can now open a spreadsheet link from my browser and I have the 'Windows > Freeze Pane' selection!!! Thanks a bunch! This was a lot more work than I thought it would be. I wonder why this setting isn't the default in Windows? ...

If anyone else comes across this solution, keep in mind that subkey Excel.Sheet.8 is for Excel 97-2003. Subkey Excel.Sheet.12 is for Excel 2007-2010, etc., so check out the actual link referenced in ID: 38885918 for the correct subkey and DWORD value, there are lots including ones for Word, PowerPoint ,etc.