How to freeze one column vertically, one horizontal in same sprdsh

S

sweaver

Is it possible to freeze a column vertically and one horizontally in the same
spreadsheet?
 
R

Rick Rothstein

Do you mean other than Row 1 and Column 1? If that is what you meant, then
the answer is "no".
 
N

Nadine

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.
 
B

Billns

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.
Click to expand...

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
 
N

Nadine

That was what I took her question to mean she wanted. Sorry if she didn't
want this.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel autosum problem in Excel 1
PowerPoint Freeze animation 1
Can I freeze BOTH a column and a row in the same spreadsheet? 1
Vertical Database to Horizontal? 4
copying formula for horizontal data to vertical in different sheet 11
freeze column and row on same spread sheet 2
How do you could center your spredsheet horizontally on the page? 2
ExcelFreezePanes shoud work horizontially and vertically together 2

Top