Select all the cells of a worksheet that contains a specific value with this awesome Excel trick.
This video shows the highly undervalued Find feature of Excel to quickly select all cells with a value. Once selected we can perform any action such as format, copy or delete in seconds.
Learn tons more secret Excel tricks - [ Ссылка ]
Tips like these can save hours of time on day to day tasks. No formulas, no VBA. Just clever use of classic Excel tools.
Find more great free tutorials at;
[ Ссылка ]
*** Online Excel Courses ***
The Ultimate Excel Course – Learn Everything ► [ Ссылка ]
Excel VBA for Beginners ► [ Ссылка ]
Advanced Excel Tricks ► [ Ссылка ]
Excel Formulas Made Easy ► [ Ссылка ]
Creating Sports League Tables and Tournaments in Excel ► [ Ссылка ]
Connect with us!
LinkedIn ► [ Ссылка ]
Instagram ► [ Ссылка ]
Twitter ► [ Ссылка ]
Select All Cells with a Specific Value - Excel Trick
Теги
Excel TricksComputergagaFind and ReplacesSelect AllSpecific ValueExcel Tipslearn excelselect cellsexcel tips and tricksexcel select cells with specific textexcel select cell based on valueexcel select cells with certain valueexcel select cellsexcel for analystsselect all cells with a specific valueselect all cells with certain text excelexcel tips and tricks you must knowexcel tricks for accountantsexcel tips tricks