ExcelBanter - Floating Column Names.

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Floating Column Names. (https://www.excelbanter.com/excel-discussion-misc-queries/246145-floating-column-names.html)

Nevyn

Floating Column Names.

Hi folks am after your brains again. I have a sheet with well over 500 rows.
Is there a way to float the column headings so I canh see them at whatever
row I am on.

Bob I

Floating Column Names.

See Freeze Panes in Help.

Nevyn wrote:

Hi folks am after your brains again. I have a sheet with well over 500 rows.
Is there a way to float the column headings so I canh see them at whatever
row I am on.

Column references within formulas[_2_]

Floating Column Names.

Click on the row below your headers, then go to view on the toolbar click
freeze panes.

"Nevyn" wrote:

Hi folks am after your brains again. I have a sheet with well over 500 rows.
Is there a way to float the column headings so I canh see them at whatever
row I am on.

Nevyn

Floating Column Names.

Thank you appreciated oh wise one.

"Column references within formulas" wrote:

Click on the row below your headers, then go to view on the toolbar click
freeze panes.

"Nevyn" wrote:

Hi folks am after your brains again. I have a sheet with well over 500 rows.
Is there a way to float the column headings so I canh see them at whatever
row I am on.

All times are GMT +1. The time now is 07:48 PM.