Microsoft Excel Tutorial: Excel Prank: Remove Toolbar Items for April Fool's Day.
Welcome back to the MrExcel netcast, where we bring you all the latest tips and tricks for mastering Excel. As we approach the release of Excel 2007, I can't help but feel a little nostalgic for some of the features we will be saying goodbye to. One of those features is the infamous April Fool's Day prank that has been a favorite among Excel users for years.
In this week's episode, we're going to show you how to pull off this classic prank before it's too late. As we've been discussing in our previous episodes, customizing your toolbar is a great way to personalize your Excel experience. But did you know that you can also remove items from the toolbar? That's right, you can take an entire menu item and drag it off the toolbar, leaving your unsuspecting colleague with nothing but the Help button.
But be warned, these changes are permanent and can cause quite a panic if the person doesn't know how to fix it. So before you pull this prank, make sure you know the antidote. To get the toolbar back, simply right click and choose Customize, then go to the Toolbars tab and click Reset. Trust me, your colleague will thank you for it.
Unfortunately, this prank will no longer be possible in Excel 2007 as the ability to customize toolbars by dragging and dropping has been removed. So don't wait until April Fool's Day, pull this prank now before your boss upgrades to Excel 2007 on January 30th. And don't worry, we won't tell them it was our idea. Thanks for tuning in to this week's netcast from MrExcel, we'll see you next time for more Excel tips and tricks.
Buy Bill Jelen's latest Excel book: mrexcel.com/products/latest/
You can help my channel by clicking Like or commenting below: mrexcel.com/like-mrexcel-on-youtube/
Table of Contents:
(00:00) Introduction to the MrExcel netcast
(00:16) Countdown to Excel 2007 release
(00:26) Removing items from the toolbar
(00:36) Customizing the toolbar
(01:14) April Fool's Day prank
(01:48) How to reset the toolbar changes
(02:22) Antidote for the prank
(02:32) Changes in Excel 2007
(02:45) Clicking Like really helps the algorithm
#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial
This video answers these common search terms:
Adding buttons to toolbar
Antidote for toolbar prank
April Fool's Day prank
Changing buttons on toolbar
Customizing toolbars in Excel 2003
Dragging menu items off toolbar
Excel 2007 customization
Excel 2007 toolbar customization
Quick access toolbar in Excel 2007
Removing buttons from toolbar
Restoring toolbar changes
Upgrading to Excel 2007
Join the MrExcel Message Board discussion about this video at mrexcel.com/board/threads/1152638/
One of my favorite April Fools Day tricks involves a trick that will only work with Excel 97 through Excel 2003. Since it is Friday, and your manager might be upgrading to Excel 2007 soon, try this trick out now, before the opportunity is lost. Episode 426 shows you how.
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
- Excel - Excel Prank: Remove Toolbar Items for April Fool's Day - Episode 426 ( Download)
- Excel - Excel Prank: Freak out your manager with this April Fools Day trick! - Episode 476 ( Download)
- Excel - Excel April Fool's Day Prank: Make Your Manager Crazy with this Sneaky Trick! - Episode 1200 ( Download)
- Excel - April Fools Day Trick - Episode 2040 ( Download)
- April Fools ( Download)
- Excel - Finding Old Excel Menu Commands on the New Ribbon - Episode 434 ( Download)
- Excel - Undo Toolbar Customizations in Excel: How to Fix Any Customization Issues - Episode 443 ( Download)
- Excel - Customize Your Excel Toolbars: Edit Icons and Add Webpage Shortcuts - Episode 424 ( Download)
- Excel - Never Struggle with Adaptive Menus Again! Learn How to Turn Them Off - Episode 419 ( Download)
- Excel - Dr. Fill - Everything You Wanted to Know about Excel's Fill Handle - Episode 429 ( Download)
- Excel - Joining Text in Excel Using Concatenation - Save Time with This Quick Trick! - Episode 412 ( Download)
- Excel - Master the Mini Toolbar in Excel | Excel Tutorial - Episode 413 ( Download)
- Excel - Find Total of Excel Cells Without a Formula - Episode 437 ( Download)
- Cool Trick | Make you friends FOOL with this TRICK,#cooltricks,#excel,#exceltips,#exceltricks,#viral ( Download)
- Excel - Working with Long Formulas in Excel that Expand beyond the Formula Bar - Episode 411 ( Download)
