+ Reply to Thread
Results 1 to 1 of 1

How to show cells in first two when filtering a table?

  1. #1
    Registered User
    Join Date
    Ontario, Canada
    MS-Off Ver
    MS Office 365 Business Version 2002

    How to show cells in first two when filtering a table?

    Hello everyone, I have created a spreadsheet to list the tasks I'm working on. I mark them complete with a date as I go. I would like to figure out a way to show the data in the first 2 columns (Job No. & Job Name) to still be visible when I filter the table by 'Completed' or 'Urgent'.

    Is there a way to maybe lock those cells without having to repeat them in every row?

    Any help will be greatly appreciated. I am attaching my spreadsheet to help explain the issue.

    [Edit] removed attachment without solutions
    Last edited by freddyspageddy; 03-10-2021 at 10:07 AM.

+ 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. [SOLVED] Filtering table with cells
    By manu1361 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-30-2020, 01:26 PM
  2. Replies: 5
    Last Post: 11-10-2019, 02:30 PM
  3. Pivot table/chart: Filtering specific cells without removing whole row
    By AndyPandy in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-12-2015, 10:19 AM
  4. [SOLVED] Date filtering - show cells with text
    By snanks in forum Excel General
    Replies: 12
    Last Post: 01-29-2014, 10:59 AM
  5. [SOLVED] Show Column 1 Titles when Filtering Table
    By Cansa in forum Excel General
    Replies: 3
    Last Post: 04-02-2013, 03:41 PM
  6. [SOLVED] How to show a sum of conditional cells from table A in a separate Table?
    By jjin in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-27-2012, 09:52 AM
  7. on filtering show whole merged cells
    By carlosmaldonado in forum Excel General
    Replies: 1
    Last Post: 03-18-2011, 11:22 AM

Tags for this Thread


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