|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 4th, 2010, 07:54 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to freeze one column vertically, one horizontal in same sprdsh
Is it possible to freeze a column vertically and one horizontally in the same
spreadsheet? 
|
|
#2
May 4th, 2010, 08:00 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to freeze one column vertically, one horizontal in same sprdsh
Do you mean other than Row 1 and Column 1? If that is what you meant, then
the answer is "no". -- Rick (MVP - Excel) "sweaver" wrote in message ... Is it possible to freeze a column vertically and one horizontally in the same spreadsheet?
|
|
#3
May 4th, 2010, 11:08 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to freeze one column vertically, one horizontal in same sprdsh
What cell is below the row you want frozen and to the right of the column you
want frozen. Find that intersection cell and place your cursor in it. Then go to Windows, Freeze Panes. "sweaver" wrote: Is it possible to freeze a column vertically and one horizontally in the same spreadsheet?
|
|
#4
May 5th, 2010, 07:38 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to freeze one column vertically, one horizontal in same sprdsh
On 5/4/2010 3:08 PM, Nadine wrote:
What cell is below the row you want frozen and to the right of the column you want frozen. Find that intersection cell and place your cursor in it. Then go to Windows, Freeze Panes. "sweaver" wrote: Is it possible to freeze a column vertically and one horizontally in the same spreadsheet? This approach will freeze ALL the rows above and ALL the columns to the left of the selected cell, not just one row and column. Bill
|
|
#5
May 5th, 2010, 08:47 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to freeze one column vertically, one horizontal in same sp
That was what I took her question to mean she wanted. Sorry if she didn't
want this. "Billns" wrote: On 5/4/2010 3:08 PM, Nadine wrote: What cell is below the row you want frozen and to the right of the column you want frozen. Find that intersection cell and place your cursor in it. Then go to Windows, Freeze Panes. "sweaver" wrote: Is it possible to freeze a column vertically and one horizontally in the same spreadsheet? This approach will freeze ALL the rows above and ALL the columns to the left of the selected cell, not just one row and column. Bill .
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
