Excel Roundup 20141110

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. For example, if you drag down from A2:A7, you could click on cell A5, to unselect just that cell.

Excel SelecTracker add-in

Contextures Posts

Here’s what I posted recently:

  • For a humorous peek at what other people are saying about spreadsheets, read the latest collection of Excel tweets, on my Excel Theatre blog.
    This week, I’ve added a poll at the end, so please vote for your favourite tweet.

Other Excel Articles

Here are a few of the Excel articles that I read recently, that you might find useful.

  • 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.

Advanced Excel Essentials, by Jordan Goldmeier

“For Intermediate or advanced excel users who wish to learn how to be more productive and develop more powerful applications…starts from the assumption that you are well-versed in Excel—and builds on your your skills to take them to the advanced level.”

Six Sigma Statistics with Excel and Minitab, 2E by Issa Bass

“This practical guide provides the perfect toolbox of theory, illustrations, explanations, exercises, and case studies both in the book and on an affiliated website to show how to use Excel and Minitab in conjunction with Six Sigma for an ideal improvement package.
It reviews the quality tools that require Excel and/or Minitab, including measurement system analysis, SPC, the Taguchi method, and process capability.”

LONDON Abbot Katz is presenting a series of Excel courses in London on consecutive Monday evenings, in November, at the offices of the Guardian newspaper near the Kings Cross station.
Nov 10th — Formula and function writing
Nov 17th — Visual enhancements
Nov 24th — Grabbing and grooming the numbers

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!

Weekly Excel Roundup http://blog.contextures.com/

_____________________

Links to Recent Excel Books on Amazon.com

excelfunctionsheld01

_________________________________

You may also like...

2 Responses

  1. Doug Glancy says:

    Wow, I’m above the fold! Thanks Debra.

    In response to being able to unselect just one cell within a large area, there’s this Chip Pearson page: http://www.cpearson.com/excel/unselect.aspx. When you need to unselect one cell from a range you’ve selected all at once, it does just that.

    It’s interesting that clicking a cell a second time doesn’t unselect, but I imagine it’s got to do with selecting a range that includes some cells that are already selected and some that aren’t. Maybe the programmers decided anything besides just selecting it again would be too confusing.

Leave a Reply

Your email address will not be published. Required fields are marked *