From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Keyboard shortcuts for numeric formats

Keyboard shortcuts for numeric formats - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Keyboard shortcuts for numeric formats

“

- [Person] Excel has seven different 2 numeric keystroke-formatting shortcuts. 3 They're listed on this worksheet over 4 in columns N-through-T. 5 They all use the control and shift keys, 6 in combination with these seven keys 7 that we see on most keyboards across the top, 8 just below function keys on most keyboards. 9 And by the way, sometimes, 10 when you're referring to these in a book, 11 or you see them at an online site, 12 they're likely to be listed. 13 For example, shortcut for currency. 14 They're listed as either control-shift-four, 15 or control-shift-dollar-sign. 16 Makes no difference how you say it, 17 we're talking about the same key. 18 For example, four and dollar-sign are on the same key. 19 Now, let's show how these are used in different ways. 20 And by the way, two of these, the currency and also the... 21 Entering number one, the exclamation point, 22 do have a similar correspondence 23…

Contents