|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
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 <Mary@discussions.microsoft.com> 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
>> Window>Freeze 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 <Alexis@discussions.microsoft.com>
>> 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" <Stephan@discussions.microsoft.com> wrote in message
>> >> news:C02E2C64-4ADD-4AE4-B64F-D5F6AFDAFCE6@microsoft.com...
>> >> > 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" <Tomt39@discussions.microsoft.com> wrote in message
>> >> >> news:B938073F-7BDE-463E-B9F9-B451DE6B3745@microsoft.com...
>> >> >> >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.
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>>
>>
|
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
 Reply |
| |
 |
|
 Top |
|
|
|
|
|
|
|
|
|
| |
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 <Mary@discussions.microsoft.com> 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
> >> Window>Freeze 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 <Alexis@discussions.microsoft.com>
> >> 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" <Stephan@discussions.microsoft.com> wrote in message
> >> >> news:C02E2C64-4ADD-4AE4-B64F-D5F6AFDAFCE6@microsoft.com...
> >> >> > 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" <Tomt39@discussions.microsoft.com> wrote in message
> >> >> >> news:B938073F-7BDE-463E-B9F9-B451DE6B3745@microsoft.com...
> >> >> >> >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.
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >>
> >>
>
> |
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
| |
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 <Mary@discussions.microsoft.com> 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 <Mary@discussions.microsoft.com> 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
>> >> Window>Freeze 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 <Alexis@discussions.microsoft.com>
>> >> 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" <Stephan@discussions.microsoft.com> wrote in message
>> >> >> news:C02E2C64-4ADD-4AE4-B64F-D5F6AFDAFCE6@microsoft.com...
>> >> >> > 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" <Tomt39@discussions.microsoft.com> wrote in message
>> >> >> >> news:B938073F-7BDE-463E-B9F9-B451DE6B3745@microsoft.com...
>> >> >> >> >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.
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>>
>>
|
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
| |
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 <Mary@discussions.microsoft.com> 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 <Mary@discussions.microsoft.com> 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
> >> >> Window>Freeze 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 <Alexis@discussions.microsoft.com>
> >> >> 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" <Stephan@discussions.microsoft.com> wrote in message
> >> >> >> news:C02E2C64-4ADD-4AE4-B64F-D5F6AFDAFCE6@microsoft.com...
> >> >> >> > 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" <Tomt39@discussions.microsoft.com> wrote in message
> >> >> >> >> news:B938073F-7BDE-463E-B9F9-B451DE6B3745@microsoft.com...
> >> >> >> >> >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.
> >> >> >> >>
> >> >> >> >>
> >> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >>
> >>
>
> |
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
| |
There is no setting within Excel that limits the freeze to just a row or column
if you are indeed selecting B2 before Windows>Freeze Panes
Gord
On Sat, 19 Jul 2008 09:13:04 -0700, Mary <Mary@discussions.microsoft.com> 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 <Mary@discussions.microsoft.com> 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 <Mary@discussions.microsoft.com> 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
>> >> >> Window>Freeze 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 <Alexis@discussions.microsoft.com>
>> >> >> 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" <Stephan@discussions.microsoft.com> wrote in message
>> >> >> >> news:C02E2C64-4ADD-4AE4-B64F-D5F6AFDAFCE6@microsoft.com...
>> >> >> >> > 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" <Tomt39@discussions.microsoft.com> wrote in message
>> >> >> >> >> news:B938073F-7BDE-463E-B9F9-B451DE6B3745@microsoft.com...
>> >> >> >> >> >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.
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>>
>>
|
| |
|
| |
Was this post helpful to you? |
|
|
|
|
|
|
|
Reply |
| |
|
|
Top |
|
|
|
|
|
|
|
|
|
|
|
Question
Answer
Notify me of replies