Channel: MrExcel.com

Category: Howto & Style

Tags: excelselection pane in excelf2 to bring selected shape into view in excellost a shape in excelselect all shapes in excelmrexcelselect many objects in excelhide all shapes in excelfind a lost shape in excelmicrosoft excelbill jelenfind a lost slicer in excel

Description: Today's question from Ken: I've lost a slicer. I know it is somewhere on the worksheet, but how can I find it? Thanks to Lou Pham, we have an answer. Use Home, Find & Select, Selection Pane. Select the object. Press F2 to bring it back into view. Also covered today: You can format a drawing shape and then set AutoShape Defaults on the right-click menu to change the color of future shapes. Right-click the Shape in the gallery and choose Lock Drawing Mode to create many shapes with a single click for each shape. If a worksheet becomes super-slow, check Home, Find & Select, Selection Pane to see how many shapes there are! With 1400 shapes to draw, Excel becomes very slow. Use Hide All to make the spreadsheet fast again If the active cell is scrolled out of view, Ctrl+Backspace brings it back again Ken: Lost a shape. Display Selection Pane. Click in Selection Pane to select shape. Press F2 to bring it into view. Table of Contents (0:00) Drawing many shapes quickly in Excel (0:24) Slow worksheet due to 1400 shapes and Hide All (1:17) How to find a lost slicer in Excel (1:58) Ctrl+Backspace in Excel (2:39) F2 to bring a shape back in to view (3:43) Using Select Objects to select many objects in Excel (3:56) Wrap-up