+ Reply to Thread
Results 1 to 2 of 2

How to hide and show certain rows by a click in google sheets

  1. #1
    Registered User
    Join Date
    08-26-2016
    Location
    Stockholm
    MS-Off Ver
    2013
    Posts
    25

    How to hide and show certain rows by a click in google sheets

    Hi,

    I would like to know if its possible to hide and show certain rows in google sheets by one click. Another way could be to create dropdown menus, does anyone know how to do this. If you look at my picture one, the sheet is organized to certain months, and when january is finished I would like to hide row 3-5 (picture 2) by clicking on January. Can someone help me with this?
    Attached Images Attached Images

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: How to hide and show certain rows by a click in google sheets

    Simply answer....Nope
    https://productforums.google.com/for...cs/pm4Gd4O_Bm0

    some users have done some sort of work around with some 3rd party software to do it but for the general populous
    people have been complaining to google since 2013 about it
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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. How To Hide/Unhide sheets based on a button click
    By m2som in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-14-2017, 07:54 PM
  2. [SOLVED] Auto Fill Formula into New Rows/Columns [Google Sheets]
    By banyanman in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 7
    Last Post: 05-03-2016, 03:24 PM
  3. email row contents based on cell values (google sheets populated by google forms)
    By reedg in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 01-13-2016, 02:55 PM
  4. [SOLVED] Hide And Unhide Column With One Button,,,,Once Click Hide,,,,,Again Click Unhide
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-11-2014, 07:58 AM
  5. [SOLVED] Hidden sheets show after double click on cell
    By shalhevet in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-13-2013, 06:36 AM
  6. Replies: 1
    Last Post: 01-29-2013, 09:19 PM
  7. Replies: 1
    Last Post: 01-25-2012, 04:29 AM

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