From the course: Excel 2016: Tips and Tricks
Unlock the full course today
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Add/remove strikethrough and borders with keystroke shortcuts
From the course: Excel 2016: Tips and Tricks
Add/remove strikethrough and borders with keystroke shortcuts
- [Voiceover] There are two quick keystroke shortcuts for using borders and strikethrough. I wanna put a border on just the cells in this worksheet right here, called Profits, on the numbers right here. These are the only cells in this worksheet that are not formulas. I wanna put a border around them. And I can press Ctrl + Shift + 7. Could also be expressed as Ctrl + Shift + &. Now many times when you apply borders, you don't see them right away if the cells are highlighted so I'll click outside the highlighted area and now I can see the border. This is a thin perimeter border, and that's what Ctrl + Shift + 7 does. If I want a border around these down here, I'll highlight them, Ctrl + Shift + 7, once again click outside of it. You certainly have options for other border features, and if these cells should have a thicker border, you can certainly, by way of the Font group on the home tab, click the border drop arrow, choose some other options. How about a thick outside border. Or…
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
-
-
-
-
-