Results 1 to 3 of 3

Auto Filter on selected row

Threaded View

  1. #1
    Registered User
    Join Date
    09-15-2009
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2007
    Posts
    58

    Auto Filter on selected row

    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.
    Last edited by johnlovesbeer; 12-06-2009 at 05:03 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1