+ Reply to Thread
Results 1 to 8 of 8

[SOLVED] Highlighting Multiple Cells (Keystroke Help)

  1. #1
    Registered User
    Join Date
    08-16-2012
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    25

    [SOLVED] Highlighting Multiple Cells (Keystroke Help)

    Hi all,

    Hope someone can help me here! Need help with a keyboard shortcut...

    If you look at my example attached, I would like to select the name "John" in all three tables at once along with his age (24) and his eye color (Blue)..which makes for a total of nine cells...I want to highlight all of these cells at once, thus, I would like to select them all at once.

    Is there a shortcut in order to do this? Other than holding "Ctrl" and clicking on each cell individually?

    Thanks!
    Attached Images Attached Images
    Last edited by william.; 09-27-2012 at 03:44 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    03-23-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1,093

    Re: Highlighting Multiple Cells (Keystroke Help)

    Hello there, a couple of questions:

    1. Will there be more than one individual with the John?
    - For example can there be John, age 23, blue eyes and another John, age 32, brown eyes?
    a. If so, do you want to highlight all John's are just the ones that match the John selected?
    - For example you select John, age 23, blue eyes, do you want to highlight just the John's that
    match that selection or highlight all John's?

    2. What do you mean by highlight cells?
    - by the way you are using it in your post it seems as though you just want to select them
    - or do you want to change their fill color, text... etc ?

    Thanks!

  3. #3
    Registered User
    Join Date
    08-16-2012
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    25

    Re: Highlighting Multiple Cells (Keystroke Help)

    1) For my usage purposes, I would say that highlighting all the John's would work.

    2) I would like to select the cells, so that I can highlight them once they are selected!

    Sorry for any confusion, and thanks for the help!

  4. #4
    Valued Forum Contributor
    Join Date
    03-23-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1,093

    Re: Highlighting Multiple Cells (Keystroke Help)

    No problem, thanks for the clarification. The below code should work for you.

    Please Login or Register  to view this content.
    To insert this code into your workbook

    1. Select the worksheet that contains that values
    2. Right click on the worksheet's tab
    3. Select the view code option
    4. In the blank space provided copy and paste the above code, anything that appears in green is a comment meant to help you understand. Also, there are lines that tell you how to adjust it if you want to programmatically color the cells.

    5. Close out of Visual Basic

    To test the code:

    Double-click on a cell the contains the word John.

    Let me know if this is what you were looking for.

    Thanks!

  5. #5
    Registered User
    Join Date
    08-16-2012
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    25

    Re: Highlighting Multiple Cells (Keystroke Help)

    Very helpful, but one small problem. When I double-click on the word (John) that needs to be highlighted, it only selects all of the Johns, but not the cells to the right of John, in column B and C. I would like to select all of these cells (John, 24, Blue)...all at once.

    Thanks so much for the help!

  6. #6
    Valued Forum Contributor
    Join Date
    03-23-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1,093

    Re: Highlighting Multiple Cells (Keystroke Help)

    Sorry about that,

    Please change the following line of code:

    Please Login or Register  to view this content.
    To:

    Please Login or Register  to view this content.
    If this solves your post, please mark this thread solved and maybe give a little star tap if I've helped.

    Thanks!

  7. #7
    Registered User
    Join Date
    08-16-2012
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    25

    Re: Highlighting Multiple Cells (Keystroke Help)

    Perfect. Exactly what I was looking for! Thanks a ton!

  8. #8
    Valued Forum Contributor
    Join Date
    03-23-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1,093

    Re: [SOLVED] Highlighting Multiple Cells (Keystroke Help)

    No problem! Thanks for the star tap!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1