English
Go to website
Back
Articles on:
Excel
No description
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/d5
Few 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
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 formula
Few 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 matte
Few readers