Excel Question - Fantasy Baseball Cafe 2014 Fantasy Baseball Cafe
100% Deposit Bonus for Cafe Members!

Return to General Talk

Excel Question

Moderator: Baseball Moderators

Excel Question

Postby BGbootha » Wed Apr 11, 2007 10:42 pm

I know i have done it before, but how do you set certain rows so that when you scroll down they don't disappear up.

Like for stat titles, while you scroll through players I want the titles to still be visible.

Thanks.
BGbootha
General Manager
General Manager

User avatar
Cafeholic
Posts: 2825
Joined: 18 Feb 2003
Home Cafe: Football
Location: Grading papers

Postby BGbootha » Wed Apr 11, 2007 10:50 pm

Also, does anyone have any ideas for figuring out possible auction value...for instance given

fantasy points total, # of roster spots, # of teams, # of starter at each position, budget

what would be a good formula for calculating a rough idea of a auction value.

thanks.
BGbootha
General Manager
General Manager

User avatar
Cafeholic
Posts: 2825
Joined: 18 Feb 2003
Home Cafe: Football
Location: Grading papers

Postby Mugrila » Wed Apr 11, 2007 10:59 pm

I believe you're looking for freeze panes under Window.
Mugrila
Hall of Fame Hero
Hall of Fame Hero

User avatar
CafeholicFantasy ExpertCafe WriterCafe RankerMock(ing) DrafterEagle EyeCafe MusketeerPick 3 Champion
Posts: 6597
Joined: 4 Jun 2003
Home Cafe: Baseball

Postby JTWood » Wed Apr 11, 2007 11:23 pm

You can freeze windows by selecting a row, column, or cell. If you select a row or column, it will freeze everything to above or to the left (respectively) of where you selected. If you pick a cell, it will do both.

You can also split the page, if you like. It basically gives you two spreadsheets over each other. This is generally useful for comparing two distant parts of a spreadsheet, so it might work for what you want, too.

Both commands are located under the Window menu. ;-D
Image
JTWood
Hall of Fame Hero
Hall of Fame Hero

User avatar
CafeholicCafe WriterEagle EyeWeb Supporter
Posts: 11508
Joined: 22 Jun 2004
Home Cafe: Baseball
Location: Unincorporated Heaven

Postby BGbootha » Thu Apr 12, 2007 12:22 am

OK, that works but it freezes the first 17 lines, I cannot figure out how to make it only freeze the rows I want it to. <img src=/forums/images/smiles/kiss.gif>
BGbootha
General Manager
General Manager

User avatar
Cafeholic
Posts: 2825
Joined: 18 Feb 2003
Home Cafe: Football
Location: Grading papers

Postby JTWood » Thu Apr 12, 2007 12:24 am

BGbootha wrote:OK, that works but it freezes the first 17 lines, I cannot figure out how to make it only freeze the rows I want it to. <img src=/forums/images/smiles/kiss.gif>

What cells/rows/column had you selected when you froze the page?
Image
JTWood
Hall of Fame Hero
Hall of Fame Hero

User avatar
CafeholicCafe WriterEagle EyeWeb Supporter
Posts: 11508
Joined: 22 Jun 2004
Home Cafe: Baseball
Location: Unincorporated Heaven

Postby JTWood » Thu Apr 12, 2007 12:25 am

Or more specifically, what do you want to not move?
Image
JTWood
Hall of Fame Hero
Hall of Fame Hero

User avatar
CafeholicCafe WriterEagle EyeWeb Supporter
Posts: 11508
Joined: 22 Jun 2004
Home Cafe: Baseball
Location: Unincorporated Heaven

Postby BGbootha » Thu Apr 12, 2007 12:48 am

i just want row 1 to be frozen, i have tried to select just the first row and it still freezes the first 17 rows
BGbootha
General Manager
General Manager

User avatar
Cafeholic
Posts: 2825
Joined: 18 Feb 2003
Home Cafe: Football
Location: Grading papers

Postby LiveForever » Thu Apr 12, 2007 12:59 am

If you want the very top row to be frozen then highlight the second row by clicking on the "2" on the left side of the program (an arrow should appear when the curser is over the "2"). Then click the freeze panel button under window.
"If you look long enough for an argument against reason, you will find it" ~Moneyball

There is a very fine line between "hobby" and "mental illness
LiveForever
Minor League Mentor
Minor League Mentor

User avatar

Posts: 643
Joined: 15 Jan 2006
Home Cafe: Baseball
Location: Minneapolis

Postby BGbootha » Thu Apr 12, 2007 6:46 pm

LiveForever wrote:If you want the very top row to be frozen then highlight the second row by clicking on the "2" on the left side of the program (an arrow should appear when the curser is over the "2"). Then click the freeze panel button under window.


;-D ;-D ;-D ;-D ;-D ;-D ;-D ;-D ;-D ;-D ;-D ;-D ;-D ;-D

gee i don't know why i never clicked on the second row to freeze the top row. :-?
BGbootha
General Manager
General Manager

User avatar
Cafeholic
Posts: 2825
Joined: 18 Feb 2003
Home Cafe: Football
Location: Grading papers

Next

Return to General Talk

Who is online

Users browsing this forum: No registered users and 6 guests

Forums Articles & Tips Sleepers Rankings Leagues


Today's Games
Sunday, Oct. 26
(All times are EST, weather icons show forecast for game time)

Kansas City at San Francisco
(8:07 pm)

  • Fantasy Baseball
  • Article Submissions
  • Privacy Statement
  • Site Survey 
  • Contact