Tuesday, November 3, 2009

Microsoft Excel New Version? I LOATHE YOU!

All I want to do is remove a HYPERLINK.  This is what they told me to do:
  • To turn off several hyperlinks at once, do the following:
    1. In a blank cell, type the number 1.
    2. Right-click the cell, and then click Copy on the shortcut menu.
    3. Hold down CTRL and select each hyperlink that you want to turn off.

      Tip  To select a cell that has a hyperlink in it without going to the hyperlink destination, click the cell and hold the mouse button until the pointer becomes a cross Excel selection pointer, and then release the mouse button.

    4. On the Home tab, in the Clipboard group, click the arrow below Paste, and then click Paste Special.

      Excel Ribbon Image

    5. Under Operation, click Multiply, and then click OK.

The best part?  After all that?  It didn't even work.
--
Manic Mommy
http://shesjustanothermanicmommy.blogspot.com/

No comments: