Quick Tips: Multiple Selections in Excel

by | Jun 16, 2015

Here’s another one of my time-saving Microsoft Excel tips. If you need to make changes to several parts of your spreadsheet at once, don’t highlight each one and make the changes individually. Make multiple selections at one time instead!

In this example, I want to select the labels from my Expenses column and the totals from the Totals column.

First, I’ll click on A4 and drag down to A9 to make my first selection.

Making Multiple Selections, first selection

Next, I’ll hold down the Control key, click on I4, and drag down to I9 to make my second selection. On a Mac, you would use the Command key.

Now, two separate parts of the worksheet are highlighted at the same time, so I can make them bold, shaded, or take action on them just once, instead of performing the steps twice.

Making Multiple Selections, second selection

Watch me demonstrate how to make multiple selections in Excel spreadsheets in this clip from my Learn Excel in 3 Hours Flat course.


If you want more Excel tips and tricks, take the full online course, Learn Excel in 3 Hours Flat, on Udemy.com. You’ll not only learn all the practical tools you’ll use on the job everyday, but also how to be more productive!

Act now and get the course for only $59 $49.

Take this Course

Related Posts

[related_posts limit=”4″ image=”100″]

About Alicia Katz Pollock

Recently named one of America's Top 50 Women in Accounting, Alicia is a leading expert in QuickBooks Online training with a Masters in Teaching and decades of business consulting. She offers a range of tailored resources from self-paced courses to personalized coaching. Known for her patience and commitment, Alicia simplifies QuickBooks for clients, helping them achieve their financial management goals with ease.

Comments

0 Comments

Submit a Comment

Your email address will not be published. Required fields are marked *