Consulting

Results 1 to 3 of 3

Thread: Header rows

  1. #1

    Header rows

    In Excel I have two header rows. I have done a freeze for both. If I click in the
    little square to the left of column A and then do a sort and select Header row the second header row want to move. How can I keep as many header rows as
    I need?
    Max

  2. #2
    MS Excel MVP VBAX Regular
    Joined
    May 2004
    Posts
    30
    Location
    Don't select all cells. Instead, select from row 2 and below. You can do this.

    Select A2.

    Press and hold the Control and Shift keys
    Press the right arrow
    Press the down arrow

    Now do your sort.
    Regards,

    Juan Pablo Gonz?lez

  3. #3
    Thanks that work just fine

    Max

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •