Log in  \/ 
x
or
x
x
Register  \/ 
x

or

Excel Tips: Developer > Macro or VBA

Data

Data > Check

How to check if / find cells contains formulas in Excel?

How to check if a cell contains picture in Excel?

How to check if a certain range name exists in Excel?

How to check if a workbook is saved?

How to check if hyperlink exists in a worksheet in Excel?

How to check if row is hidden in Excel?

How to check or determine data type of cell?

How to find or check if a specific workbook is open or not in Excel?

How to quickly check if a file (workbook) is open or closed in Excel?

How to quickly check if a sheet is empty in Excel?

Data > Data validation

How to add tick and cross symbols into drop down list in Excel?

How to allow only date format in specific cells?

How to allow only numbers to be input in text box?

How to auto display a default value while deleting value in drop-down list in Excel?

How to autocomplete when typing in Excel drop down list?

How to circle around a cell in Excel?

How to create a drop down list with hyperlinks to every sheet in Excel?

How to create a drop down list with multiple checkboxes in Excel?

How to create a searchable drop down list in Excel?

How to create drop down list but show different values in Excel?

How to create drop down list with hyperlinks in Excel?

How to create drop down list with multiple selections or values in Excel?

How to increase drop down list font size in Excel?

How to only allow negative numbers in Excel?

How to only allow unique values in Excel?

How to prevent blank or missing entries in cells in Excel?

How to prevent saving if specific cell is blank in Excel?

How to prevent special characters entering in Excel?

How to set a default value in data validation drop-down list in Excel?

How to show the first item in the drop down list instead of blank?

How to validate cells to only accept IP address in Excel?

Data > Filter

How to apply same filter to multiple sheets In Excel?

How to autofilter rows based on cell value in Excel?

How to automatically reapply auto-filter when data changes in Excel?

How to clear filter cache (old items) from Pivot Table in Excel?

How to clear filters from all worksheets in active workbook in Excel?

How to clear filters when opening, saving or closing workbook in Excel?

How to display / show auto filter criteria in Excel?

How to do instant filtered search as you type in a cell in Excel?

How to filter all date cells before or after today in Excel?

How to filter cells by bold characters in Excel?

How to filter data from drop down list selection in Excel?

How to filter data just by clicking cell content in Excel?

How to filter data with hyperlinks in Excel?

How to filter dates between two specific dates in Excel?

How to filter values by first letter or last character in Excel?

How to update advanced filter result automatically in Excel?

Data > Sort

How to auto sort column by value in Excel?

How to auto sort date when date is entered or changed in Excel?

How to flip / reverse a column of data order vertically in Excel?

How to flip / reverse a row of data order in Excel quickly?

How to quickly sort IP address from low to high in Excel?

How to quickly transpose cells left to right in Excel?

How to reverse the order of worksheet tabs?

How to sort column data by clicking on header in Excel?

How to sort data on multiple worksheets at once?

How to sort multiple rows or columns independently at once in Excel?

How to sort numbers within a cell in Excel?

How to sort rows to put the blank cells on top in Excel?

How to sort sheets by a cell value in Excel?

How to sort worksheet tabs by color in Excel?

How to sort worksheets in alphabetical / alphanumeric order in Excel?

Data > Others

How to compare alphanumeric values in two columns in Excel?

How to compare two columns and highlight the unmatched data in Excel?

How to compare two strings for similarity or highlight differences in Excel?

How to expand or close all group rows and columns in Excel?

How to group and ungroup rows in protected worksheet?