Set row header?

  • Thread starter Thread starter Don Niall
  • Start date Start date
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-
 
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.
 
You must log in or register to reply here.

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

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
writing a sort macro 2
Excel sheet with numbers as column & row headers - How? 3
Header rows 4
Sort confusion 2
Delete Columns/Row not working 6
Change color of row and column worksheet headers 2
Find values across a row and return a text value from the same column 2

Back
Top