Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Hiding rows based on date
Is there a way to automatically hide a specific range of rows based on the
date. I want hide rows that are associated with days prior to the current day. Thanks, Steve |
#2
|
|||
|
|||
Steve,
You could select your data table, then apply Data | Filter Autofilter and select the curent date from the dropdown on your date column. That will hide all other rows of data. HTH, Bernie MS Excel MVP "Steve" wrote in message ... Is there a way to automatically hide a specific range of rows based on the date. I want hide rows that are associated with days prior to the current day. Thanks, Steve |
#3
|
|||
|
|||
I am embarrassed that i didn't think to do that.
Thanks Bernie Steve "Bernie Deitrick" wrote: Steve, You could select your data table, then apply Data | Filter Autofilter and select the curent date from the dropdown on your date column. That will hide all other rows of data. HTH, Bernie MS Excel MVP "Steve" wrote in message ... Is there a way to automatically hide a specific range of rows based on the date. I want hide rows that are associated with days prior to the current day. Thanks, Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
How do I calculate interest and deduct late fees based on date pa. | New Users to Excel | |||
How do I change the value in cell based on a future date | Excel Discussion (Misc queries) | |||
Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) | |||
Count rows based on multiple criteria | Excel Worksheet Functions |