Ignoring Special Characters when Double-Clicking

by Allen Wyatt
(last updated June 20, 2020)

When Jose double-clicks on a word in a worksheet, Excel selects the entire word. If the word contains a special character, though, then the selection is truncated by that character. This means that less than a full word is selected. Jose wonders if there is a way to have Excel ignore the special character and select the entire word.

This behavior is consistent with how other Office programs (such as Word) allow you to select by clicking, as well. There is no way to change that behavior; it is hard coded into the program.

The workaround, however, is easy enough to implement. Let's say that you have a special character inside of a word, such as a bullet inside a company name. To select it, just double-click on the portion either before the bullet or after, but don't release the mouse button after the second click. Instead, simply drag the mouse pointer to whichever half of the word you didn't double-click on. Excel (like Word) continues to expand the selection by a word at a time until you release the mouse button. Thus, you would double-click and drag instead of just double-clicking.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (13774) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and Excel in Office 365.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Printing Non-Printing Characters

Serious users of Word often display non-printing characters on-screen so they can see them easier. If you want those ...

Discover More

Forcing Worksheets to Print on a New Sheet

Excel allows you to easily print an entire workbook. Doing so, however, may not give the desired results if you a ...

Discover More

Absolutely Getting Rid of Formatting

Need to get rid of the formatting applied to a bunch of text? One of the easiest ways to do this is to use Notepad in ...

Discover More

Program Successfully in Excel! John Walkenbach's name is synonymous with excellence in deciphering complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Check out Excel 2013 Power Programming with VBA today!

More ExcelTips (ribbon)

Canceling an Edit

When editing a cell, you may want to cancel the edit at some point. There are two ways to do this, both described in this ...

Discover More

Changing References in a Lot of Defined Names

Need to change some cell references in your defined names? Changing one or two is easy; changing dozens is a good deal ...

Discover More

Using the Same Range Name on Different Worksheets

Defined names can be a great boon when working in a worksheet. Usually names are available throughout an entire workbook, ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is four less than 5?

There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)


This Site

Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.