Hiding rows based on date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
I am embarrassed that i didn't think to do that.

Thanks Bernie
Steve
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide unused rows based on column info 5
Creating a function to auto hide rows 1
Excel EXCEL - using a date dependant formula to hide rows 3
Hide columns based on row values 2
hidden rows problem 7
How to hide infromation in Excel? 3
Hiding rows based on a cell? 3
Hiding/Unhiding Rows Automatically 1

Back
Top