Archive | March, 2016

Tame your computer – menu manipulation

25 Mar

Since 1995 Microsoft has developed 11 versions of Internet Explorer. Back in October 2006 they released version 7 and decided to hide the classic menu bar, normally located at the top of the window. They did this to increase the page viewing space. Great, but there might be times you want to use the File, Edit, View, Favorites, Tools or Help menus, if only to find out what version you are using. (Select About Internet Explorer from the Help menu.)

Here’s how:

  1. Launch Internet Explorer, as normal
  2. Press the ALT key (next to your spacebar)

When you press ALT, the menu bar will be displayed temporarily. If you prefer to have the Menu bar displayed by default you can do the following:

  1. Launch Internet Explorer, as normal
  2. Press ALT
  3. Press V (for View)
  4. Press T (for Toolbars)
  5. Press M (for Menu)

Oh, and as the title of the tip implies … this works for Firefox too. Google Chrome, however, has no menu bar; actions such as Edit and Help can be found when you click on the button in the upper-right corner of the screen. The button looks like a wrench or three horizontal lines, depending on what version of Chrome you use (which you can find out when you click on the button).

To find out how to quickly hide toolbars to increase page viewing space see Tip 173.

Tame your computer – come out of hiding

16 Mar

In Excel you can temporarily reduce the number of rows or columns that appear in a worksheet by hiding them. When you hide any part of a workbook, the data is only removed from the view of that workbook; it is not removed from the workbook itself.  If you save the workbook and close the file, any information previously hidden will remain hidden when you reopen the file.

So what if you want to ‘unhide’ your hidden rows or columns, but cannot find them? After all, these days the number of rows is 1,048,576 and there are 16,384 columns (not that I’m counting) so you’ll be excused if you don’t notice whether your column heading jumps from, say, XEX to XEZ.  Tip 250 explains how to unhide all rows and columns. But if that’s not what you are after, you can search for hidden rows and columns and only unhide those that you want to unhide.

Here’s how:

  1. On the Home tab, in the Editing group, click Find & Select, and then click Go To Special. (Or press CTRL + G and click on the Special button.)
  2. Click the Visible cells only radio button and click OK or press ENTER.

All hidden rows and columns are marked with a white border. If you point just underneath the row number of the hidden row or to the right of letter of the hidden column and wait until your mouse pointer turns into a split two-headed arrow you can simply double-click or click and drag to unhide it.

With thanks to John Moore for this week’s tip inspiration!

See Tip 232 and Tip 250 for additional information related to hiding and unhiding rows and columns.

* Unless stated otherwise, these tips were written for Microsoft Office 2010.