How do I freeze column names to view when scrolling?
 

Aloha Julie,

I tried to freeze a column and a row and it will only freeze one. I cannot
get them both to freeze. Do you have any suggestions?

Thanks,

Stephan

"JulieD" wrote:

Hi Tom

click in the first cell under your titles (ie A2) choose window / freeze
panes
use window / unfreeze panes to remove

you can also freeze columns & rows at the same time - click underneath & to
the right of what you want to stay "frozen" and then use the window / freeze
panes menu option.

Cheers
JulieD


"Tomt39" wrote in message
...
I have created some large lists on a spreadsheet. I would like the titles
of
the columns to stay in view as I scroll down but cannot find how to do
this.

How do I freeze column names to view when scrolling?
 

Hi Stephan,

Put your cursor where you are wanting the column/row frozen at, then click
window/freeze panes. i.e. if you are wanting the first row to stay there as
well as column A & B, put your cursor in cell C2. That will freeze both the
first row as well as columns A & B from moving.

Hope that helps.
Tami


"Stephan" wrote in message
...
Aloha Julie,

I tried to freeze a column and a row and it will only freeze one. I cannot
get them both to freeze. Do you have any suggestions?

Thanks,

Stephan

"JulieD" wrote:

Hi Tom

click in the first cell under your titles (ie A2) choose window / freeze
panes
use window / unfreeze panes to remove

you can also freeze columns & rows at the same time - click underneath &
to
the right of what you want to stay "frozen" and then use the window /
freeze
panes menu option.

Cheers
JulieD


"Tomt39" wrote in message
...
I have created some large lists on a spreadsheet. I would like the
titles
of
the columns to stay in view as I scroll down but cannot find how to do
this.

How do I freeze column names to view when scrolling?
 

When I try to freeze one row, the 20 rows below it will also freeze. Does
anyone have a solution to allow for just one row to freeze?

Thanks!

"Nelson" wrote:

Hi Stephan,

Put your cursor where you are wanting the column/row frozen at, then click
window/freeze panes. i.e. if you are wanting the first row to stay there as
well as column A & B, put your cursor in cell C2. That will freeze both the
first row as well as columns A & B from moving.

Hope that helps.
Tami


"Stephan" wrote in message
...
Aloha Julie,

I tried to freeze a column and a row and it will only freeze one. I cannot
get them both to freeze. Do you have any suggestions?

Thanks,

Stephan

"JulieD" wrote:

Hi Tom

click in the first cell under your titles (ie A2) choose window / freeze
panes
use window / unfreeze panes to remove

you can also freeze columns & rows at the same time - click underneath &
to
the right of what you want to stay "frozen" and then use the window /
freeze
panes menu option.

Cheers
JulieD


"Tomt39" wrote in message
...
I have created some large lists on a spreadsheet. I would like the
titles
of
the columns to stay in view as I scroll down but cannot find how to do
this.

How do I freeze column names to view when scrolling?
 

Unfreeze the panes for those 20 rows (Window | Unfreeze panes) then
CTRL-Home will take you to cell A1. Put the cursor in A2 and click on Window
| Freeze panes. Now if you scroll down you should see the top row visible at
all times, and CTRL-Home will always take you back to A2.

Hope this helps.

Pete

"Alexis" wrote in message
...
When I try to freeze one row, the 20 rows below it will also freeze. Does
anyone have a solution to allow for just one row to freeze?

Thanks!

How do I freeze column names to view when scrolling?
 

The freezing rule is..................

All rows above and columns left of the selected cell will be frozen under
WindowFreeze Panes.

To freeze row 1 select A2

You cannot freeze a single row in the middle or bottom of your window if that's
what you're wanting.


Gord Dibben MS Excel MVP

On Tue, 8 Jul 2008 08:51:02 -0700, Alexis
wrote:

When I try to freeze one row, the 20 rows below it will also freeze. Does
anyone have a solution to allow for just one row to freeze?

Thanks!

"Nelson" wrote:

Hi Stephan,

Put your cursor where you are wanting the column/row frozen at, then click
window/freeze panes. i.e. if you are wanting the first row to stay there as
well as column A & B, put your cursor in cell C2. That will freeze both the
first row as well as columns A & B from moving.

Hope that helps.
Tami


"Stephan" wrote in message
...
Aloha Julie,

I tried to freeze a column and a row and it will only freeze one. I cannot
get them both to freeze. Do you have any suggestions?

Thanks,

Stephan

"JulieD" wrote:

Hi Tom

click in the first cell under your titles (ie A2) choose window / freeze
panes
use window / unfreeze panes to remove

you can also freeze columns & rows at the same time - click underneath &
to
the right of what you want to stay "frozen" and then use the window /
freeze
panes menu option.

Cheers
JulieD


"Tomt39" wrote in message
...
I have created some large lists on a spreadsheet. I would like the
titles
of
the columns to stay in view as I scroll down but cannot find how to do
this.

How do I freeze column names to view when scrolling?
 

I'm having trouble freezing both the column and the rows. I'm pretty sure
I've seen this done before but it's not working right now.

I click in the correct cell and I can get either the column or the row to
freeze, but not both. I want the column headings (listed in a row) AND the
first column (column A) in the spreadsheet to freeze so that I can scroll
left to right AND up and down in the sheet while still keeping the headings
and first column in place.

Any ideas why this wouldn't be working right now??

-Mary

"Gord Dibben" wrote:

The freezing rule is..................

All rows above and columns left of the selected cell will be frozen under
WindowFreeze Panes.

To freeze row 1 select A2

You cannot freeze a single row in the middle or bottom of your window if that's
what you're wanting.


Gord Dibben MS Excel MVP

On Tue, 8 Jul 2008 08:51:02 -0700, Alexis
wrote:

When I try to freeze one row, the 20 rows below it will also freeze. Does
anyone have a solution to allow for just one row to freeze?

Thanks!

"Nelson" wrote:

Hi Stephan,

Put your cursor where you are wanting the column/row frozen at, then click
window/freeze panes. i.e. if you are wanting the first row to stay there as
well as column A & B, put your cursor in cell C2. That will freeze both the
first row as well as columns A & B from moving.

Hope that helps.
Tami


"Stephan" wrote in message
...
Aloha Julie,

I tried to freeze a column and a row and it will only freeze one. I cannot
get them both to freeze. Do you have any suggestions?

Thanks,

Stephan

"JulieD" wrote:

Hi Tom

click in the first cell under your titles (ie A2) choose window / freeze
panes
use window / unfreeze panes to remove

you can also freeze columns & rows at the same time - click underneath &
to
the right of what you want to stay "frozen" and then use the window /
freeze
panes menu option.

Cheers
JulieD


"Tomt39" wrote in message
...
I have created some large lists on a spreadsheet. I would like the
titles
of
the columns to stay in view as I scroll down but cannot find how to do
this.

How do I freeze column names to view when scrolling?
 

I don't know what you see as the correct cell but B2 would freeze column A and
Row 1

Remember............everything above and left of the selected cell.


Gord Dibben MS Excel MVP


On Fri, 18 Jul 2008 09:49:02 -0700, Mary wrote:

I'm having trouble freezing both the column and the rows. I'm pretty sure
I've seen this done before but it's not working right now.

I click in the correct cell and I can get either the column or the row to
freeze, but not both. I want the column headings (listed in a row) AND the
first column (column A) in the spreadsheet to freeze so that I can scroll
left to right AND up and down in the sheet while still keeping the headings
and first column in place.

Any ideas why this wouldn't be working right now??

-Mary

"Gord Dibben" wrote:

The freezing rule is..................

All rows above and columns left of the selected cell will be frozen under
WindowFreeze Panes.

To freeze row 1 select A2

You cannot freeze a single row in the middle or bottom of your window if that's
what you're wanting.


Gord Dibben MS Excel MVP

On Tue, 8 Jul 2008 08:51:02 -0700, Alexis
wrote:

When I try to freeze one row, the 20 rows below it will also freeze. Does
anyone have a solution to allow for just one row to freeze?

Thanks!

"Nelson" wrote:

Hi Stephan,

Put your cursor where you are wanting the column/row frozen at, then click
window/freeze panes. i.e. if you are wanting the first row to stay there as
well as column A & B, put your cursor in cell C2. That will freeze both the
first row as well as columns A & B from moving.

Hope that helps.
Tami


"Stephan" wrote in message
...
Aloha Julie,

I tried to freeze a column and a row and it will only freeze one. I cannot
get them both to freeze. Do you have any suggestions?

Thanks,

Stephan

"JulieD" wrote:

Hi Tom

click in the first cell under your titles (ie A2) choose window / freeze
panes
use window / unfreeze panes to remove

you can also freeze columns & rows at the same time - click underneath &
to
the right of what you want to stay "frozen" and then use the window /
freeze
panes menu option.

Cheers
JulieD


"Tomt39" wrote in message
...
I have created some large lists on a spreadsheet. I would like the
titles
of
the columns to stay in view as I scroll down but cannot find how to do
this.

How do I freeze column names to view when scrolling?
 

Hi Gord,

Thanks for your reply. Yup, B2 is the cell I'm trying. I know I've done it
before in different spreadsheets, but I don't understand why it's not working
now. Can you think of a setting or something that I might have setup wrong?

Seems weird.......

Thanks!

Mary

"Gord Dibben" wrote:

I don't know what you see as the correct cell but B2 would freeze column A and
Row 1

Remember............everything above and left of the selected cell.


Gord Dibben MS Excel MVP


On Fri, 18 Jul 2008 09:49:02 -0700, Mary wrote:

I'm having trouble freezing both the column and the rows. I'm pretty sure
I've seen this done before but it's not working right now.

I click in the correct cell and I can get either the column or the row to
freeze, but not both. I want the column headings (listed in a row) AND the
first column (column A) in the spreadsheet to freeze so that I can scroll
left to right AND up and down in the sheet while still keeping the headings
and first column in place.

Any ideas why this wouldn't be working right now??

-Mary

"Gord Dibben" wrote:

The freezing rule is..................

All rows above and columns left of the selected cell will be frozen under
WindowFreeze Panes.

To freeze row 1 select A2

You cannot freeze a single row in the middle or bottom of your window if that's
what you're wanting.


Gord Dibben MS Excel MVP

On Tue, 8 Jul 2008 08:51:02 -0700, Alexis
wrote:

When I try to freeze one row, the 20 rows below it will also freeze. Does
anyone have a solution to allow for just one row to freeze?

Thanks!

"Nelson" wrote:

Hi Stephan,

Put your cursor where you are wanting the column/row frozen at, then click
window/freeze panes. i.e. if you are wanting the first row to stay there as
well as column A & B, put your cursor in cell C2. That will freeze both the
first row as well as columns A & B from moving.

Hope that helps.
Tami


"Stephan" wrote in message
...
Aloha Julie,

I tried to freeze a column and a row and it will only freeze one. I cannot
get them both to freeze. Do you have any suggestions?

Thanks,

Stephan

"JulieD" wrote:

Hi Tom

click in the first cell under your titles (ie A2) choose window / freeze
panes
use window / unfreeze panes to remove

you can also freeze columns & rows at the same time - click underneath &
to
the right of what you want to stay "frozen" and then use the window /
freeze
panes menu option.

Cheers
JulieD


"Tomt39" wrote in message
...
I have created some large lists on a spreadsheet. I would like the
titles
of
the columns to stay in view as I scroll down but cannot find how to do
this.

How do I freeze column names to view when scrolling?
 

I can't think of anything that would prevent the freezing of row 1 and column A
in this case.


Gord

On Sat, 19 Jul 2008 03:24:01 -0700, Mary wrote:

Hi Gord,

Thanks for your reply. Yup, B2 is the cell I'm trying. I know I've done it
before in different spreadsheets, but I don't understand why it's not working
now. Can you think of a setting or something that I might have setup wrong?

Seems weird.......

Thanks!

Mary

"Gord Dibben" wrote:

I don't know what you see as the correct cell but B2 would freeze column A and
Row 1

Remember............everything above and left of the selected cell.


Gord Dibben MS Excel MVP


On Fri, 18 Jul 2008 09:49:02 -0700, Mary wrote:

I'm having trouble freezing both the column and the rows. I'm pretty sure
I've seen this done before but it's not working right now.

I click in the correct cell and I can get either the column or the row to
freeze, but not both. I want the column headings (listed in a row) AND the
first column (column A) in the spreadsheet to freeze so that I can scroll
left to right AND up and down in the sheet while still keeping the headings
and first column in place.

Any ideas why this wouldn't be working right now??

-Mary

"Gord Dibben" wrote:

The freezing rule is..................

All rows above and columns left of the selected cell will be frozen under
WindowFreeze Panes.

To freeze row 1 select A2

You cannot freeze a single row in the middle or bottom of your window if that's
what you're wanting.


Gord Dibben MS Excel MVP

On Tue, 8 Jul 2008 08:51:02 -0700, Alexis
wrote:

When I try to freeze one row, the 20 rows below it will also freeze. Does
anyone have a solution to allow for just one row to freeze?

Thanks!

"Nelson" wrote:

Hi Stephan,

Put your cursor where you are wanting the column/row frozen at, then click
window/freeze panes. i.e. if you are wanting the first row to stay there as
well as column A & B, put your cursor in cell C2. That will freeze both the
first row as well as columns A & B from moving.

Hope that helps.
Tami


"Stephan" wrote in message
...
Aloha Julie,

I tried to freeze a column and a row and it will only freeze one. I cannot
get them both to freeze. Do you have any suggestions?

Thanks,

Stephan

"JulieD" wrote:

Hi Tom

click in the first cell under your titles (ie A2) choose window / freeze
panes
use window / unfreeze panes to remove

you can also freeze columns & rows at the same time - click underneath &
to
the right of what you want to stay "frozen" and then use the window /
freeze
panes menu option.

Cheers
JulieD


"Tomt39" wrote in message
...
I have created some large lists on a spreadsheet. I would like the
titles
of
the columns to stay in view as I scroll down but cannot find how to do
this.

How do I freeze column names to view when scrolling?
 

Thanks, Gord. I don't know what the problem is either.

It'll keep only one direction frozen at a time. I'm thinking there must be
some weird setting messed up somewhere. Oh, well, if anyone has any brilliant
ideas, I'd love to hear them.

Thanks!

Mary

"Gord Dibben" wrote:

I can't think of anything that would prevent the freezing of row 1 and column A
in this case.


Gord

On Sat, 19 Jul 2008 03:24:01 -0700, Mary wrote:

Hi Gord,

Thanks for your reply. Yup, B2 is the cell I'm trying. I know I've done it
before in different spreadsheets, but I don't understand why it's not working
now. Can you think of a setting or something that I might have setup wrong?

Seems weird.......

Thanks!

Mary

"Gord Dibben" wrote:

I don't know what you see as the correct cell but B2 would freeze column A and
Row 1

Remember............everything above and left of the selected cell.


Gord Dibben MS Excel MVP


On Fri, 18 Jul 2008 09:49:02 -0700, Mary wrote:

I'm having trouble freezing both the column and the rows. I'm pretty sure
I've seen this done before but it's not working right now.

I click in the correct cell and I can get either the column or the row to
freeze, but not both. I want the column headings (listed in a row) AND the
first column (column A) in the spreadsheet to freeze so that I can scroll
left to right AND up and down in the sheet while still keeping the headings
and first column in place.

Any ideas why this wouldn't be working right now??

-Mary

"Gord Dibben" wrote:

The freezing rule is..................

All rows above and columns left of the selected cell will be frozen under
WindowFreeze Panes.

To freeze row 1 select A2

You cannot freeze a single row in the middle or bottom of your window if that's
what you're wanting.


Gord Dibben MS Excel MVP

On Tue, 8 Jul 2008 08:51:02 -0700, Alexis
wrote:

When I try to freeze one row, the 20 rows below it will also freeze. Does
anyone have a solution to allow for just one row to freeze?

Thanks!

"Nelson" wrote:

Hi Stephan,

Put your cursor where you are wanting the column/row frozen at, then click
window/freeze panes. i.e. if you are wanting the first row to stay there as
well as column A & B, put your cursor in cell C2. That will freeze both the
first row as well as columns A & B from moving.

Hope that helps.
Tami


"Stephan" wrote in message
...
Aloha Julie,

I tried to freeze a column and a row and it will only freeze one. I cannot
get them both to freeze. Do you have any suggestions?

Thanks,

Stephan

"JulieD" wrote:

Hi Tom

click in the first cell under your titles (ie A2) choose window / freeze
panes
use window / unfreeze panes to remove

you can also freeze columns & rows at the same time - click underneath &
to
the right of what you want to stay "frozen" and then use the window /
freeze
panes menu option.

Cheers
JulieD


"Tomt39" wrote in message
...
I have created some large lists on a spreadsheet. I would like the
titles
of
the columns to stay in view as I scroll down but cannot find how to do
this.

How do I freeze column names to view when scrolling?
 

There is no setting within Excel that limits the freeze to just a row or column
if you are indeed selecting B2 before WindowsFreeze Panes


Gord

On Sat, 19 Jul 2008 09:13:04 -0700, Mary wrote:

Thanks, Gord. I don't know what the problem is either.

It'll keep only one direction frozen at a time. I'm thinking there must be
some weird setting messed up somewhere. Oh, well, if anyone has any brilliant
ideas, I'd love to hear them.

Thanks!

Mary

"Gord Dibben" wrote:

I can't think of anything that would prevent the freezing of row 1 and column A
in this case.


Gord

On Sat, 19 Jul 2008 03:24:01 -0700, Mary wrote:

Hi Gord,

Thanks for your reply. Yup, B2 is the cell I'm trying. I know I've done it
before in different spreadsheets, but I don't understand why it's not working
now. Can you think of a setting or something that I might have setup wrong?

Seems weird.......

Thanks!

Mary

"Gord Dibben" wrote:

I don't know what you see as the correct cell but B2 would freeze column A and
Row 1

Remember............everything above and left of the selected cell.


Gord Dibben MS Excel MVP


On Fri, 18 Jul 2008 09:49:02 -0700, Mary wrote:

I'm having trouble freezing both the column and the rows. I'm pretty sure
I've seen this done before but it's not working right now.

I click in the correct cell and I can get either the column or the row to
freeze, but not both. I want the column headings (listed in a row) AND the
first column (column A) in the spreadsheet to freeze so that I can scroll
left to right AND up and down in the sheet while still keeping the headings
and first column in place.

Any ideas why this wouldn't be working right now??

-Mary

"Gord Dibben" wrote:

The freezing rule is..................

All rows above and columns left of the selected cell will be frozen under
WindowFreeze Panes.

To freeze row 1 select A2

You cannot freeze a single row in the middle or bottom of your window if that's
what you're wanting.


Gord Dibben MS Excel MVP

On Tue, 8 Jul 2008 08:51:02 -0700, Alexis
wrote:

When I try to freeze one row, the 20 rows below it will also freeze. Does
anyone have a solution to allow for just one row to freeze?

Thanks!

"Nelson" wrote:

Hi Stephan,

Put your cursor where you are wanting the column/row frozen at, then click
window/freeze panes. i.e. if you are wanting the first row to stay there as
well as column A & B, put your cursor in cell C2. That will freeze both the
first row as well as columns A & B from moving.

Hope that helps.
Tami


"Stephan" wrote in message
...
Aloha Julie,

I tried to freeze a column and a row and it will only freeze one. I cannot
get them both to freeze. Do you have any suggestions?

Thanks,

Stephan

"JulieD" wrote:

Hi Tom

click in the first cell under your titles (ie A2) choose window / freeze
panes
use window / unfreeze panes to remove

you can also freeze columns & rows at the same time - click underneath &
to
the right of what you want to stay "frozen" and then use the window /
freeze
panes menu option.

Cheers
JulieD


"Tomt39" wrote in message
...
I have created some large lists on a spreadsheet. I would like the
titles
of
the columns to stay in view as I scroll down but cannot find how to do
this.