Saturday, December 18, 2010

Excel | Formula for Cell Input based upon another Cell's Content

Insert date if another cell not blank:  =IF(A24<>"",TODAY(),"")

Excel: Where's the Hide Worksheet button?

Home > Cells > Visibility > Hide & Unhide (Excel 2007)

On Excel 2003 it's Format > Sheet > Hide

Excel | Where's the Drawing Tool bar??

Finally found it!  Go to Home > Insert > Click the 5th icon over ("Shapes").

Thursday, December 16, 2010

Excel | How to Change Excel Chart Data Labels to Custom Values

How to Change Excel Chart Data Labels to Custom Values? | - Learn Microsoft Excel Online:

Select one data label.
In the Formula bar press = and point to the cell with the data you'd like as the label.

Friday, December 3, 2010

Sites I Found that Change Pages to PDF Files

Not yet explored, but here they are:

Verizon Wi-Fi Hotspot Directory

Verizon Wi-Fi Hotspot Directory

Find your Photo on the Internet - Cool!

TinEye Reverse Image Search
TinEye is a reverse image search engine. You can submit an image to TinEye to find out where it came from, how it is being used, if modified versions of the image exist, or to find higher resolution versions.
Photo matching.

Monday, November 22, 2010

Excel | Change the data labels

Simply right-click one of the data markers in the chart and you can over-write the label.

Thursday, November 18, 2010

Starbucks - How to Make a Card the Default Card

If you wish to set up a default Starbucks Card:
  1. Go to “Manage My Cards” page:
  2. At the top of the page (under the title “Card Management”) click on the image of the card you would like to make your default.
  3. When the image and information is brought up, click on “change this card’s nickname”.
  4. You can then select “Make this my default card and display it first in my card library.”
That was so hidden!!

More: How to Delete a Credit Card from Starbucks Card Payment Methods Online

Creative Commons License This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. This post has been scraped in violation of that license if you are reading this post on other than

Friday, November 12, 2010

Excel | Conditional Formatting - How to color adjacent or remote cells

Use a formula like this:


Sunday, November 7, 2010

Delete all Hyperlinks in Excel

Here is how to delete all hyperlinks in an Excel worksheet:
  1. Open your Excel spreadsheet that you wish to remove the hyperlinks from.
  2. Press -F11 to go to the Visual Basic editor.
  3. Create a new module. You can do this by selecting Module under the Insert menu.
  4. Paste the following code into your new module:
Sub RemoveHyperlinks()

'Remove all hyperlinks from the active sheet

End Sub

  1. Close the Visual Basic editor window by selecting "Close and Return to Microsoft Excel" under the File menu.
  2. Now, go to the sheet that contains the hyperlinks that you wish to delete.
  3. Under the Tools menu, select Macro > Macros. Highlight the macro called "RemoveHyperlinks" and click on the Run button.

Excel - Deleting All Graphics

Here is how to delete all graphics at one time in a worksheet:

Press F5 to display the Go To dialog box.
Click on the Special button. Excel displays the Go To Special dialog box.
Select the Objects radio button.
Click OK. All the graphics in your worksheet are selected.
Press the Del key. All the graphics are deleted.

Thanks to:

Saturday, November 6, 2010

Internet Explorer - Runtime Error

Here is how to fix IE for this error message:

Microsoft Visual C++ Runtime Library Runtime Error!  This application has requested the Runtime to terminate it in an unusual way.  Please contact the application's support team for more information.

IE should be closed, then:
Go to control panel and internet options.
"Delete cookie, delete files; and then go to settings and then view files and delete them all. Then click ok (this is all under the general tab).

Thanks! to Hsherriff @

Sunday, October 17, 2010

Windows System Restore

If you get a message that says Windows System Restore did not restore all files successfully, shut your computer down, start again in safe mode, and then perform system restore again.  That works for me.

If you need help getting into safe mode, see my other post here:

Thursday, September 30, 2010

Google Reader on your Blackberry (and it's free!)

I love how quickly I can be reading my Google Reader subscriptions via 1-click.  Simply change the start page to one of your Google reader subscriptions per instructions below.  I also have a separate Google quick search app that I use for general web searches.

Change the home page or start page

Depending on your wireless service provider, you might not be able to change the home page.
  1. On the Home screen, click the Browser icon.
  2. Press the Menu key.
  3. Click Options.
  4. Click Browser Configuration.
  5. Perform any of the following actions:

  1. Press the Menu key.
  2. Click Save Options.

Friday, September 24, 2010

Thursday, September 16, 2010

How to set a Password on Blackberry

How to password protect your Blackberry:

From the Home screen of the BlackBerry smartphone, click Options.
Click Security Options.
Click General Settings. Note: If you are running BlackBerry Device Software 4.0.2 or earlier, click Options, then Security.
Change the Password field to Enabled.
Display the menu and click Save.
Type your new password and click Enter.
Verify your new password by typing it again and click Enter

Wednesday, September 15, 2010

Sunday, September 12, 2010

Google Chrome - "Print Selection" Grayed Out - Print Selection Now Works!!!

UPDATE 8/18/2011: DANG. It's happened again. Print selection is NOT available. My version: 13.0.782.112. History below tells me there's nothing I can do until a new version of Chrome. Geeze Google.

UPDATE 10/10/2010: Looks like Chrome upgrades itself as my version is now:  7.0.517.41.  Print selection and all else works still!

UPDATE 9/12/2010: Print Selection now works! I didn't update Chrome, it just started working. My Chrome version: 6.0.472.55.

UPDATE 8/3/2010:  "Install the DEV CHANNEL of Chrome. The following link will bring you to a page where you can install the DEV CHANNEL, and get "print selection"."

Beware this is a development installation which means it's not a public release. You may find 'other' issues (e.g. my Blogger extension no longer works).  The print selection fix will be installed in the next public release as well.

8/3/2010 - Later that day... Ummmm. OK.  Just reinstalled the non-dev version as too many other things not working yet.  It just depends on what you want - print selection, or everything else.  I can't do without everything else, and I'd already compensated with good options for print selection so that is why I reverted.  Will wait for public release.

I've become used to not having the print selection feature and this is what I do to compensate:
1-Highlight your selection, copy/paste to notepad, print.
2-Install the IE tab.  Then you can click the icon to open the IE tab and copy/paste the URL.  Print/selection works in this tab.
3-This is great! Add "Print Friendly" to your bookmarks.  Clicking the bookmark brings your selection into a pop-up box where you can also "remove images" by simply checking a box, and then print.

Not as easy, but works.

UPDATE 5/18/10: "Future dev channel releases will have this fix, as will beta and stable releases of 6.0 when those happen."
I love Google Chrome - it is fast and the interface is by far the best browser design IMO.

But alas, I'm completely frustrated without the option to "Print Selection".  I tweeted back in Oct'09 that finally Chrome had Print Selection, and it did!  But I upgraded to the latest version (4x) sometime in Jan'10, and that option is now grayed out again. :(  I tried a system rollback but find that even the latest restore point has the "upgraded" browser.  It is truly a sad day.  Sigh.

You can follow this issue on Chromium's project queue here:  Issue# 22937

I also follow this thread Issue# 1682.  This thread is no longer updated by Chromium but people still enter useful comments from time-to-time.

And here's Google Chrome Release Notes site.

Saturday, September 4, 2010

How to make Blog This! work in Google Chrome

This works!  You'll need to change your pop-up blocker to accept Blogger:

1st - Click the folder icon with the X which is to the right of your browser address bar
2nd - Click the radio buttonn to "Always allow pop-ups from...."

Sunday, August 8, 2010

Install BlogThis! Button

Two Methods:

1- You can either get the link and drive it your toolbar from here: What is BlogThis! ? - Blogger Help

2-Or you can add as an Extension in Chrome.  I like this method as the icon sits beside your address bar and doesn't take up space (or move around) like it can on your bookmarks bar.  Get the extension for Chrome here:

To login to VISTA as the Administrator

Here is how to login to Windows VISTA as the Administrator
  1. Type CMD in the Start Search box.
  2. Open a command prompt in administrator mode by right-clicking and choosing “Run as administrator”
  3. In the CMD box, type:  net user administrator /active:yes
  4. Log out.
  5. You'll now see an option to log in as Administrator
  6. When you're ready to disable the visible Administrator option on the login screen, type this into the CMD box:  net user administrator /active:no

Friday, July 9, 2010

Tivo Not Changing Channels with Motorola DCT700

This worked! Although the box is Motorola, you need to select General Instruments.

"To make a long story short, the Motorola DCT700 is, in fact, manufactured by General Instruments (I got this straight from TiVo tech support). So when walking through the channel changing setup you need to choose "GI" as the manufacturer. Crazy huh??? Especially when there isn't a single indication on the box to that effect. :mad: Anyhow, when all is said and done, I landed on the 00093-C IR code for this, which seems to be working just fine.

Now if that's not enough, the tech support weenie gave me the following codes to try: 10006, 10019, 10032, 10042, and 10046. I played around with those as well and the 10046-B setting seemed to work. Some others probably do as well, but I spent too much time on this as it is."

Tuesday, June 22, 2010

Blogger Search Box Doesn't Work

This works:

You can add another search box (and delete Blogger's version)

In Design mode:
1. Click "add a gadget".
2. Scroll down to html/javascript and select "add to blog"
3. Paste this code:

<form action="/search" method="get">
<input name="q" type="text"/>
<input value="Search" type="submit"/>

4. Save.

Thanks to davidchin38!

NOTE: If your Blogger blog is not public that is another reason why the Google powered search box does not work.

Creative Commons License This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. This post has been scraped in violation of that license if you are reading this post on other than

Saturday, June 12, 2010

Block Spam Text Message (Verizon Wireless)

    • Select "Call & Message Blocking".
    • Type in the spammer's number.
      Note: some spammers have a shortened phone number such as 92499999.  Just add two 0's to the beginning of the number to make it 10 digits.  Thus you'd enter 0092499999.

      MORE>> Call & Message Blocking

      Creative Commons License This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. This post has been scraped in violation of that license if you are reading this post on other than

      Friday, June 11, 2010

      Stop Auto-correcting Words in Excel

      Click the Microsoft Office Button
       and then click Excel Options.

      In the Excel Options dialog box, click Proofing, and then click AutoCorrect Options.

      Thursday, June 10, 2010

      How to import/share Flickr photos into Facebook (official Flickr instructions)

      How can I use Flickr with Facebook?

      Images you upload to Flickr can automatically post to your Facebook updates, letting you share them in both places at the same time. To set up the Facebook connection, just go to Your Account.  Then click "connect".  Since Facebook is owned by Yahoo, what you are doing is connecting your Yahoo account and Facebook.

      Please note: Only safe/public images will show on Facebook.

      Monday, June 7, 2010

      Office Communicator - How to Reopen if if you Closed it Accidentally

      You can find it here under All Programs: Microsoft Office Communications Server 2007 R2 Group Chat

      Sunday, May 9, 2010

      EXCEL - Unhide Multiple Worksheets at Once

      Note, you can only do this with a VBA macro (there is no shortcut) but it's easy!

      Here's how to Create a macro using Microsoft Visual Basic
      1. On the Tools menu in Microsoft Excel, point to Macro, and then click Visual Basic Editor.
      2. On the Insert menu, click Module.
      3. Type or copy the code below into the code window of the module.
      4. If you want to run the macro from the module window, press F5.
      5. When you're finished writing your macro, click Close and Return to Microsoft Excel on the File menu.
      The code:

      Sub UnhideAllSheets()
          Dim wsSheet As Worksheet

          For Each wsSheet In ActiveWorkbook.Worksheets
              wsSheet.Visible = xlSheetVisible
          Next wsSheet
      End Sub

      Tuesday, May 4, 2010

      Excel | Charts - How to show the grand total on top of stacked bars?

      This works great!

      Compute the sum in the worksheet. Copy this range, select the chart, and use Paste Special to add it as a new series. This makes a new column stacked atop the others, not what you want. Select this series, go to Chart menu > Chart Type, and choose a line type chart. Double click the line, on the Data Labels tab, choose the Show Value option, and on the Patterns tab, choose None everywhere so the series becomes invisible. Finally, double click on the series of labels, and on the Alignment tab, choose Above for Position.
      - Jon
      Jon Peltier, Peltier Technical Services, Inc.

      Saturday, May 1, 2010

      Microsoft Office | Permanently Expand Drop-down Menus

      How to permanently expand drop-down menus:

      In Word, Outlook, or any other program in the Office suite, from the Tools menu, select Customize, and then click the Options tab.

      In Office XP or 2003, under "Personalized Menus and Toolbars", check Always show full menus, and then click Close.

      In Office 2000, under "Personalized Menus and Toolbars", uncheck Menus show recently used commands first, and then click Close.

      If you make these changes in one program, the changes will affect all the others in the suite: Excel, Word, etc.

      Monday, April 19, 2010

      Outlook - Remove EM Address Suggestions

      There's an error in one of the EM address suggestions that appear when I type a letter in the To: field. I consistently inadvertently mail to that incorrect address. How do I remove that EM address? Here's how:

      Here’s how to delete individual suggested entries:

      1- In the To line, type the first letter or first few letters of the entry you'd like to delete.
      3- Use the down arrow on your keyboard to select the entry you'd like to delete.
      4- Press the Delete key on your keyboard.


      Saturday, April 17, 2010

      Zip file does not Extract

      Turns out my file association was corrupt. Here's how to reassign the correct file association:

      1. Click Start Menu, and then type regedit in the Start Search and press ENTER.
      2. Navigate to the following registry branch:
      HKEY_CURRENT_USER\Software\Microsoft\Windows\Curre ntVersion\Explorer\FileExts\[ext]
      3. Replace the [exe] with the actual file extension that you want to restore its file type association to revert back to original Windows Vista default. If you unsure, simply browse through all the sub-key under FileExts.
      4. Delete the sub-key named UserChoice.
      5. Exit from Registry Editor.

      This worked after I rebooted.

      Big, big thanks to "My Digital Life":

      Wednesday, April 14, 2010

      Laptop - Volume too low

      The volume on my Sony Vaio VGN-Z610Y is too low. At maximum volume levels there is just not much sound. I tried external speakers and that does not change the volume level at all. I've been searching and trying the different suggestions but so far nothing has worked. It looks like purchasing an external sound card may help. How annoying that Sony has this issue. The laptop wasn't cheap either ($2K or so).

      Will continue researching this when I have more time. If something you've tried has worked, I'd love to hear about it. Thanks!! ♥♥♥

      Some links I'll save for latter review - recommended external card per above link

      Laptop - Thermal Control Strategy

      Not sure what this is but saving its location here so I can find it again if I need too.

      In control panel (Classic View), select VAIO Control Center,Power Options
      (Configure energy-saving settings on your computer)

      Thermal Control Strategy:
      ♦ Balanced (this is selected for me)
      ♦ Performance Mode
      ♦ Silent Mode

      A quick search tells me this is something to do with fan speed/cooling:

      Laptop - No Warning for Low Battery

      My Sony Vaio VGN-Z610Y does not warn me when the battery is low. I have to think to look at the little power icon in the system tray. Usually I miss seeing that the battery is too low, and my machine just shuts down at the critical point before I can do anything about it (like remembering to plug in the power). My old machine would indicate a low battery with sound and a visual that would pop up in the middle of the screen. I'd like to get those reminders here on this machine.

      Any suggestions?

      I'm trying this today:

      In the control panel, select VAIO Control Center, Power Options ("Configure energy-saving settings on your computer"), Low batter option: uncheck "Automatically enter Hibernate mode when battery is low" Will let you know what happens... Will I now get a warning instead of a 'shut down'? UPDATE: No still no good warning.

      Friday, April 2, 2010

      Chrome - Quickly reopen last tab closed


      Cool, right?

      Creative Commons License This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. This post has been scraped in violation of that license if you are reading this post on other than

      Saturday, March 20, 2010

      Excel: Delete All Hyperlinks from Excel Worksheet

      Hit [ALT]+[F11] to open the Visual Basic Editor

      Go to “Insert” > “Module” and in the pop-up window copy:
      Sub RemoveHyperlinks()
      'Remove all hyperlinks from the active sheet
      End Sub
      Then click “File” > "Close and return to Microsoft Excel"

      You can now run the Macro in Excel by going to:

      Developer* > Macros > and then Run “RemoveAllHyperlinks”, this will delete all URLS on the selected worksheet.

      Big thanks! to Tech-Recipes
      *If the "Developer" tab is not showing in your ribbon, here is how to get it to display 
      Creative Commons License This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. This post has been scraped in violation of that license if you are reading this post on other than

      Tuesday, March 16, 2010

      Google Reader - The fix for: You don't have permission to view this feed

      Here's how to fix "You don't have permission to view this feed" in Google Reader:

      "Something on your computer or network (proxy/firewall/antivirus/etc) is probably interfering with Reader's access to the internet when you use http. Since https encrypts the data, it is less likely to be stopped by these programs. In general, if you find that you are unable to access Reader with this kind of error, try using https first."

      Simply replace http:// with https:// in the address bar.  It works!

      Thanks to Brian Shih, Google Employee:

      Wednesday, March 10, 2010

      Outlook 2007 - Rules aren't processing correctly

      Be sure to check the "stop processing more rules" after entering your Rules Wizard criteria.  If you don't check that box then you'll either get duplicate email messages in your folders, or the rule won't work at all.  This works differently than in Outlook 2003, Outlook Express, or Windows Mail.

      You'll see "stop processing more rules" after the clicking Next under "What do you want to do with the message?"

      Wednesday, March 3, 2010

      Outlook 2007 - How to send an Email to all Contacts in a Specific Category

      To send email, set up a meeting or task, or write a letter to all the Contacts in a (color coded) category:
      1. In Outlook, go to your Contacts section.
      2. From the View menu, select Current View, and then By Category.
      3. Highlight the category you want to send email to by clicking it.
      4. In Outlook 2007, from the Actions menu, select Create, and then New Message to Contact. In Outlook 2000, 2002, or 2003, from the Actions menu, select New Message to Contact.

      Friday, February 26, 2010

      My favorite Screensaver Slideshow Settings

      Right-click on Desktop, select Personalize, then Screensaver (or copy this into your Window Explore address bar:  Control Panel\Appearance and Personalization\Personalization).

      Select Photos, Settings, then browse to find what you'd like to slide-show.

      Theme:  Pan and zoom
      Slide Show Speed: Fast
      and check "Shuffle Contents"


      Thursday, February 25, 2010

      Blackberry - How to disable Automatic Device Application Update during Sync

      After a re-install of BlackBerry desktop, I noticed that each time I sync'd there would be an automatic device application check and update. So each time I stabilized a version, a new one would sneak in and my settings would no longer be as expected.

      Finally, this is what works (2/27/2010):

      You will need to remove the Blackberry Desktop Application (sorry, you really do... #fail by Blackberry) and re-install it (simply modifying the program will not work - more on that later), being careful to do these two things during the install:

      1- Click the icon next to "BlackBerry Automatic Update" and change it to "This feature will not be available."
      2- Later on in the installation, un-check "Check for software updates."

      This article explains why (has to do with temporary files unavailable if you simply try to modify the program):;jsessionid=A480A2C982DC0E65C72C2DB3F691040A

      Thanks JerryD!

      (The info in this next link did not work for me, but saving for reference:

      Creative Commons License This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. This post has been scraped in violation of that license if you are reading this post on other than

      Friday, February 5, 2010

      Outlook 2007 - Doesn't see my Address Book

      After you install Outlook 2007 you'll need to do this so that Outlook can find your address book:

      Click Tools > Options > Mail Setup > Data Files > Address Books > New > Additional Address Books > Outlook Address Book.

      Thursday, February 4, 2010

      How to Remove Items from the Quick Launch Bar (Bar on bottom left of screen)

      Go to:  C:\Users\rls\AppData\Roaming\Microsoft\Internet Explorer\Quick Launch (where "rls" is your user name)

      and simply delete the shortcuts you do not want to appear on the bar.

      Wednesday, February 3, 2010

      Outloook 2007 - Newly Installed but won't Open "Cannot open your default e-mail folders"

      Purchased and installed Outlook 2007.  Received error message when opening Outlook for the first time:

      "Cannot open your default e-mail folders.  Outlook cannot start because a data file to send and receive mail cannot be found.  To ad a data file, such as a personal folder file, double-click the Mail icon in Windows Control Panel."

      If you don't see the Mail icon in the "classic view" control panel, click on this icon instead "View 32-bit Control Panel Items".  Voila - there is the mail icon.  Click it, then click "data files".  Add a new data file.  I put mine in C:\Users\abc\Documents\Outlook (you'll have a different user name than 'abc').

      Restart Outlook. It should work now!

      Saturday, January 30, 2010

      Backup Google Reader Subscriptions

      Simply go to Settings when logged in to Google Reader (upper right corner, you may get a drop down box so select "Reader Settings").

      Select "Import/Export"
      Click on "Export your subscriptions as an OPML file"
      and Save this file to your harddrive.

      You can import these feeds back into Google Reader (or any reader that reads OPML files) quite easily by selecting "Import your subscriptions" on this same page.

      Be safe - backup.

      Friday, January 29, 2010

      Get into Safe Mode!

      To get into Safe mode, reboot and press the F8 key right before Windows starts up.  If you can't get into safe mode this way, here is the alternative method I use:
      • Click the Start Button
      • Type “msconfig” in the search box
      • Select “msconfig”
      • A “System Configuration” window will open
      • Select the “Boot” tab in the Boot Options section
      • Check the “Safe Boot/Minimal” check box
      • Restart
      • This will put you in “Safe Mode” with large icons and “Safe Mode” showing on all four corners of the screen (you may have to enter your password to get in).
      • Complete whatever your task is (possibly Restart again), then go back to “msconfig”, and uncheck the “Safe Boot” box, and restart. Should boot normally.
      Thanks to How to Geek and Larry!


      Creative Commons License This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. This post has been scraped in violation of that license if you are reading this post on other than

      Tuesday, January 12, 2010

      How to Make the Heart Symbol

      Use the numeric keypad to the right (or if you are on a laptop, press NUMLK) and then press ALT 3.  If on laptop, don't forget to release NUMLK.

      Other fun ALT key symbols:
      ALT + 1 = ☺
      ALT + 2 = ☻
      ALT + 3 = ♥
      ALT + 4 = ♦
      ALT + 5 = ♣
      ALT + 6 = ♠
      ALT + 7 = •
      ALT + 8 = ◘
      ALT + 9 = ○
      ALT + 14 = ♫ Musical Note
      ALT + 15 = ☼ Sunshine Symbol
      ALT + 0169 = © Copyright Symbol
      ALT + 0153 = ™ Trademark Symbol
      ALT + 0174 = ® Registered Symbol
      Works on Facebook, Twitter, Blogger, Wordpress, Word, etc.

      You call that Parallel?

      You call that Parallel?

      Monday, January 4, 2010

      Lost the "Find" Ribbon at the Top of Outlook Messages?

      Click on "Find" (see red arrow) and the ribbon will reappear!

      This is for Outlook 2003 which I use at work.
      Related Posts Plugin for WordPress, Blogger...