Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hidding rows when sorting
Hi all
I have a sheet, where I upload informaton - some rows are hidden (parts already in stock) So, when they sort by some coloumn, it shows all rows, and hides the one which does not match. Is there an event I can catch so I can hide even more? It is a file someone else made at some time, so: how do I add the sort option? WBR Sonnich |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hidding rows when sorting
"hides the one which does not match"
Sounds like you are filtering, not sorting. Gord Dibben MS Excel MVP On Tue, 1 Jun 2010 09:46:57 -0700 (PDT), jodleren wrote: Hi all I have a sheet, where I upload informaton - some rows are hidden (parts already in stock) So, when they sort by some coloumn, it shows all rows, and hides the one which does not match. Is there an event I can catch so I can hide even more? It is a file someone else made at some time, so: how do I add the sort option? WBR Sonnich |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hidding rows and colums | Excel Discussion (Misc queries) | |||
Hidding #DIV/0! In Cell | Excel Worksheet Functions | |||
Hidding #DIV/0! In Cell | Excel Worksheet Functions | |||
Hidding #DIV/0! In Cell | Excel Worksheet Functions | |||
Hidding Tabs | Excel Discussion (Misc queries) |