Subscribe for access to this FREE e-learning mini-course!


Your First Name:


Your Surname:


Your Email Address:



Subscribe
Close


Small logo
Hamburger menu
Menu
bookings:   0333 6000 111
service:       0333 6000 555
    or           
Free Video Tutorials : Excel Navigation
Free Video Tutorials : Excel Navigation
Home Quick Course Finder Microsoft Software Microsoft Excel Excel Resources
Why Am I Selecting Multiple Cells In Excel?
Search

EXCEL NAVIGATION: WHY SELECTING MULTIPLE CELLS?

See how to fix accidental selection of multiple cells and how to use multiple selection in your work with Excel

Background information and resources for Excel courses that we hope you find useful

Being able to select multiple cells in Excel is vital when making formatting changes, selecting cells for a formula, highlighting data for a chart, and much more. To highlight multiple cells, you can simply click and drag over the region you wish to select.

But sometimes Excel selects multiple cells and you are not trying to do this. You click in the spreadsheet and it starts highlight cells, even when you aren't dragging around. In this case, the most common issue is that Extend Selection mode is on. This is a feature where you can select multiple ranges using the arrow keys. It can easily be turned off (or on) using the F8 function key on your keyboard.

So if you find that Excel appears to be selecting multiple cells on its own then pressing the F8 key will fix the problem in almost every case.

WHY DO WE SELECT MULTIPLE CELLS?

While we're on the subject, let's look at highlighting ranges of cells, including non-adjacent cells. For example, let's say you want to format a few cells with a certain border format and cell colour. Instead of clicking on the cells and formatting them one by one, here's what you can do.

Step 1. To multi-select the cells, click the first cell and holding down the Ctrl key, click on all the other cells that you need.

Why Do We Select Multiple Cells?

Step 2. Make your changes (e.g. click on the Fill Color button and change the font) and all the cells will be updated at the same time.

Excel Navigation: Why selecting multiple cells?

SELECTING MULTIPLE CELLS FOR A CHART

Another thing we use this feature for is selecting a range of "non-adjacent" cells and plot them onto a Chart.

Example

Step 1. In this case, I need to plot Pete and Ian's data so I select the monthly data plus Pete's data as normal with the mouse and then hold Ctrl and select Ian's name and data.

Step 2. A quick way to then plot this into a chart, is to simply press F11.

Selecting Multiple Cells for a Chart
WE HOPE YOU FOUND THIS USEFUL

Want to see how we can really help you?

LINKS TO MORE ...

Main Excel Resources Page

Excel Resources

Video tutorials & articles, and templates to help you work better in Excel

      Click to view

 

Video Tutorials - Navigating Excel

Video Tutorials - Navigating Excel

Navigate and control the layout of your spreadsheets to make working with Excel much easier

Click to view

Excel Navigation: How to hide sheets

Excel Navigation: How to hide sheets

Learn how to hide worksheets when working with Microsoft Excel

      Click to read more

 

Excel Navigation: How to remove blank rows

Excel Navigation: How to remove blank rows

Useful tricks to help you remove blank rows in Microsoft Excel

      Click to read more

Excel Navigation: How to lock cells

Excel Navigation: How to lock cells

Learn how to lock cells in Microsoft Excel

      Click to read more

 

Excel Navigation: How to hide the ribbon

Excel Navigation: How to hide the ribbon

Learn how to hide the ribbon in Microsoft Excel

      Click to read more

GET IN TOUCH

Call us on:
0333 6000 111

   You can Email us direct (You'll usually get a response within 2-3 working hours)
   Or fill out the details below and we'll be in touch very soon:
SEND MESSAGE

WHY AM I SELECTING MULTIPLE CELLS IN EXCEL?

We can enhance your skills with courses for Microsoft Excel spreadsheets at any of our twelve training centres UK wide, or we can come to your offices: if you have groups of three or more staff who need training, this is a very convenient, flexible and cost effective option. Moreover, most of our excel courses are 1 day, which keeps "out of office" periods for attendees to a minimum.

We have been delivering Microsoft Excel course all over the UK since 1995 and have continually developed our philosophy of high quality, flexible and results-driven provision of courses for Excel to ensure constantly improving standards of quality.   So you can be confident that we have the expertise, and the experience, to give you a great return on your investment in Free Video Tutorials : Excel Navigation.

Why not contact us today to see how we can help with providing your MS Excel classes ?


Stay in touch

Stay In Touch!

Google+
LinkedIn
Twitter
FaceBook
YouTube

Contact Details

Activia Training

Locations Address: Head Office, Regus House,
268 Bath Road
Slough, Berkshire SL1 4DX

Phone Sales:           0333 6000 111

Service:       0333 6000 555

Accounts:   0333 6000 777



Back to top