One Excel annoyance is that after you select a group of cells, you can’t unselect one of them. For example, you might want to format specific cells, or create a named range, and you accidentally include a cell that shouldn’t be in the group. You can’t click on that cell to unselect it – you have to start over, and select more carefully the next time.
To solve that problem, Doug Glancy has created a free tool that you can download — SelecTracker.
Next, we need a version that lets you unselect one cell within an large area, e.g. if you drag down from A2:A7, click on cell A5, to unselect it.
Contextures Posts
Here’s what I posted recently:
- Fix numbers that don’t add or sort correctly, when you copy data into Excel from a website, or another source.
- The deadline has passed for the Pivot table online course giveaway. Winners will be announced on Wednesday.
- For a humorous peek at what other people are saying about spreadsheets, read the latest collection of Excel tweets, on my Excel Theatre blog.
Other Excel Articles
Here are a few of the Excel articles that I read recently, that you might find useful.
- Neale Blackwood shares his 4 guidelines for formula creation. Do you agree with all of them?
- Did you celebrate International Keyboard Shortcut day last week? Dick Kusleika shared several of his favourites, including shortcuts to open, close and save workbooks.
- On Chandoo’s blog, Sohail Anwar explains how you can use multiple conditions in a VLOOKUP.
- Even if you’re not a lawyer, you can keep track of your time, with this technique from Ben J. Kusmin.
- I’m sure you’ve heard that Microsoft Office apps, including Excel, are now free for the iPad. Jared Newman takes a look at what you get.
- Winston Snyder shows how he makes some subtle changes to an Excel Table’s TableStyle.
Excel Announcements
Here are some upcoming events, courses, recently published books, and other new items, related to Excel.
LONDON | Chris Webb is running a one-day Power Query course in London on Nov. 13, 2014.
This course is aimed at Excel users and BI professionals who want to learn how to use Power Query to load data into Excel and use it with Power Pivot and the rest of the Power BI stack. The course will include practical exercises, and for attendees to take part they must bring a laptop with Excel 2013 and Power Query installed. |
Share Your Events and Articles
If you read or wrote any other interesting Excel articles recently, or have upcoming Excel events, please share a link in the comments below, with a brief description. Thanks!