Excel Hotkeys...

[Connor]

Is there a hotkey to changing fontsize in Excel 2003/2007?

/Connor

 

[Shane Devenshire]

Hi,

That's a Word or PowerPoint thing. The best you can do in Excel 2003 is
press Ctrl+Shift+P which puts you in the point size drop down on the toolbar,
then you can either type the value you want and press enter or press the down
or up arrows, or press F4 to open the whole list.

Unfortunately it's slightly more complicated in 2007. You can use
Ctrl+Shift+P but it opens the Format Cells dialog box on the Font tab. Or
you can use Alt+H+FS to reach the Font Size drop down on the ribbon.

 

[Lerner]

I learned this way from this group:
TOOLS>CUSTOMIZE>FORMAT
In the right side you will see a big "A" and small "A"( scroll if not seen),
you can drag those two( one at the time) to any toolbar you desire,
then later on when you need to bigsize or minimize a cell:
just click on any of those A bottoms.

 

[Sheeloo]

In Excel 2007 these buttons are there by default on Home ribbon in Font group.

You can also add the following macros, add shortcut keys (I use ctrl-m and
ctrl-l) you want and use the keyboard to increase/decrease the font size

Sub increaseFontSize()
Selection.Font.Size = Selection.Font.Size + 2
End Sub

Sub decreaseFontSize()
If Selection.Font.Size > 6 Then
Selection.Font.Size = Selection.Font.Size - 2
Else
MsgBox "Can not go below font size 6"
End If
End Sub

 

[Shane Devenshire]

Hi,

Regarding assigning Ctrl+L or is it Ctrl+i? In either case both are already
Excel shortcut keys Ctrl+L is the create Table (List) command and Ctrl+i is
the Italic shortcut key. If you want to assign a shortcut key Ctrl+Shift+I
for increase and Ctrl+Shift+D for decrease are easy to remember and don't
interfere with Excel's built-in shortcut keys.

 

[Sheeloo]

I use those keys because I never use them for the default purpose...

 

[Connor]

Thanks Shane!

Connor

"Shane Devenshire" skrev:

Hi,

Regarding assigning Ctrl+L or is it Ctrl+i? In either case both are already
Excel shortcut keys Ctrl+L is the create Table (List) command and Ctrl+i is
the Italic shortcut key. If you want to assign a shortcut key Ctrl+Shift+I
for increase and Ctrl+Shift+D for decrease are easy to remember and don't
interfere with Excel's built-in shortcut keys.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire