Picture Drop-down List: Quickly create a drop-down list with images in Excel.Colored Drop-down List: Quickly color/conditional formatting drop-down list in Excel.Create Simple Drop-Down List: Quickly create a drop-down list in Excel.Clear Data Validation Restrictions: Batch clear all data validation restrictions from selection in Excel.Validate Phone Number: Quickly apply phone number data validation to cells in Excel.Validate IP Address: Quickly set data validation to accept only IP addresses in Excel.Validate Email Address: Quickly validate email addresses in a column or a range of cells in Excel.Only allow specific characters to be entered in a range of cells. Easily prevent special or certain characters from being typed in cells.Prevent Duplicate: Quickly prevent duplicate entries in a column in Excel.Unhide all Ranges: Quickly unhide all rows and columns in ExcelĬopy Ranges: Easily copy multiple selections in ExcelĬompare Cells: Easily compare two ranges of cells if they are equal or different in Excel.Paste to Visible: Quickly copy data and paste into only visible cells / filtered list in Excel.Sort / Select Range Randomly: Quickly sort or select cells, rows and columns randomly in Excel.Swap Ranges: Easily wwap cells, rows, columns or ranges in Excel.Transform Range: Transpose (convert) a single column or row to ranges or vise versa in Excel.Transpose Table Dimensions: Quickly convert 2-dimensional/cross table to list in Excel.Flip Vertical Range: Quickly reverse date order of multiple rows vertically with flip vertical range.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |