Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I actualy need to remove the data filtering it will confuse people, I need it
to just be gone. "Pritesh" wrote: Step1: For time-being, you can change cell formatting such way that it does not show time but only shows date in mm-dd-yyyy format. Step2: Apply data filter Step3: From filter drop-down, select/filter to show dates that you want to delete. Step4: Select all visible/filtered lines and say Delete, it will ask if you want to delete entire row?, say yes. -- Regards, Pritesh "Poohberry" wrote: I have a spreadsheet that I want to delete the entire row if it contains 04-29-2010 but there is a time stamp that changes after that. How do I delete all the rows containing 04-29-2010 with random data after? Thanks in advance for your brilliance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
look up and match exact data is adjacent column | New Users to Excel | |||
Routine to find exact Row matches in Col1 Col2 Col3 but exact offsetting numbers in Col4 | Excel Discussion (Misc queries) | |||
exact value from supplied Row and Column data | Excel Worksheet Functions | |||
data that matches exact column and row | Excel Worksheet Functions | |||
matching a sorting the exact value in the data list | Excel Discussion (Misc queries) |