freezing columns and rows

[jefe]

Is it possible to write a macro to have the farthest
column to the right frozen on the right side of the
display (like a split screen) and the bottom row to do the
same?

I have totals on the right and bottom of the sheet that I
would like to keep visible even as the user scrolls
up/down or left /right.

How would that be done?

TIA

 

[Frank Kabel]

Hi
for freezing the first row simply go to cell A2 and than to 'Windows -
Feeze Panes'.
You can also freeze the LEFT site of your sheet though doing this for
the right site is not possible. You may try moving your cursor in row
2/last column-1 and invoke the freezing

 

[David McRitchie]

Hi Jefe,
No you can't freeze the last column, besides there might be some
conflicting view on what the last column is -- so perhaps the last
used column as opposed to column IV (256th column)..

What you can do is use split instead of freeze.
You can move the demarcation for the split as you see fit, but
part to the right of the split would be your "last column" as you
might have for a balance column. You cannot use both freeze
and split at the same time as they are mutually exclusive.

Another option might be to hide columns.