Thank you for the help. I would like to freeze themone column at a time. I
know how to freeze the first column, but I'd like to know how to freeze
others columns one column at a time.
"Rick Rothstein (MVP -
VB)" wrote:
Your question is not clear to me. Are you asking if you can freeze more than
one column starting with column 1; for example columns 1 through 4? Or are
you asking if you can freeze multiple columns starting with a column number
other than 1; for example columns 4 through 7? Let's answer the last
question first... the answer is no (think about it... what would the screen
look like around the frozen columns as the columns were scrolled... columns
after the frozen columns would be shown to the left of the frozen ones?). As
for the first question, select the first cell you want to still be able to
scroll (both horizontally and vertically) and click Window/Freeze Panes from
the menu bar. The columns to the left and above that cell will be frozen.
Rick
"ManhattanRebel" wrote in message
...
Other than the first column, is there a way to freeze other columns in my
excel spread sheet?