|
Formula to hide blank rows
I have a nine page order form - my question is if it is possible to hide a
row if the item in that row is not chosen. I want to end up with a two or three page order form showing customer choices instead of nine pages of half filled in rows - any suggestions? Thanks. |
Take a look at Data / Filter / Autofilter on whatever field denotes being
chosen http://www.contextures.com/xlautofilter01.html -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Ladyra" wrote in message ... I have a nine page order form - my question is if it is possible to hide a row if the item in that row is not chosen. I want to end up with a two or three page order form showing customer choices instead of nine pages of half filled in rows - any suggestions? Thanks. |
I looked at filters but I was really just wanting a formula that would hide
or delete a complete row if there was no selection by "X" in that row - is this possible? Thanks for your help. "Ken Wright" wrote: Take a look at Data / Filter / Autofilter on whatever field denotes being chosen http://www.contextures.com/xlautofilter01.html -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Ladyra" wrote in message ... I have a nine page order form - my question is if it is possible to hide a row if the item in that row is not chosen. I want to end up with a two or three page order form showing customer choices instead of nine pages of half filled in rows - any suggestions? Thanks. |
Not without resorting to VBA code. Autofilter is a solution that will
require just two mouse clicks to hide all the unnecessary rows. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Ladyra" wrote in message ... I looked at filters but I was really just wanting a formula that would hide or delete a complete row if there was no selection by "X" in that row - is this possible? Thanks for your help. "Ken Wright" wrote: Take a look at Data / Filter / Autofilter on whatever field denotes being chosen http://www.contextures.com/xlautofilter01.html -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 -------------------------------------------------------------------------- -- It's easier to beg forgiveness than ask permission :-) -------------------------------------------------------------------------- -- "Ladyra" wrote in message ... I have a nine page order form - my question is if it is possible to hide a row if the item in that row is not chosen. I want to end up with a two or three page order form showing customer choices instead of nine pages of half filled in rows - any suggestions? Thanks. |
Okay - thanks.
"Ken Wright" wrote: Not without resorting to VBA code. Autofilter is a solution that will require just two mouse clicks to hide all the unnecessary rows. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "Ladyra" wrote in message ... I looked at filters but I was really just wanting a formula that would hide or delete a complete row if there was no selection by "X" in that row - is this possible? Thanks for your help. "Ken Wright" wrote: Take a look at Data / Filter / Autofilter on whatever field denotes being chosen http://www.contextures.com/xlautofilter01.html -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 -------------------------------------------------------------------------- -- It's easier to beg forgiveness than ask permission :-) -------------------------------------------------------------------------- -- "Ladyra" wrote in message ... I have a nine page order form - my question is if it is possible to hide a row if the item in that row is not chosen. I want to end up with a two or three page order form showing customer choices instead of nine pages of half filled in rows - any suggestions? Thanks. |
| All times are GMT +1. The time now is 04:28 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com