text to colems

  • Thread starter Sparky AKA_Sparkticus
  • Start date
S

Sparky AKA_Sparkticus

i have a sheet with data i want to sort, i can lock the top row as an header
and select the columns i wish to sort without the header changing but is
there a way so that if you select the whole worksheet it still locks the
column header i have on row 1

sparky
 

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

writing a sort macro 2
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
Top row of excel stays even in sorting 1
sorting columns sorts header values too 6
Header in row to column 1
Sort confusion 2
Macro to sort - Issue 4
Excel "remembering" sort criteria 3

Top