Hide rows without conditional formatting
Last answer on Feb 26, 2009 8:15:36 am GMT obsidian, on Feb 26, 2009 1:35:01 am GMTHello,
I'm creating an Excel spreadsheet and want to give it a cleaner look by hiding the contents of a row based on the value of a cell in that row. For example, I want to hide b1:p1 if the value of a1 is blank. I can do it with conditional formatting, but I have 50+ rows and I only want them to show if there is a number in a1, a2, a3 ..... and so on. So if I put 1 in a1, 2 in a2 and 3 in a3, I should have the rest of the data in those rows populate.
Configuration: Vista Excel 2007
Best answers for « Hide rows without conditional formatting » in :
Avoid duplicates in Excel ShowAvoid duplicates in Excel
In order to avoid duplication when encoding in a column from an excel sheet:
take the conditional format on the first cell under the headings (eg A2)
choose the following formula:...
Colouring cells on conditions ShowColouring cells on conditions
There are many pratical functions under Excel which is not commonly used.
Example: If you wish a cell automatically turns red (or other formatting border, frame etc) under one condition: a result, a...
[Google]Searching for files using a specific format Show[Google]Searching for files using a specific format
Some files are easier to find when looking for them as a specific format, E.g as a manufacturer documentation often (in pdf format).
To make use of this feature of Google just use...
Download Format Factory ShowFormat Factory is an application that allows conversion of various types of media files. It has various characteristics that allow you to customize a lot of stuff like:
Convert video formats, audio and picture shows.
Repair damaged files.
Reduce...
Download HP USB Disk Storage Format Tool ShowHP USB Disk Storage Format Tool is a small utility allowing to format a key USB or READER MP4. It also allows to make a key (Bootable).
This software works with all keys and readers MP4 of the market.
To make work this utility under Windows...
General Terms and Conditions of Use ShowAll Rights Reserved - 2009 - Communitic International
Object
These General Terms and Conditions are meant to define the ways in which the services of the website en.kioskea.net, hereafter "The Service," are made available, as well as the...
GIF format ShowGIF format
The GIF format (Graphic Interchange Format) is a bitmap (raster) graphic file format developed by Compuserve.
There are two versions of this file format developed respectively in 1987 and 1989:
GIF 87a supporting LZW compression,...
Spreadsheets - Conditional expressions ShowWhat is a Conditional Structure?
Conditional structures are
instructions that allow to test if a condition is true or not.
Conditional structures may be associated together. To successfully
execute these tests using logical functions, spreadsheets...
See also Plus
Conditional format formula if- Conditional format with multiple columns
- Conditional formatting spreadsheets
- Conditional formatting using 4 colours in openoffice
- Countif conditional formatting
- Excel 2007 conditional formatting to remove #n/a
- Excel conditional formatting if cell is no color whole row
- Excel conditional formatting increase by 10%
- Excel conditional formatting using mid
- Excel mac conditional formatting 3 conditions
- Excel script to hide rows if condition met
- Excel, conditional formatting, if date is in the past
- Excel, using conditional formula to copy rows
- Fill down conditional formatting macro
- Formatconditions.count conditional format
- Giving more than three conditions in conditional formatting in excel
- Hiding duplicates in excel 2003 using conditional formatting
- More than 3 conditional formats in excel 2003
