Sunday, December 30, 2007
Sure, you can select the cell, copy it to the clipboard, paste it back to the same cell, click the Paste Options button, click Paste Special, and then click Values. The cell contains the value instead of the formula.
There is a better way. Simply select the cell to be converted, press F2, and then F9.
Saturday, December 08, 2007
Monday, December 03, 2007
One at a time, you might right-click each link and select Remove Hyperlink. A longer method is to click Insert > Links > Hyperlink, and then on the Insert Hyperlink dialog box, click Remove Hyperlink.
There is a better way.
Click the hyperlinked word(s) and press Shift+Ctrl+F9. The hyperlink is removed. To do all at once, Ctrl+A to select the entire document, then Shift+Ctrl+F9 and all hyperlinks in the document are removed.
Tuesday, November 13, 2007
Tuesday, November 06, 2007
With Office 2007, this has changed. No longer is there a Help menu option to click or an About selection. But there still is an About screen.
Click the Office Button, then in the lower right of the status bar, click Word Options (or Excel Options, or PowerPoint Options). In the left pane, click Resources. Locate and click the About button.
OR: Office > Word Options > Resources > About
The familiar About window displays with the current version of the application. Notice the System Information button? Clicking it will display details about the hardware you are using.
Monday, October 29, 2007
To see how go to:
Monday, June 04, 2007
Need to create a column with sequence numbers from 1 to the whatever? Enter a 1 in the first cell and a 2 in the second cell, select both cells, and then double-click the fill handle. Excel completes the sequence all the way down through the last cell in the series.
Saturday, March 24, 2007
Excel did not make that change until the 2007 version. It even added another feature when closing that works better than Word 2007. Press Alt+F4 at any open workbook and all open workbooks attempt to close—you get the do you want to save window for each file. If you just close a single workbook, non of the other workbooks are affected. Word does not have the Alt+F4 feature and pressing that combination just closes the active document.
Monday, March 19, 2007
If you are editing the existing URL in the address bar, Alt+D to select it and switch to it, then Ctrl+arrow (left or right) to move to the beginning of a section. To move to and select a section, use Shift+Ctrl+arrow.
Ctrl+N still opens a new incident of the same page in a new browser window. It does not open it in another tab. When you are through with the page, simply close the browser and the original browser with all your tabs is still available.
Saturday, February 24, 2007
Cute, but is it useful? Yes, in a worksheet of email addresses I use for one of my emailings, I need to know how many are on the list. At the top of the worksheet I created a formula containing =COUNTA(A:A)-1 to count the number of emails in the list. I subtracted 1 to exclude counting the row containing the column heading.
Monday, January 08, 2007
By now you have probably installed Internet Explorer 7 and experienced the Microsoft version of Tabbed Browsing. To be honest, I was not unhappy with IE6. It did what I needed and I frequently used Ctrl+N to open a new instance of the current window so I would not loose my place when browsing. The taskbar would fill up pretty quickly, but I was used to it. (This still works with IE7)
Enter IE7 with tabs--very nice. The taskbar is now clean with only one IE task open. Quick tabs (Ctrl+Q) lets me see miniature windows of the contents of each tab. And there is plenty of help on the Microsoft site. Of course most of us will just figure out how to use it on our own—perhaps this is a geek thing.
I have done some exploring and here are some shortcuts I have found useful to me:
Ctrl+Click will open a favorite item or an item on your link bar in a new tab and gives it focus.
When clicking a link on an open Web page, there are three options:
- Click opens the link on top of the existing page (unless the link is set by the Webmaster to open on a new page)
- Shift+Click opens the link in a new instance of the browser
- Ctrl+Click opens the link in a new tab but the current window keeps focus
- Shift+Ctrl+Click opens the link in a new tab and gives it focus
When typing an address into the address bar, there are some additional options:
- Type and hit Enter, the new site opens in the tab currently having focus
- Type and then Alt+Enter, the new sites opens in a new tab with focus
- Type the domain name without the .com, then Ctrl+Alt+Enter and IE7 adds the http://www to the left and .com to the right, then opens the site in a new tab with focus
- Ctrl+Enter adds the rest of the .com, but opens in the tab currently having focus (just like it did in IE6)
To close a tab:
- Click the X on the tab (visible if the tab has focus)
- Right-click the tab and select Close
- Middle_click the tab (the middle button is the scroll wheel)
For a lot more information on tabbed browsing, see the FAQ page at Microsoft at http://windowshelp.microsoft.com/Windows/en-US/Help/b37c030b-bdc5-488e-aeca-3e64b739736e1033.mspx
- Dick Evans
- A Preacher, Christian Missionary, and Healing Evangelist, Author, Blogger,
Computer Consultant, Ham Radio Operator, and retired College Professor.
Dick He has authored a number of books over the years, both in his computer profession and in the ministry.
Now retired, he volunteer teaches computers at the Port Charlotte, FL library and at a computer club in Port Charlotte and helps people with their computer issues. He is Vice President of that group.
In addition to his own blogs, Dick writes articles for Dave's Computer Tips
Dick was on the full time faculty at Rhode Island College as an Assistant Professor from spring 2005 through summer 2009. Previous to his full time position, he was an adjunct professor at Rhode Island College since 1986 teaching a number of computer related subjects. Prior to that he taught Programming at a technical school in RI. He has been a Ham Radio Operator licensed since 1957 as K1CVP
- ► 2013 (15)
- ► 2012 (39)
- ► 2011 (24)
- ► 2010 (21)
- ▼ 2007 (11)
- ► 2006 (10)
- ► 2005 (37)