ExcelBanter - HOW DO I FREEZE THE 1A ROW IN EXCEL

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - HOW DO I FREEZE THE 1A ROW IN EXCEL (https://www.excelbanter.com/excel-discussion-misc-queries/194657-how-do-i-freeze-1a-row-excel.html)

COACHVEEJAY

HOW DO I FREEZE THE 1A ROW IN EXCEL

IM WORKING IN EXCEL AND CAN'T FIGURE HOW TO FREEZE JUST THE 1A ROW THEN THE A
COLUMN PLEASE HELP

Gord Dibben

HOW DO I FREEZE THE 1A ROW IN EXCEL

Select B2 and WindowFreeze Panes.

Gord Dibben MS Excel MVP

On Sat, 12 Jul 2008 15:24:00 -0700, COACHVEEJAY
wrote:

IM WORKING IN EXCEL AND CAN'T FIGURE HOW TO FREEZE JUST THE 1A ROW THEN THE A
COLUMN PLEASE HELP

FSt1

HOW DO I FREEZE THE 1A ROW IN EXCEL

hi
pace the cell pointer at b2.
then on the menu bar.....
windowfreeze panes.
it's boolean. to unfreeze....windowunfreeze panes.

regards
FSt1

"COACHVEEJAY" wrote:

IM WORKING IN EXCEL AND CAN'T FIGURE HOW TO FREEZE JUST THE 1A ROW THEN THE A
COLUMN PLEASE HELP

All times are GMT +1. The time now is 12:21 PM.