Jan 26, 2023 5:00 AM
Excel Go To Special - secrets and best practices
External YouTube Channel
Excel Go To Special selects some cells in the current worksheet. Sounds very simple and trivial. It is not. Go To Special has a powerful set of options which he
Excel Go To Special selects some cells in the current worksheet.
Sounds very simple and trivial. It is not. Go To Special has a powerful set of options which help precise selection of desired items fast, easy and accurate. Get amazed by what you have been missing for decades.
Contents
- 00:00 - Intro
- 00:16 - Notes
- 01:37 - Constants and Formulas
- 05:10 - Blanks
- 08:35 - Current Region and Array
- 10:31 - Objects
- 11:25 - Precedents Dependents
- 14:14 - Last Cell
- 15:40 - Row Column Difference
- 16:13 - Visible cells only
- 17:58 - Conditional Formatting
- 18:53 - Data Validation
More links on about Microsoft 365
From Go to Special dialog box, select Blank and click OK. excel tips and tricks to highlight blank cells click blank option. At this point, you have all the ...
Feb 18, 2022 — In this post, I'll go over the best tips, tricks, and shortcuts you can use right now to take your Excel game to the next level.
´
HubSite 365 Apps