Ask Mac Questions and Get Answers from Experts ASAP
To select all objects on the sheet, click Edit > Go To > Special > Objects
Hope this helps
There should not be any difference between the two versions in this regard
Is this what you have in mind. If not, could you send me a screenshot
Ok go to http://www.wikisend.com/ and upload the image file (no need to signup) then copy the "File ID" number (or the download link) that you will be given and paste it here in your reply.
I see what you mean
In later versions of Excel the select object tool is in the Find & Select button under the Home tab. Just choose Select Object from there and then drag the mouse across the objects that you want to select
Hope this helps. Let me know if you have any questions, and thank you for clicking Accept if you are satisfied with the solution
You are still up?
Ok this should help you locate the Find & Select option
Ok I will try to find another resource/image. In the meantime don't forget to click Accept as this is the only way I get credit for helping. Thanks
Well I did some additional research on this but it seems that Microsoft for some strange reason has not included the select object tool in Office 2011.
However you should be able to add it using the Customize Toolbars feature (View > Toolbars > Customize Toolbars) as shown in this video
If you still can't get it I can write a macro that will automate this task (i.e, select all objects in the selected range). Let me know
I can set up the macro on a sample file and send it to you but you will need to copy it and adapt it to your actual file. If however you're not familar with macros I suggest that you send me your file so I can set it up on directly.
Let me know
I can only send you the code in an "xlsm" file with a button applicable to that sheet only. So you will need to know to copy the macro with the button to each of your other sheets, which will not be easy unless you know how to do it. That's why I asked you to send e your file
I haven't heard back from you, so in order not to leave the issue open I went ahead and wrote the macro
Here is the file with the macro
Please note that since there is a macro in the file you need to make sure that you have your Excel Options configured so that macros are allowed to run, otherwise nothing happens when you click the button. If you need assistance in this regard please let me know,.and provide the version of Excel you are running