How To Select Separate Columns In Excel

Selecting cells is an of import skill in Excel. Almost all of the information in Excel is saved in a prison cell or prison cell range; and so before yous tin enter, edit, or format text, you first need to know how to select a cell or cell range.

Select a Cell

It's easy to select a single cell:

1. Click the jail cell you want to select.

   

   To see which cell is selected, look at the shaded column number and row letter. You lot can likewise run across what cell is selected by looking at the name box.

Select Rows

1. Click the heading for the row you lot desire to select.
2. To select several rows, click and drag from the starting time row heading to the last row heading.

   

You lot tin can also select multiple rows by selecting a row header, pressing and holding the Shift key, and pressing the Upwardly or Downwards arrow keys to select additional rows.

Select Columns

1. Click the heading for the column you want to select.
2. To select several columns, click and drag from the kickoff column heading to the last column heading.

   

Y'all can too select multiple columns by selecting a column header, pressing and holding the Shift key, and pressing the Left or Correct pointer keys to select additional columns.

Select a Cell Range

A cell range is a grouping of cells that spreads over multiple rows or columns.

1. Click the showtime jail cell you want to include in your range.
2. Drag to the last cell yous want to include in your range.

   

You can likewise select a cell range by selecting the first cell of the cell range, pressing and holding the Shift key and selecting the last cell of the cell range.

Select an Unabridged Worksheet

You tin can even select the entire worksheet in Excel.

1. Click the Select All push button.

   

   Press Ctrl + A.

Excel selects the entire worksheet.

Select Non-Adjacent Cells

All the previous selection methods can be used to select cells that are adjacent, or next to each other. Nevertheless, sometimes you may need to select multiple cells or prison cell ranges that are separated. Here's how to do that...

1. Click the showtime jail cell or prison cell range.
2. Concord down the Ctrl key and select any non-adjacent cells or jail cell ranges.

   

FREE Quick Reference

Click to Download

Free to distribute with our compliments; we hope you volition consider our paid training.

Source: https://www.customguide.com/excel/how-to-select-multiple-cells-in-excel

Posted by: gallowaycomen2001.blogspot.com

Share this post