Selecting Special Cells in Excel

Selecting special cells in a sheet, for example, cells containing Constants, Formulas, blank cells, and more, enables you to copy, move, delete, color, fill, or protect these cells.

We use ‘Go to special’ tool to select the constants, formulas, blank cells etc.

Let’s take an example and understand:-

We have credit card’s payment data in which we have details about payment received or not.

 

image 1

 

How to select constant?

In constant, we consider numbers, text, logical, or errors. To select constant, follow the steps below:-

  • Press the shortcut key to open ‘Go to Special’ dialog box Ctrl+G.
  • ‘Go to’ dialog box will appear.

image 2

 

  • Click on Special button.
  • ‘Go to Special’ dialog box will open.

image 3

 

  • Click on Constants.
  • All constants will get active.

image 4

 

  • Click on ‘ok’.
  • Entire data will be selected except the blanks and formulas.

image 5

 

How to select Comment?

To select the comment containing cells follow the steps below:-

  • Press the shortcut key to open ‘Go to Special’ dialog box Ctrl+G.
  • ‘Go to’ dialog box will appear.

image 6

 

  • Click on Special button.
  • ‘Go to Special’ dialog box will open.
  • Click on Comments.

image 7

 

  • Click on ‘ok’.
  • All cells containing comments will get selected.

image 8

 

How to select Formula containing cells?

To select formula containing cells, follow the steps below:-

  • Press the shortcut key to open ‘Go to Special’ dialog box Ctrl+G.
  • ‘Go to’ dialog box will appear.

image 9

 

  • Click on Special button.
  • ‘Go to Special’ dialog box will open.
  • Click on Formulas.

image 10

 

  • Only formula containing cells will get selected.

image 11

 

How to select objects?

To select the objects follow the steps below:-

  • Press the shortcut key to open ‘Go to Special’ dialog box Ctrl+G.
  • ‘Go to’ dialog box will appear.

image 12

 

  • Click on Special button.
  • ‘Go to Special’ dialog box will open.
  • Click on Objects.

image 13

 

  • All the available objects in the sheet will get selected. Now we can move them, delete them and copy them.

image 14

 

In this way, we can use ‘Go to Special’ option to select the objects, blanks and many more in Microsoft Excel.

 

image 48

If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com

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