How To Use "Select Object" Selecting All The Rectangular Region Of Pictures And Deleting | Exceltip2day

Hello there.

I'm Michael Leng. Today, in my blog "Exceltip2day", I'm going to talk about:

How to use the “Select Object” tool in Excel?

Tip Quiz

What is the shortcut key to select the entire column?

The “Select Object” tool is a very good function to handling all about the object like pictures, shapes,
SmartArt…

In this article, I am going to tell you how to use the “Select Object” for SELECTING multi-objects and delete them all.

Do the following:

• On the ribbon bar, click the “Find & Select”

• Click over the “Select Object” tool.

• Press and hold down the SHIFT button.

• Drag mouse to select all over the objects you want.

• Press the “Delete” button.

To be more understood, you can see all the methods step by step through all the images respective below.

Figure no.1 Click the "Select Object."

Figure no.2 Drag over the objects.

Figure no.3 All objects are selected.

Figure no.4 Empty cell after deleting.

Tip Answer

 a. It's "Alt" + "Spacebar".

 b. It's "Ctrl" + "Spacebar".

 c. It's "Shift" + "Spacebar".

 Answer: b. Well done! 

Check: Excel Shortcut Keyboard Selecting Entire Column(s)

Link recommended👉 : Shortcut Keys How To Fixing Monitor Screen Accidentally 'Upside Down'

Link recommended👉 : English Numbers In Words 1 to 1000000

Thanks for reading.

Bye,

Posted by: Michael Leng



I've known, then I've grown.

See more articles:

• How To Format The Entire Cells In A Workbook With Just Only A Single Click
• Trick To Copy With “Format Painter” With A Single Click But Unlimited Multiple Paste
• Compare Percentage Result Between Excel Formula [Average] And [Averageif Exclude "0"]