Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.

How to Select Multiple Cells in Excel – Excelchat

When we need to apply certain formatting style, copy a range of data, select different ranges of data to insert Excel Charts, then selecting multiple cells becomes vital. We can select a range of cells, adjacent and nonadjacent, specific cells, multiple rows and columns using different techniques.

Figure 1. Selecting Multiple Cells

How to Select Multiple Cells

We need to select multiple cells in Excel in different ways and there are different methods to highlight cells. We need to learn how to select multiple cells in the below scenarios.

How to Select Specific Cells

We can select specific cells to highlight for applying certain formatting or copying those cells. Suppose we want to select blank cells and format them with the Yellow fill.

  • Simply press and hold the Ctrl key and click the specific cells one by one with the mouse to highlight.

Figure 2. Selecting Specific Cells

  • On the Home tab, go to Font group, click on Fill element and select the Yellow color.

Figure 3. Applying the Yellow Fill

Select a Range of Cells

Selecting multiple cells in a range is a very common task. The range could be adjacent or nonadjacent. We can achieve in the following way;

  • Select the first cell of the range, press and hold the mouse left-click and drag it to an adjacent range of cells to highlight.

Figure 4. Selecting Adjacent Range of Cells

  • To select the nonadjacent range of cells press and hold the Ctrl key and select the nonadjacent range of cells to highlight.

Figure 5. Selecting Nonadjacent Range of Cells

Select Multiple Cells in Contiguous Range

A contiguous range consists of adjacent cells filled with values in a row or column. Suppose there are the contiguous and non-contiguous cells in a column and we want to select the multiple cells in a contiguous range.

  • Using Ctrl + Shift + Arrow Key we can select multiple cells in the contiguous range. Keep the cursor in the first cell of the column (with or without header) and press  Ctrl + Shift + Down Arrow Key

Figure 6. Selecting Cells in Contiguous Range

Select Multiple Cells From First to the Last Cell

If we need to quickly select multiple cells from first to the last cell in a large data set or table then use the following short cut method.

  • Keep the cursor in the first cell of a dataset and press Ctrl + Shift + End keys simultaneously to select multiple cells from first to the last cell.

Figure 7. Selecting Multiple Cells

Instant Connection to an Expert through our Excelchat Service

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

Leave a Comment

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc