Jump to content

Welcome to MSFN Forum
Register now to gain access to all of our features. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more. This message will be removed once you have signed in.
Login to Account Create an Account



Photo

Excel 2007 : Is it possible to conditionally hide a row?

- - - - -

  • Please log in to reply
1 reply to this topic

#1
novicee

novicee

    Newbie

  • Member
  • 16 posts
  • Joined 05-May 10
  • OS:Windows 7 x86
  • Country: Country Flag
Excel 2007 : Is it possible to conditionally hide a row?

Is it possible to make the visibility of a row conditional on a value in a cell of the row? For example, can a row be hidden if the first cell of the row contains the value 5 but otherwise the row is visible?

Ditto question for columns.

The question comes up in the context of time series that are step functions.

Any help would be appreciated. I couldn't find an answer in Excel 2007 Help.

- Novice

Edited by novicee, 06 November 2011 - 12:18 AM.

"Everything should be made as simple as possible but not simpler" - Einstein


How to remove advertisement from MSFN

#2
IcemanND

IcemanND

    MSFN Junkie

  • Super Moderator
  • 3,266 posts
  • Joined 24-September 03
  • OS:Windows 7 x64
  • Country: Country Flag
You could use the Filter feature on the Data tab to filter rows but not columns.

If both are needed I think you would have to use a VBA function called on a worksheet change if you want it to happen any time a monitored value changes.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users