From the course: Excel 2016: Tips and Tricks
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Use keystroke shortcuts for frequently needed numeric formats
From the course: Excel 2016: Tips and Tricks
Use keystroke shortcuts for frequently needed numeric formats
- [Voiceover] We're looking at a worksheet called Keystroke shortcuts and sure enough we're seeing quite a number of them here. And these various keystroke shortcuts have a lot in common. First of all, on most keyboards where you see the numbers one through six, just to the left of that, you're likely to see this key. And above each of these number keys, of course, you do see other symbols. Now you can probably see by just reading the screen what we're about to talk about. When you use Ctrl+Shift with these keys, you're using one of the keystroke shortcuts. In different books or on the Internet if you're looking up something about Excel, you might see a shortcut referred to, for example, as Ctrl+Shift+! or Ctrl+Shift+1. It means the same thing. Now, in row seven we simply see numbers entered here, as if they were typed that way. If I have an entry like this and I use General format, that's the native format, the default format in Excel. Nothing's going to change here. You probably…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
-
-
-
-
Use keystroke shortcuts for frequently needed numeric formats6m 29s
-
Accentuate data with alignment tools6m 2s
-
Add a color background to every 5th row in a range5m 40s
-
Use conditional formatting based on comparison criteria5m 13s
-
Use conditional formatting to highlight formula cells only2m 54s
-
Create custom formats: Dot leaders and more6m 1s
-
Use special formats for times over 24 hours4m 9s
-
Add/remove strikethrough and borders with keystroke shortcuts3m 34s
-
Quickly format phone and SS numbers3m 54s
-
-
-
-
-