+ Reply to Thread
Results 1 to 3 of 3

Locking rows together while filtering

  1. #1
    Registered User
    Join Date
    09-10-2016
    Location
    UK
    MS-Off Ver
    365
    Posts
    2

    Locking rows together while filtering

    Hi! New to the forum, let me know if I done goofed in any way!

    I'm currently making a spreadsheet for work to track deliveries and returns, the number one priority is that it's simple and easy to use, so I'm adding filters to help people find the item they're trying to add information to. My problem is that I can't seem to find a way to lock all six rows together so the information doesn't get muddled.

    Here's an image of what I have:

    http://imgur.com/a/n84FN

    Any help would be greatly appreciated, thanks (:

  2. #2
    Forum Contributor
    Join Date
    10-30-2014
    Location
    England
    MS-Off Ver
    2007 / 365
    Posts
    279

    Re: Locking rows together while filtering

    As Excel works on the rule '1 row - 1 record' you cannot 'lock' them together.

    The easiest way - assuming you want to keep the 5 rows under each 'Example' together - is just repeat the 'Example X' text underneath for each row, that way they will all be displayed when the Filter is used ion that column. If you don't want the text to show just format it white.

  3. #3
    Registered User
    Join Date
    09-10-2016
    Location
    UK
    MS-Off Ver
    365
    Posts
    2

    Re: Locking rows together while filtering

    Okay, thanks for your help

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Locking a column during filtering
    By ace10mccloud in forum Excel General
    Replies: 2
    Last Post: 04-24-2014, 03:30 AM
  2. input box problem, cell filtering problem, result display while locking sheet
    By croozin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-01-2013, 08:52 AM
  3. locking rows
    By katyhudson in forum Excel General
    Replies: 2
    Last Post: 04-26-2012, 11:26 AM
  4. Locking rows?
    By Shadowblade in forum Excel General
    Replies: 3
    Last Post: 07-14-2011, 12:41 PM
  5. locking rows
    By mike009 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-22-2010, 05:03 PM
  6. Locking rows together
    By roth_nj in forum Excel General
    Replies: 3
    Last Post: 02-28-2009, 02:47 AM
  7. [SOLVED] locking rows
    By Charlie Brown in forum Excel General
    Replies: 1
    Last Post: 07-27-2005, 06:05 PM

Tags for this Thread

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