Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a quick way to see all the list of objects currently on the sheet.
I know we can go to settings -> Sh Properties but anything else?
I was looking for a place where I can see all the list of objects currently on the sheet (coz sometimes, there are a lot of them (Hidden, Visible etc..)
Thanks
I'm not aware of any place to see all sheet objects other than in the sheet properties, objects tab. There are several ways to get there, though. You can go to settings, sheet properties. You can use control-alt-S. You can right click on the sheet and left click on properties. All of these methods seem pretty quick to me.
But if you really want one click convenience, right click on a tool bar, select customize, click on the commands tab, click on settings, and then drag the "Sheet Properties" command onto the tool bar. You can then click on the icon, and the sheet properties will pop up. Assuming you left the objects tab selected, that's one click to see the objects on the sheet.
I'm not aware of any place to see all sheet objects other than in the sheet properties, objects tab. There are several ways to get there, though. You can go to settings, sheet properties. You can use control-alt-S. You can right click on the sheet and left click on properties. All of these methods seem pretty quick to me.
But if you really want one click convenience, right click on a tool bar, select customize, click on the commands tab, click on settings, and then drag the "Sheet Properties" command onto the tool bar. You can then click on the icon, and the sheet properties will pop up. Assuming you left the objects tab selected, that's one click to see the objects on the sheet.
Thanks John.