Excel Font Size Keyboard Shortcut

**brad78703** · 01-26-2010, 05:19 PM

Hello,

Thanks in advance for any help.

The following keyboard shortcuts exist in Microsoft Word:

Decrease font size one value. CTRL+SHIFT+<
Increase font size one value. CTRL+SHIFT+>
Decrease font size 1 point. CTRL+[
Increase font size 1 point. CTRL+]

However, none of these shortcuts appears to work in Excel. Can anyone tell me if there are equivalent keyboard shortcuts in Excel, or if not, if there is a way to program these font size change shortcuts for use in Excel?

Basically, I'd like to be able to go into a completed worksheet, click on a cell, and change the font size of its contents (either larger or smaller) with a keyboard shortcut.

THANK YOU.

**Paul** · 01-26-2010, 05:31 PM

Hi Brad, and welcome to the forum. Those key combinations already have a set function in Excel, just not the same as in Word.

CTRL+SHIFT+< will copy the value in the cell above the current cell
CTRL+SHIFT+> will copy the value in the cell to the left of the current cell
CTRL+[ will select all cells that are referenced in the formula of the current cell
CTRL+] will select all cells that directly reference the current cell

Using the OnKey method in a macro, you could alter what these key combinations do in Excel. See here for some background and an example:

http://msdn.microsoft.com/en-us/libr...ice.11%29.aspx

Post back if you need further assistance.

**brad78703** · 01-26-2010, 06:10 PM

Paul,

Thank you for the prompt response. From the link, it appears that my two entries would be as follows:

Application.OnKey "^+{>}", "IncreaseFontSizeOneValue"
Application.OnKey "^+{<}", "DecreaseFontSizeOneValue"

However, I don’t know if these are valid Procedure names (I’m simply using the names Microsoft gave these operations in the Word Keyboard Shortcut help page). Can you help me determine the correct Procedure names?

Secondly, I don’t know how to enter these two macros in Excel so they are both permanent & universal.

Sorry to bother you with such beginner queries.