ExcelBanter - Roll Under- sideways

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

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Roll Under- sideways (https://www.excelbanter.com/new-users-excel/149350-roll-under-sideways.html)

Zygy[_3_]

Roll Under- sideways

If my headings are in Cols. A & B and the other Cols. ad infinitum contain
the information, is there a way of rolling the information Cols. under the
headings Cols. so that I can use Cols AA, BB ect., ect.?

Mike H

Roll Under- sideways

Hi,

You may mean this. Select Column C then click

Window|Freeze panes.

Mike

"Zygy" wrote:

If my headings are in Cols. A & B and the other Cols. ad infinitum contain
the information, is there a way of rolling the information Cols. under the
headings Cols. so that I can use Cols AA, BB ect., ect.?

Zygy[_3_]

Roll Under- sideways

Hi Mike,

Just what I needed. Many thanks!
"Mike H" wrote in message
...
Hi,

You may mean this. Select Column C then click

Window|Freeze panes.

Mike

"Zygy" wrote:

If my headings are in Cols. A & B and the other Cols. ad infinitum
contain
the information, is there a way of rolling the information Cols. under
the
headings Cols. so that I can use Cols AA, BB ect., ect.?

All times are GMT +1. The time now is 03:13 AM.