Suddenly, all buttons, shapes, SmartArt, WordArt is missing from the workbook.
All of the Insert, Illustrations is greyed out.
What happened to all of my shapes in Excel?
What happened to all of my images in Excel?
Where did it go? What happened?
There is a good chance that someone clicked Ctrl+6 to toggle Show/Hide Shapes
All of the Insert, Illustrations is greyed out.
What happened to all of my shapes in Excel?
What happened to all of my images in Excel?
Where did it go? What happened?
There is a good chance that someone clicked Ctrl+6 to toggle Show/Hide Shapes
Transcript of the video:
Learn Excel from MrExcel, Episode 2219: Show or Hide All Shapes.
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
Today's question sent in by me.
I had a workbook, I had a whole bunch of shapes in it, and all of a sudden, BAM! all the shapes were gone.
My macro buttons were gone, everything was gone.
I'm like what happened?
How do they--how did they-- delete all those shapes like did one whole tree of the XML get just cut off?
You know, I use a trick here all the time.
I do strikethrough with Ctrl+5, right?
So Ctrl+5 will toggle strikethrough on and off, on and off.
Apparently, I missed-- I pressed Ctrl+6, never used Ctrl+6, Ctrl+5 is strikethrough, Ctrl+6 is hide all the shapes.
Now, if I go to Find and Select, I see these are grayed out, right?
Really, really annoying.
And I think even the tools to Insert New Shapes are all grayed out.
Like, all of a sudden, Excel pretends like it has no idea what the heck a shape is.
So all kinds of bizarre behavior here, just because I press Ctrl+6 inadvertently when I meant to press Ctrl+5.
And it happens to all the sheets.
Like, here's my great title card-- all gone.
Ctrl+6 to get everything back.
I didn't even know that was a keyboard shortcut-- seems really dangerous to have that right next to Ctrl+5.
But, there you are, Ctrl+6 to hide all shapes, BAM! everything's gone; press it again, everything comes back.
If you're watching this video, you probably searched for "what happened to all my shapes".
That's the story.
While you're at it, while you're here, let me try and sell you this book: "MrExcel LIVe, The 54 Greatest Excel Tips of All Time." Check out that "I" in the top right hand corner.
Episode wrap-up: Suddenly all buttons, shapes, SmartArt, word art, is missing from the workbook.
Where'd it go?
What happened?
Let me guess, you were just trying to cross something off with Ctrl+5 and there's a good chance you accidentally pressed Ctrl+6.
Just press it again, everything will come back.
To download the workbook from today's video, visit the URL in the YouTube description.
See you next time for another netcast from MrExcel.
Hey, here's a bonus outtake for you.
Why is Ctrl+5 strikethrough?
Think about back in the old days when you used to take inventory with a mechanical pencil making remarks-- that's one, that's two, that's three, that's four-- it's the fifth one, Ctrl+5, that strikes out the other ones.
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
Today's question sent in by me.
I had a workbook, I had a whole bunch of shapes in it, and all of a sudden, BAM! all the shapes were gone.
My macro buttons were gone, everything was gone.
I'm like what happened?
How do they--how did they-- delete all those shapes like did one whole tree of the XML get just cut off?
You know, I use a trick here all the time.
I do strikethrough with Ctrl+5, right?
So Ctrl+5 will toggle strikethrough on and off, on and off.
Apparently, I missed-- I pressed Ctrl+6, never used Ctrl+6, Ctrl+5 is strikethrough, Ctrl+6 is hide all the shapes.
Now, if I go to Find and Select, I see these are grayed out, right?
Really, really annoying.
And I think even the tools to Insert New Shapes are all grayed out.
Like, all of a sudden, Excel pretends like it has no idea what the heck a shape is.
So all kinds of bizarre behavior here, just because I press Ctrl+6 inadvertently when I meant to press Ctrl+5.
And it happens to all the sheets.
Like, here's my great title card-- all gone.
Ctrl+6 to get everything back.
I didn't even know that was a keyboard shortcut-- seems really dangerous to have that right next to Ctrl+5.
But, there you are, Ctrl+6 to hide all shapes, BAM! everything's gone; press it again, everything comes back.
If you're watching this video, you probably searched for "what happened to all my shapes".
That's the story.
While you're at it, while you're here, let me try and sell you this book: "MrExcel LIVe, The 54 Greatest Excel Tips of All Time." Check out that "I" in the top right hand corner.
Episode wrap-up: Suddenly all buttons, shapes, SmartArt, word art, is missing from the workbook.
Where'd it go?
What happened?
Let me guess, you were just trying to cross something off with Ctrl+5 and there's a good chance you accidentally pressed Ctrl+6.
Just press it again, everything will come back.
To download the workbook from today's video, visit the URL in the YouTube description.
See you next time for another netcast from MrExcel.
Hey, here's a bonus outtake for you.
Why is Ctrl+5 strikethrough?
Think about back in the old days when you used to take inventory with a mechanical pencil making remarks-- that's one, that's two, that's three, that's four-- it's the fifth one, Ctrl+5, that strikes out the other ones.
