ExcelBanter - FLOATING CELLS

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - FLOATING CELLS (https://www.excelbanter.com/excel-programming/345746-floating-cells.html)

Hi,

Please can anyone help. I would like to have a part of table that stays in
same position. (floating) I don't want to make split of freeze, I just wan't
to want that part of table is fixed. So when I scroll up/down left part of
table is fixed and that right part is moving.

thanx

You can do that with Windows =freeze panes

select the cell to the right and below the area you want frozen. then do
windows=freeze panes. You can undo it at any time doing Windows=Unfreeze
panes.

--
Regards,
Tom Ogilvy

"zvone" wrote in message
...
Hi,

Please can anyone help. I would like to have a part of table that stays in
same position. (floating) I don't want to make split of freeze, I just
wan't
to want that part of table is fixed. So when I scroll up/down left part of
table is fixed and that right part is moving.

thanx