Auto Filter on selected row

[johnlovesbeer]

Back again!

After posting a thread regarding sorting issues with multiple columns (under the thread heading "Bulk Sorting" I have conceded that unless I have a sort filter on every column I will not be able to keep data in respective rows when sorting.
My new plan of attack is to insert an empty row (it will be row 13) and apply auto filter across every column (not what I wanted visually but no other option).
Is there a way that I can do this at row 13 on an almost completed sheet? I may just be dumb but I can't stop the filter applying itself to row 1. If I select the whole of row 13 the auto filter or "right click - apply filter" options aren't available.
If not I could start a fresh sheet. Is there a way to copy and paste a large amount of cells with different width columns into a new worksheet?

Cheers,

JLB.

[DonkeyOte]

My new plan of attack is to insert an empty row (it will be row 13) and apply auto filter across every column...

You can't apply a filter to a blank range... insert an x in the first column and another x in the last column - highlight the range from first x to last and apply the filter.
(though not having any headers whatsoever does not make a great deal of sense to me at least...)

Is there a way to copy and paste a large amount of cells with different width columns into a new worksheet?

I'm not sure you need to but you can copy -> paste special -> column widths and repeat for other settings as necessary.

[johnlovesbeer]

Thanks again.

Had to settle for starting a fresh sheet and applying auto filter across the board at row 1 then build my 12 new rows above then paste the data below row 13 from my original sheet to the new sheet.

All Fixed! Maybe not the ideal way to do things but it served my purpose.

Hopefully only 1 or 2 more threads and I will be finished!

Cheers,

JLB.