Excel – Freezing top row while sorting in Excel

microsoft excelmicrosoft-excel-2010

The first column in my spreadsheet has "Last name" in the top row, which is frozen, and last names below it. I am trying to order the rows by the last name, alphabetically. How can I make Excel keep the first row on top?
It always puts "Last name" together with other names starting with "L".

Best Answer

Click the "Sort & Filter" button in the "Editing" section under the "Home" tab.
Choose "Custom Sort."
Check "My data has headers," then customize your sort parameters.

Related Solutions

Excel – How to get multi-row sort/filtering headers in excel

No. Omit the first row from your range when you auto filter. This way the auto filter buttons appear only on your bottom header row and the data gets filtered. I expect that right now your second header row is getting pulled into your 'data'.

You can't select a single cell and have excel figure this out. You have to select the range of cells you want excel to include.

Excel – How to Consistently Insert Rows from Top of Page

Yes sir. You can indeed. All you need to do is to record a macro in excel that will do this job for you and paste the data to the first row.

Copy the data you want to paste and start a macro. you can assign a macro to the custom button on the ribbon. this way it will only be single left mouse button click.

Macro should look similiar to this:

Rows("1:1").Select
Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
Range("A1").Select
ActiveSheet.Paste

You will find a tips on how to use buttons in excel here: click And here is a guide to add it to the quick access toolbar : click

Best Answer

Related Solutions

Excel – How to get multi-row sort/filtering headers in excel

Excel – How to Consistently Insert Rows from Top of Page

Related Question