Selecting All Sheet Cells in Microsoft Excel 2010

In this article, we will learn how we can select all sheet cells in Microsoft Excel 2010.

We always use up arrow key or down arrow key or mouse scroll for navigating to the end or start in the Microsoft Excel 2010 range of the sheet. It is helpful when Excel has a small range which might be a range of A1:A10. It is easy to use up arrow key or down arrow key when we want to select the whole data instead of particular cell or particular range and column.

Let’s take an example to understand how we can select all sheet cells.

We have data in range A1:C20 in whichcolumn A contains Name, column B contains Score and Column C contains percentage.Now, we want to select all sheet cells.

 
img1
 
To select all sheet cells, follow below given steps:-

  • Place your mouse in the first cell A1.
  • Press the key Ctrl+A on your keyboard.

 
img2
 

  • The whole data will get selected.
  • To select the all cells in sheet, press Ctrl+A+A on your keyboard.

 
img3
 
Another way to select the data is by pressingCtrl+Shift+* on your keyboard.

 
img4
 

  • Press the key Ctrl+G, and ‘Go To’ dialog box will appear.

 
img5
 

  • Click on Special.
  • Go to Special dialog box will appear.

 
img6
 

  • Click on Current region, and then click on OK.

 
img7
 

  • The Data will get selected.

 
img8
 
 

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube