HOW TO Select cell contents in Excel

1 min


0

Excel for Office 365 Excel for Office 365 for Mac Excel 2019 Excel 2016 

In Excel, you can select cell contents of one or more cells, rows and columns.

Note: If a worksheet has been protected, you might not be able to select cells or their contents on a worksheet.

Select one or more cells

  1. Click on a cell to select it. Or use the keyboard to navigate to it and select it.
  2. To select a range, select a cell, then with the left mouse button pressed, drag over the other cells.Or use the Shift + arrow keys to select the range.
  3. To select non-adjacent cells and cell ranges, hold Ctrl and select the cells.

Select one or more rows and columns

  1. Select the letter at the top to select the entire column. Or click on any cell in the column and then press Ctrl + Space.
  2. Select the row number to select the entire row. Or click on any cell in the row and then press Shift + Space.
  3. To select non-adjacent rows or columns, hold Ctrl and select the row or column numbers.

Select table, list or worksheet

  1. To select a list or table, select a cell in the list or table and press Ctrl + A.
  2. To select the entire worksheet, click the Select All button at the top left corner.

Note: In some cases, selecting a cell may result in the selection of multiple adjacent cells as well. For tips on how to resolve this issue, see this post How do I stop Excel from highlighting two cells at once? in the community.

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.


Like it? Share with your friends!

0
Sande Kennedy

Sande Kennedy is the founder of SandeKennedy.com & Kenyans247.com He is a Kenyan-based Internetprenuer,blogger Political Activist,informer who has an interest in politics, governance, corporate-fraud and human-interest. Kindly drop me a note if you feel aggrieved on any matter that you would want to be highlighted. Twitter @itssandekennedy , Instagram @itssandekennedy WhatsApp: +254791890826 Read More about me here

0 Comments

1
Would you like to get published on this Popular Blog? You can now email Sande Kennedy any breaking news, Exposes, story ideas, human interest articles or interesting videos on: info@sandekennedy.com. Videos and pictures can be sent to +254 791890826 here on WhatsApp by clicking this send button
Powered by