Excel shortcut to set font size and bold

I have an Excel budget spreadsheet that as items (cells with numbers) are paid, I make the font bold and size 14.

Is there a way to create a shortcut to do this with one keyboard move instead of right-clicking, choosing font size 14 and then clicking on bold?

I am using Excel 2007.

2 Answers

Highlight necessary cells and use Ctrl+B to make the text bold. As for changing the font size use the Home > Font tab. Or you could use Ctrl+Shift+P to bring up the format cells > font box. Hope this helps. :)

You can also use a Format Painter.

Select the cell with the desired formatting and click on the Format Painter icon in your toolbar. Than click on the cell that you want to apply the formatting to.

Or as Máté Juhász suggested, you can create you own macro. One drawback is that this macro is going to be available only in the Excel spreadsheet where the macro is set up (obviously).

Here's a macro sample:

 Sub Bold14PtMacro() ' ' Bold14PtMacro Macro ' ' Keyboard Shortcut: Ctrl+e ' With Selection.Font .Name = "Calibri" .Size = 14 .Strikethrough = False .Superscript = False .Subscript = False .OutlineFont = False .Shadow = False .Underline = xlUnderlineStyleNone .ThemeColor = xlThemeColorLight1 .TintAndShade = 0 .ThemeFont = xlThemeFontMinor End With Selection.Font.Bold = True End Sub