Excel Question

[BGbootha]

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]

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.

[Mugrila]

I believe you're looking for freeze panes under Window.

[JTWood]

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.

[BGbootha]

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>

[JTWood]

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?

[JTWood]

Or more specifically, what do you want to not move?

[BGbootha]

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

[LiveForever]

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.

[BGbootha]

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.

gee i don't know why i never clicked on the second row to freeze the top row.