Home |
Search |
Today's Posts |
#1
|
|||
|
|||
can you hide rows with a formula?
on my last sheet there should be an overview of the data selected by the
user. If the user doesnt select all the blocks with data because he thus not need that particular block. There will be empty rows between the information on the last sheet! I need all the info under each other, so that the user will have a short clear overview that will fit on 1 page to print. (this should be all automatic). Is this possible by hiding the empty rows with a formula? Or is there another way? (The sow called empty rows do contain formulas that hide the data blocks that the user thus not need) Please help me I have tried so many things and still without resold. Greets david |
#2
|
|||
|
|||
|
#3
|
|||
|
|||
ok thank you
------------------------------------------------------------------------ "Don Guillett" wrote: Pls only post in ONE ng. We read em all -- Don Guillett SalesAid Software "david" wrote in message ... on my last sheet there should be an overview of the data selected by the user. If the user doesn't select all the blocks with data "because he thus not need that particular block". There will be empty rows between the information on the last sheet! I need all the info under each other, so that the user will have a short clear overview that will fit on 1 page to print. (this should be all automatic). Is this possible by hiding the empty rows with a formula? Or is there another way? (The sow called "empty rows" do contain formulas that hide the data blocks that the user thus not need) Please help me I have tried so many things and still without resold. Greets david |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
remove or hide blank rows | Excel Discussion (Misc queries) | |||
How do you use the explode and collapse panel to hide rows? | Excel Worksheet Functions | |||
Checkbox to hide and unhide rows Please. | Excel Worksheet Functions | |||
AUTO HIDE ROWS | Excel Worksheet Functions | |||
How do I hide a formula message? | Excel Worksheet Functions |