shortcut for highlighting cell(s)

[sokevin]

is there a shortcut key for highlighting cells?

i assume there is coz there is a shortcut key for the other formattin
text functions

thanks :

 

[Bob Phillips]

Highlight meaning select?

If so, just hold the CTl button down and drag the mouse over the range.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Earl Kiosterud]

Sokevin,

Hold Shift as you use the Arrow keys.

 

[Bob Flanagan]

Still another approach:

select the first cell
press F8 (toggles extension select off and on)
select the last cell

Robert Flanagan
Macro Systems
Delaware, U.S. 302-234-9857
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

 

[Gord Dibben]

sokevin

Your reference to "formatting text" leads me to believe "highlighting" means
coloring the selected cells.

AFAIK there is no shortcut key for this.

A recorded macro give this code.

Sub Macro1()

' Keyboard Shortcut: Ctrl+x

With Selection.Interior
.ColorIndex = 6 'yellow
.Pattern = xlSolid
End With
End Sub

Gord Dibben Excel MVP

 

[ElsiePOA]

If what you are looking for is a quick way to change the backgroun
color of one or more cells, you can use the "Fill Color" tool on th
"Drawing" toolbar." (The icon is a tipped can of paint)If you don'
want to have the Drawing toolbar activated all the time, you can us
the "Customize" command and move the icon to your standard toolbar.

I'm not aware of any keyboard shortcut that will do this