Overclock.net - Overclocking.net
     
 
Home Gallery Reviews Blogs Register Today's Posts Mark Forums Read Members List


Go Back   Overclock.net - Overclocking.net > Software, Programming and Coding > Coding and Programming > Web Coding

Reply
 
LinkBack Thread Tools
Old 11-21-09   #1 (permalink)
GAME ON
 
N2Gaming's Avatar
 
amd nvidia

Join Date: Sep 2008
Location: N. Central Valley, Cali
Posts: 6,268
Blog Entries: 2

Rep: 274 N2Gaming is a proven memberN2Gaming is a proven memberN2Gaming is a proven member
Unique Rep: 164
Trader Rating: 5
Question How do I Freez the top pane in google Spreadsheets?

Hi guys. I am working on a google Spreadsheet for a club I manage club M2N found in my sig.

I am having a hard time trying to figure out how to freez the top pane of the spreadsheet so that when users scroll to see what's at the bottom of the spreadsheet the top pane stays visible. I am able to freez the pane in the sheet that I work on but not once it is posted to a web page.

I'm also gonna try to set it up so other club members can edit the information when ever they make changes to there system i.e. cpu and overclocks. This will make it so new members surfing the club thread could add themselfs to the club in the event I loose internet connections or go away on vacations. I know there has got to be some Web Page savy users here. Please help out a fellow OCNer I put my google spreadsheet that I am working on so you will have an idea of what I'm trying to do.

Thank you.

Google Spreadsheet
__________________
Quote:
Originally Posted by Spikemaul View Post
This is the best place on the net. Thanks OCN for giving me my balls back.

System: Black N Blue Baby
CPU
Ph II X4 940 BE @ 3.55GHz
Motherboard
Foxconn Destroyer 3Way SLI + PhysXable
Memory
8GB Corsair XMS2 4x2G TWIN2X4096-8500C5
Graphics Card
2x BFG 9800GT OC 512mb sli'd
Hard Drive
WD SATA 500GB 16mb-Cache
Sound Card
Onboard Realteck
Power Supply
TT Toughpower 700w W0105RU
Case
Mod'd Antec Nine Hundred
CPU cooling
Mod'd Zalman CNPS 9700 NT
GPU cooling
OEM
OS
XP Pro x64 SP2 / Win7 Ult X64
Monitor
Samsung 1080P 40" LCD TV
N2Gaming is offline Overclocked Account N2Gaming's Gallery   Reply With Quote
Old 11-23-09   #2 (permalink)
PC Gamer
 
[)r@ke's Avatar
 
amd nvidia

Join Date: Sep 2006
Location: Indiana
Posts: 263

Rep: 36 [)r@ke is acknowledged by some
Unique Rep: 33
Trader Rating: 0
Default

Two ways: either use the sort bar (grey, striped "handle" on the right, between rows) to separate frozen (above the bar) vs "active" cells (below the bar).

Or, use Tools -> Freeze Rows / Columns and select from there...


Google is usually pretty good at posting this stuff in the Docs Help section... Follow the link for pics and more on your help subject!
__________________
Yeah, I know my system specs are empty...
That's cuz my system specs are going to change (hopefully) by the end of the month.

Avatar: quote © Family Guy; Pintsize image © Jeph Jacques

System: My System
CPU
Athlon 64 X2 4400+ (939)
[)r@ke is offline   Reply With Quote
Old 11-24-09   #3 (permalink)
GAME ON
 
N2Gaming's Avatar
 
amd nvidia

Join Date: Sep 2008
Location: N. Central Valley, Cali
Posts: 6,268
Blog Entries: 2

Rep: 274 N2Gaming is a proven memberN2Gaming is a proven memberN2Gaming is a proven member
Unique Rep: 164
Trader Rating: 5
Default

Thank you [)r@ke.
__________________
Quote:
Originally Posted by Spikemaul View Post
This is the best place on the net. Thanks OCN for giving me my balls back.

System: Black N Blue Baby
CPU
Ph II X4 940 BE @ 3.55GHz
Motherboard
Foxconn Destroyer 3Way SLI + PhysXable
Memory
8GB Corsair XMS2 4x2G TWIN2X4096-8500C5
Graphics Card
2x BFG 9800GT OC 512mb sli'd
Hard Drive
WD SATA 500GB 16mb-Cache
Sound Card
Onboard Realteck
Power Supply
TT Toughpower 700w W0105RU
Case
Mod'd Antec Nine Hundred
CPU cooling
Mod'd Zalman CNPS 9700 NT
GPU cooling
OEM
OS
XP Pro x64 SP2 / Win7 Ult X64
Monitor
Samsung 1080P 40" LCD TV
N2Gaming is offline Overclocked Account N2Gaming's Gallery   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools



All times are GMT -5. The time now is 12:56 AM.


Overclock.net is a Carbon Neutral Site Creative Commons License

Terms of Service / Forum Rules | Privacy Policy | DMCA Info | Advertising | Become an Official Vendor
Copyright © 2010 Shogun Interactive Development. Most rights reserved.
Page generated in 0.12520 seconds with 9 queries