+ Reply to Thread
Results 1 to 3 of 3

Protect rows from AutoFilter Option

  1. #1
    Registered User
    Join Date
    01-25-2023
    Location
    Mexico
    MS-Off Ver
    2019
    Posts
    2

    Post Protect rows from AutoFilter Option

    Hello, I would like to use the AutoFilter option on Google Sheets. But since im handling a significant amount of rows, i would like to have some "Subheader" to easier identify the Data

    Other than adding a New Row for "Week" is there any other way to do that?

    Attached is image of the Data.


    AutoFiler.jpg

  2. #2
    Forum Contributor
    Join Date
    12-17-2013
    Location
    ON, Canada
    MS-Off Ver
    MS 365
    Posts
    171

    Re: Protect rows from AutoFilter Option

    Parlos,

    If it's possible to modify your data by adding an extra column containing the week number, you could use a Pivot Table to achieve your desired results.
    Have a look at this LINK and let us know if this is what you're looking for.

  3. #3
    Registered User
    Join Date
    01-25-2023
    Location
    Mexico
    MS-Off Ver
    2019
    Posts
    2

    Re: Protect rows from AutoFilter Option

    I see the Pivot Table might work, but im looking more Visually to Keep the Subheader lines in all filters. As if the Sub HEader lines are to remain frozen always and untouched by the AutoFiltering...Effectively separating each week with an Empty Row so to say

+ 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. VBA macro protect autofilter
    By Arthur Cramer in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-08-2022, 11:10 PM
  2. AUTOFILTER with protect sheet
    By janger-heli in forum Excel General
    Replies: 1
    Last Post: 01-08-2009, 07:19 AM
  3. autofilter and protect
    By khalid79m in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-03-2007, 09:15 AM
  4. How to protect formula's, but allow autofilter
    By MichaelJDrake in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-24-2006, 11:00 AM
  5. Mofiying the protect option.
    By Gizmo63 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-21-2006, 11:25 AM
  6. [SOLVED] How to protect option button?
    By Julie in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-28-2005, 11:06 AM
  7. How to protect option button?
    By Julie in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-22-2005, 11:07 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