Skip to content

Excel

How to restore the missing toolbar or ribbon in Microsoft Office (Word, Excel) – Video Tip

Recently, I have been answering the question of how to restore a missing toolbar or ribbon from Microsoft Office tools like Word, Excel, or PowerPoint. This tip works for any of the Office tools 2007 or newer. Usually, the toolbar goes missing because of an errant click or keyboard combination. In the video below, I show how to restore the… Read More »How to restore the missing toolbar or ribbon in Microsoft Office (Word, Excel) – Video Tip

Solution to Microsoft Outlook 2007 or 2010 not opening Word or Excel Attachments

This particular problem has come a few times lately, so I thought I better write out the solution for the website for both my memory and for others who might have the problem. Here’s what the problem looks like: Outlook 2007 or Outlook 2010 users try to open a Microsoft Word or Excel document and cannot do so. Usually this… Read More »Solution to Microsoft Outlook 2007 or 2010 not opening Word or Excel Attachments

Microsoft Excel tip that will change your life – Video Tip

If this tip doesn’t change your life, it can change your cube mates life or someone’s life who uses Excel a lot.

This short (4 minute) video demonstrates the power of knowing how to quickly navigate around a spreadsheet without using the vertical or horizontal scroll bars.

Even if you don’t use Excel, watch the video…it is like a magic show you might see in Las Vegas.

Customize Office Toolbars

Starting with Microsoft Office 2000 and the XP version afterward, software engineers in Redmond decided that showing an entire menu in Word, Excel or any of the Office programs would confuse software users.

Instead of showing the entire menu when clicking on File, Edit, Format, etc, from the menus, we are presented with an abbreviated menu showing only two or three options. In order to view the entire menu, we can either wait a few seconds (who has that kind of time) or click on the double arrows at bottom of the menu.

Thankfully, you can reverse this process, if you wish. You can restore order to the Office menu system and view all the menus with a single click. Follow these steps for either Office 2000 or Office XP products (including Word, Excel, PowerPoint, Front Page, Access, Outlook (not Express), and Publisher):