ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to freeze rows (https://www.excelbanter.com/excel-discussion-misc-queries/114452-how-freeze-rows.html)

Lucia Sanchez

how to freeze rows
 
How do I freeze rows 1 -3 and column A.

RagDyeR

how to freeze rows
 
First,
<Ctrl <Home,
Then, click in B4, then,
<Window <Freeze Panes
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Lucia Sanchez" <Lucia wrote in message
...
How do I freeze rows 1 -3 and column A.



Gord Dibben

how to freeze rows
 
Select B4 and WindowFreeze Panes.

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

Anything above and left of the selected cell will be frozen.


Gord Dibben MS Excel MVP

On Sat, 14 Oct 2006 14:40:02 -0700, Lucia Sanchez <Lucia
wrote:

How do I freeze rows 1 -3 and column A.




All times are GMT +1. The time now is 02:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com