All Content
Timespan
explore our new search
Excel Go To Special - secrets and best practices
Excel
Jan 26, 2023 5:00 AM

Excel Go To Special - secrets and best practices

by HubSite 365 about Efficiency 365 by Dr Nitin

Pro UserExcelLearning Selection

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

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.

´