How to make first Row inert?

W

wavetoall

I was lucky enough to have some great responses as to how to freeze panes on
the first row so that I could scroll the rest without affecting the header
row (1). After successfully accomplishing that, is there a way to have that
row read as bland so that the first moveble row is row (1)?

Thanks
 
G

Gord Dibben

Wave

No.

You have row 1 with titles and frozen.

It will always remain row 1. You cannot change that.

A visual work-around.........

In A2 enter =ROW()-1

Drag/copy down as far as you wish.

Select B2 and Window>Freeze Panes so your titles and Column A are frozen.

Go to Tools>Options>View and turn off "Row and Column Headers"


Gord Dibben Excel MVP
 
Top