To quickly go to the last cell with data in it, hit CTRL-END. CTRL-HOME always takes you to cell A1. Very helpful in HUGE spreadsheets!
Archive for December, 2010
Microsoft Excel Tips: Keyboard Shortcuts
Sunday, December 12th, 2010Microsoft Word Tip: Synonyms
Saturday, December 11th, 2010Need a synonym (same meaning, different word)? Position your cursor inside the offending word and hit SHIFT-F7. You’ll sound so literate!
Internet Tip: Keyboard Shortcuts
Saturday, December 11th, 2010When reading a web page, hit the END key to go to the bottom of the document, HOME key to go to the beginning, and hit the SPACEBAR to advance one screen at a time. Sure beats using the scrollbar!
Windows Tip: Drop-Down Menus
Friday, December 10th, 2010To quickly open drop-down menus, hold down the ALT key and tap the “underlined letter” in the menu title. Use the cursor keys to choose a menu item. Hey, it keeps your hands on the keyboard where they belong!
Online Diversion: Liquid Measure 2
Friday, December 10th, 2010Who knew plumbing could be so much fun. In Liquid Measure 2, your job is to make sure you catch the water. But not just all of the water, only certain amount. By maneuvering pipes, devices, and even the collection bucket, you need to collect the exact amount of water required. The first levels are relatively easy, but after a while, you will have to put your thinking cap on – or plumbers cap, as the case may be!
Site of the Week: Online Business Card Generator
Thursday, December 9th, 2010Need some business cards on the cheap? Why not make your own, for free! At my site of the week, the Online Business Card Generator, you can. Choose any picture or logo, add the contact you want to share, and hit the Create button. It will instantly create a PDF that you print on your own printer or take to your local copy shop.
Better Google Searching
Thursday, December 9th, 2010How many times have you typed something into Google only to get a bunch of results that don’t match what you were looking for? Well, here are some of my tricks to speeding up that process:
1. Always use multiple keywords. Unless the word you are typing in is extremely narrow in usage, the results will always be too nebulous.
2. Pay attention to the Google Suggest options (the drop-down suggestions that Google gives as you type). They often provide better search phrases than I could come up with.
3. Use Quotes. If you are looking for a specific book title, quote, or song name, surround your search phrase with quotes. The results you receive will be dead-on accurate.
4. Check out Google’s Advanced Search. To the far right of the search blank on Google’s home page, you will see a link labeled, “Advanced Search.” I use this all of the time when I want to narrow my search results by file type, date, or even site. For instance, if I am looking for the meaning to a Windows error message, I will limit the results to ONLY show pages from the official Microsoft site.
Find My iPhone / iPad
Wednesday, December 8th, 2010If you have an iPhone or iPad, listen up! Apple quietly made one of their services and apps free. The “Find my iPhone” app will work with both your iPhone and iPad…with a little set up.
First, make sure you are on the latest operating system version for your device. To find out what version you are on, get your iPhone or iPad and click Settings, and then choose “General.” At the top of the screen you should see “About.” Click it. Scroll down until you see “version.” As long as it it is greater than 4.1, you can do this. If your device is not up to 4.2, sync it with iTunes and upgrade it.
Once you are at the correct OS version, click on Settings, “Mail, Contacts, Calendars,” and choose Add Account. Choose Mobile Me. It will ask for your iTunes login information. Then simply switch the “Find my iPhone” option to “on.” That’s all there is to it. If you have an iPad, also, follow the same steps. Finally, go to the App Store and download the “Find my iPhone” app and install it.
That’s all there is to it. Now, if you ever lose your phone or iPad, just fire up the app on the other device (or go to me.com on any computer) and it will show you a map of where your device is. Keep in mind, your device must be connected to the Internet for the locator to work
