May 21, 2013, 05:10:14 PM
Welcome,
Guest
. Please
login
or
register
.
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
News
:
Home
Help
Search
Calendar
Login
Register
Gaming Trend Forums
>
Non-Gaming
>
Hardware / Software Hell
(Moderators:
farley2k
,
naednek
) >
Need some Excel help
Pages: [
1
]
Go Down
« previous
next »
Print
Author
Topic: Need some Excel help (Read 1240 times)
0 Members and 1 Guest are viewing this topic.
whiteboyskim
Senior Staff Writer
Gaming Trend Senior Member
Offline
Posts: 7839
Hard partier
Need some Excel help
«
on:
October 20, 2004, 03:42:49 PM »
Hey gang, I've got a question for you on Excel. How do you set it so that some rows (for example, the top two horizontal rows) are not only locked in place, but that when you scroll down the spreadsheet, those two rows remain frozen in place so when you scroll down, all the rows disappear underneath rows 1 and 2? Thoughts? Comments? Need more info?
I'm also using Office XP if that helps.
Logged
Behold the glory of my new blog!
Filmmaking is vision plus faith plus balls, all 3 of which Hollywood knows little about.
Jeff
Special Project Group
Gaming Trend Senior Member
Offline
Posts: 3281
Need some Excel help
«
Reply #1 on:
October 20, 2004, 03:50:46 PM »
Not to be a smartypants or anything, but ...
open Excel help, and in the answer wizard, type in 'freeze row', and the first result there will explain how to freeze the panes. Not sure if you can do 2 rows or not though.
Logged
whiteboyskim
Senior Staff Writer
Gaming Trend Senior Member
Offline
Posts: 7839
Hard partier
Need some Excel help
«
Reply #2 on:
October 20, 2004, 04:15:57 PM »
Well you're not being a smart-ass, I was using the wrong word. I was using "lock pane" instead of "freeze pane" so that clears that up.
Logged
Behold the glory of my new blog!
Filmmaking is vision plus faith plus balls, all 3 of which Hollywood knows little about.
Pages: [
1
]
Go Up
Print
« previous
next »
Jump to:
Please select a destination:
-----------------------------
Gaming
-----------------------------
=> Console / PC Gaming
=> Portable Gaming & Apps
=> Analog Gaming
=> Multiplayer Madness (MMO or otherwise)
-----------------------------
Non-Gaming
-----------------------------
=> Off-Topic
=> Political / Religious Nonsense
=> Hardware / Software Hell
=> Steals and Deals
=> Trading Forum
=> Forum and Site Feedback
Loading...