Filter Data in Excel Sheet | How to Filter Data in Excel Sheet

https://www.youtube.com/watch?v=cBaEmxJoPxM

Filter Data in Excel Sheet

How to add Drop Down List In Excel - Excel Drop Down List - Data Validation in Excel cell

How to add Drop Down List In Excel - Excel Drop Down List - Data Validation in Excel cell

How to Create a Data Validation List in Excel.

1. First type all the List which you want to make a data validation List.2. Now Select the entire list.3. Go to Data Tab in the Menu.4. Select Data Validation in the Data menu.5. After Selecting Data Validation Menu, A Pop Up windows opens.6. In theat windows you can see any value in the settings tab by default.7. Now you select list in place of any value.8. Then click ok and close the window.

For Example Check Out this Video.

Click Here

How to Create a Data Validation List in Excel | Drop Down List List in E...

Excel VBA Code to hide rows with previous dates | Advanced Macro to hide rows based on dates in excel

Excel  VBA Code to hide rows with previous dates  | Advanced Macro to hide rows based on dates in excel

Open Excel Sheet

Press Alt + F11 Key 

Go to the Insert Menu and Click on new Module

in New Module copy and paste the above VBA code and save.

Now Press Alt + F8  and new windows will open which is shown in below figure,

in that windows you will ask to enter a key to create shortcut for Paste Special

Enter a letter in the box. 

Sub Hide_Dates()

Dim MyRange As Range, c As Range

Set MyRange = Range("H2:H4436")

MyRange.EntireRow.Hidden = False

For Each c In MyRange

    If IsDate(c.Value) And c.Value < Date Then

        c.EntireRow.Hidden = True

    End If

Next

End Sub

How to change column width and row height automatically

Conditional Format: highlight cells automatically based on values in other cells in excel using Conditional Formatting

https://www.youtube.com/watch?v=IvS2H9_q_sY