Skip to content
View in the app

A better way to browse. Learn more.
MSFN

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

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

novicee
in Microsoft Office

Featured Replies

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

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.

Create an account or sign in to comment
Go to topic listing

Recently Browsing 0

  • No registered users viewing this page.

Account

Navigation

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.