how to select multiple objects in excel for mac 16.13

Select Multiple Objects In Excel 16.13 How To Setup The

For example, you may find yourself selecting the text placeholder when you want to select an image.

But when you move the text placeholder to select the image, getting the placeholder back in its exact location is difficult.

Continue to press the Tab key as PowerPoint selects object after object until the object you need is selected.

So I dont have to keep cycling using Tab and risk selecting wrong objects, Ill often use Send to Back (not Send Backward) on the covering object to temporarily have access to the covered objects.

When Im done, I select the large object and Bring to Front again.

You can even rename them so that you can easily find them later.

I was trying the tab technique and it wasnt working, then I realized Im in object edit mode.

So in case anyone else is having a similar issue, first press the ESC key to exit object edit mode and the press tab to cycle through all the objects on the slide.

I used to move images out the way in order to get to the image in the background to modify it.

These techniques will help you save time when working with reports and dashboards that contain multiple objects on the same worksheet.

Which option you choose might depend on whether you want to select just some of the shapes on your worksheet or all of them, or whether you are more comfortable with keyboard shortcuts versus using the ribbon menu.

This allows us to pick and choose which shapes we want to manipulate.

Using the Shift key instead of Ctrl will produce the same outcome.

Otherwise you might start editing the shape instead of selecting it.

Hold the Ctrl key, then press the A key to select all of the shapes on the sheet.

Because this option selects all of the shapes on our sheet, if there are certain shapes we want to exclude, we would need to use the Ctrl key, as in Option 1, to deselect the shapes we dont want included.

Youll find that option when you right-click on Selection Pane in the dropdown.

This is especially convenient if our worksheet is large in area and we dont want to hunt for particular objects.

The pane also gives us the ability to hide and unhide shapes, or to bring forward shapes that are overlapped by other objects.

This is also found under the Find Select dropdown menu on the Home tab of the ribbon.

You can highlight by clicking at one corner of your desired area, holding the left mouse button down while moving to the opposite corner, and then releasing the button.

All shapes that are completely inside the area youve drawn will then be selected.

You can do this by by clicking again on the Select Objects option in the Find Select menu.

Select Multiple Objects In Excel 16.13 How To Setup The

Check out my post on how to setup the Quick Access Toolbar for more details.

Click on the Objects radio button to select all of the objects on the sheet.

But even if youve selected a chart element, holding Ctrl and clicking anywhere on another chart will select the whole chart of the element that was initially selected and the whole second chart which was selected.

No need to try to land the mouse on the narrow outline of a chart.

How To Select Multiple Objects In Excel For Mac 16.13