Set row header?

D

Don Niall

Hi,
A simple question - cant find the answer!:
How do I set a row header if sorting by column? The search
box always comes out with the row header option
deselected, and 'grey out' so I cant select ....

Thx

Don-
 
E

Earl Kiosterud

Don,

I don't know of a way to get the header option when sorting by column (it
refuses to keep the header at the left even when attempted in VBA), but you
could manually select your table, not including the header. To facilitate
that, you might want to name a range, which you could select quickly with
the Name Box. It isn't as handy, as you must select by row number. If you
do this frequently, you might want to set up a sort macro to do the whole
thing. Post back for details -- supply layout info for your table.
 
Top