Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Shortcut keys for Highlighting Cells

Shortcut keys for Highlighting Cells

Shortcut keys for Highlighting Cells

Just looking for a shortcut key for highlighting cells. Can't seem to find it.

RE: Shortcut keys for Highlighting Cells

highlighting as in selecting or coloring?


RE: Shortcut keys for Highlighting Cells

As in to "Fill" a cell a given colour or to highlight it.

RE: Shortcut keys for Highlighting Cells

You might try conditional formatting, there's no quicker shortcut, it's automatic.

Or, select all your cells to be highlighted using "ctrl" before clicking on any additional cells in your selection, then setting the color only once for the whole selection.


RE: Shortcut keys for Highlighting Cells

Remember that F4 repeats your last command, including formatting.

RE: Shortcut keys for Highlighting Cells

A particularly useful, and rarely documented, shortcut is


If you do this while your cursor is inside a rectangular block of used cells, the entire rectangular block is immediately selected.  The results are slightly less predictable if your cursor is inside a non-rectangular block, but not totally counter-intuitive.

RE: Shortcut keys for Highlighting Cells

Place cursor in cell you want to start with, press Shift
and do the highlight with arrows to any direction you need to go.

RE: Shortcut keys for Highlighting Cells

To Select Excel cells via the keyboard

· [Ctrl]A  - selects the entire worksheet and is handy when you want to convert every formula in your worksheet to a value in one fell swoop.

· [Ctrl][Shift][*]  - tells Excel to scan the cells around a cell, make a computer-educated guess based on the contents, and select what Microsoft calls "the current region." Once selected, you can copy, cut, or format the text as you like.
· [Ctrl][Shift][End]  - starts with the current cell and selects a rectangle of cells from that point to the last used cell in the worksheet's bottom-right corner.

· [Ctrl][Shift][Home]  - selects a rectangle of cells starting from the current cell and ending in cell A1.

· [Ctrl][Shift]  - combined with any of the four arrow keys begins at the current cell and selects through the last nonblank cell in the same row or column as the active cell.

This is how these shortcuts work if you key them without first selecting a cell. If you select at least one cell and then press any of the key combinations above, Excel extends the existing selection.

       "If you don't use your head,
                       your going to have to use your feet."

RE: Shortcut keys for Highlighting Cells

I don't think anybody understands what I am looking for so I will restate it:

I do a great deal of estimating where I have to go through large amounts of data. Say I was updating a line and want just want to highlight it (i.e., change the colour of the cell to yellow), to show that I have already changed it.

I am somebody who does not use a mouse for anything in Excel - i.e., I use the keyboard exclusively for all commands. How do I change the colour of a cell without pressing the "Fill Colour" button?

RE: Shortcut keys for Highlighting Cells

How 'bout just a simple keyboard macro?

ActiveCell.Rows("1:1").EntireRow.Interior.ColorIndex = 35 assigned to a control-key combo?

RE: Shortcut keys for Highlighting Cells

I think conditional formatting is still your best option. Add a column to hold a flag value, perhaps W for white background and Y for yellow highlight.

Put an if statement in the conditional formatting to change the cell color to yellow if the appropriate flag cell contains a Y.

This will allow you to toggle the highlight entirely though keyboard control in a spreadsheet with this format system applied.

Hope it helps.

RE: Shortcut keys for Highlighting Cells

Then create the macro to automate this function:

Give it a name (ie. highlight_yellow)
Assign a shortcut key and hit OK (ctrl-y)
[The stop recoding toolbar should appear)

Then using the mouse hit FORMAT/CELLS/PATTERNS/(pick yellow for this example) and then OK

Now hit the stop recording button om the stop recoding toolbar.

Now after selecting the cells you want to highlight hit ctrl-y (for this example)

       "If you don't use your head,
                       your going to have to use your feet."

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


Low-Volume Rapid Injection Molding With 3D Printed Molds
Learn methods and guidelines for using stereolithography (SLA) 3D printed molds in the injection molding process to lower costs and lead time. Discover how this hybrid manufacturing process enables on-demand mold fabrication to quickly produce small batches of thermoplastic parts. Download Now
Design for Additive Manufacturing (DfAM)
Examine how the principles of DfAM upend many of the long-standing rules around manufacturability - allowing engineers and designers to place a part’s function at the center of their design considerations. Download Now
Taking Control of Engineering Documents
This ebook covers tips for creating and managing workflows, security best practices and protection of intellectual property, Cloud vs. on-premise software solutions, CAD file management, compliance, and more. Download Now

Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close