• How to highlight row and column when user click on cell

  Save workbook as macro enabled Convert text to table select all table except header (https://storage.crisp.chat/users/helpdesk/website/d5Few readers

• How to Search As You Type List

  Searchable Drop Down List on Separate Sheets Min 4 x column are required on source sheet Cell A2                  A1 is empty cell and A2 formula is (Past and Drag to end) =IF(ISNUMBER(SEARCH(INDIRECT(CELL("Address")),B2)),MAX($A$1:A1)+1,0) 3.            Original List        Original List is only your text 4.            Filter List             C2 formulaFew readers

• Collect Data from different sheet to Master Sheet without naming sheet

  Append Data from different worksheet to master sheet in excel Create Multiple table of data in different or 1 sheet. Go to Data, Get Data, Excel, and select respective file and click on import. It will explore all table containing in this file, does not matteFew readers

• Compare 2 columns in excel

  Compare 2 columns in excel 3.            Conditional formatting Select both column                 Conditional formatting, highlight duplicate with color                 Conditional formatting, highlight unique with different color 4.            =Vlookup(Few readers