Look Who it Was Random video

Excel - Selecting Regions, Undoing Actions, & Formatting Subtotals - Episode 1009

686 views · Published 7 May 2009 · 2:51 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial:  Selecting Regions, Undoing Actions, & Formatting Subtotals.

Welcome to another episode of the MrExcel netcast! I'm Bill Jelen and today we have three quick tips that came up in recent seminars. These tips may be short, but they are definitely worth knowing. So, let's dive right in and see if we can solve some common Excel problems.

First up, let's talk about shortcut keys. We all know that CTRL+A selects all cells in a worksheet, but did you know that if you select a cell within a range of data and press CTRL+A, it will select the entire region? And if you press CTRL+A a second time, it will select the entire worksheet. This is a great time-saving tip that I personally use all the time. Another shortcut key that you may not be aware of is ALT+Backspace, which is an alternative way to undo your last action. Thanks to one of our seminar attendees, Derek, for sharing this tip with us.

Next, let's talk about applying special formatting to subtotal rows. This can be a bit tricky, but here's a neat trick that will make it easier. First, make sure to exclude the Grand Total row when selecting your subtotal rows. Then, press ALT+; to select only the visible cells. Now, go to Format Cells and choose a top and bottom border. This will apply the formatting to just the subtotal rows, without affecting the Grand Total row. It's a small detail, but it can make a big difference in the appearance of your data.

Lastly, I want to thank all the attendees from our recent seminars for sharing these tips with us. As always, these tips and more can be found on the Excel master pit. Thanks for watching and be sure to tune in next time for another netcast from MrExcel. Don't forget to like, comment, and subscribe for more Excel tips and tricks. See you next time!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


3 fast tips from my recent seminar in Louisville Kentucky: Different way to select current region; different way to Undo; How to overline and underline subtotals. Episode 1009 shows you how.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Table of Contents:
(00:00) Introduction to MrExcel netcast
(00:14) Three fast tips from recent seminars
(00:24) Shortcut keys: CTRL+A and ALT+Backspace
(00:43) Applying special formatting to SUBTOTAL rows
(02:21) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Applying special formatting to subtotal rows in Excel
Automatic subtotals and formatting in Excel
Excel master pit for advanced Excel users
Excel shortcut keys for selecting cells and regions
Fast way to undo in Excel using shortcut keys
Formatting subtotal rows in Excel
Formatting top and bottom borders in Excel
MrExcel netcast on Excel tips and techniques
Selecting visible cells only in Excel
Tips and tricks for Excel from recent seminars
Using ALT+Backspace to undo in Excel
YouTube tutorial on analyzing data and creating pivot tables


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152396/

More from this channel