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.
How to select constant?
In constant, we consider numbers, text, logical, or errors. To select constant, follow the steps below:-
How to select Comment?
To select the comment containing cells follow the steps below:-
How to select Formula containing cells?
To select formula containing cells, follow the steps below:-
How to select objects?
To select the objects follow the steps below:-
In this way, we can use ‘Go to Special’ option to select the objects, blanks and many more in Microsoft Excel.
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
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.
