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

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

Read More

Excel: Where's the Hide Worksheet button?

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



On Excel 2003 it's Format > Sheet > Hide

Read More

Excel | Where's the Drawing Tool bar??

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

Read More

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

How to Change Excel Chart Data Labels to Custom Values? | Chandoo.org - 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.

Thanks http://chandoo.org!

Read More

Sites I Found that Change Pages to PDF Files

http://www.printfriendly.com/



Not yet explored, but here they are:

http://pdfmyurl.com/

http://lifehacker.com/5450895/pdfmyurl-generates-pdfs-from-any-web-address

Read More

Verizon Wi-Fi Hotspot Directory

Verizon Wi-Fi Hotspot Directory

Read More

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.

Read More

Excel | Change the data labels

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

Read More

Starbucks - How to Make a Card the Default Card

If you wish to set up a default Starbucks Card:

Under the words “Card Management” on the “Manage My Cards” page, click on the image of the card you would like to make your default. When the image and information is brought up, click on “change this card’s nickname”. On the next page, you can select “Make this my default card and display it first in my card library.”

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 http://www.digital-qa.blogspot.com/.

Read More

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

Use a formula like this:



=FIND("Own",$D119)

=FIND("Order",$E119)

=FIND("Own",$D1)

Read More

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

ActiveSheet.Hyperlinks.Delete

End Sub

Then:

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.

Thanks to: http://www.techonthenet.com/excel/macros/delete_hl.php

Read More

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: http://excel.tips.net/Pages/T003018_Deleting_All_Graphics.html

Read More

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 @ http://www.cybertechhelp.com/forums/showthread.php?t=44910

Read More

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:  http://digital-qa.blogspot.com/2010/01/get-into-safe-mode.html

Read More

Outlook - Ways to Organize your Email

7 ways to organize your email

Read More

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:
   
   
   
   


• In the Home Page Address field, type a web address.


• Change the Start Page field.


• WHAT I DID:  TYPED THIS INTO THE HOME PAGE FIELD: http://www.google.com/reader/m/view/?dc=gorganic (WITH FONT SIZE 12)

1. Press the Menu key.


2. Click Save Options.

source: http://docs.blackberry.com/en/smartphone_users/deliverables/11298/Set_the_home_page_26078_11.jsp

Read More

Quickly Insert Date into Word

Alt - Shift - D (all at once)

Thanks to kiwiguy @

Tech Support Guy Forums - View Profile: kiwiguy

Read More

Windows Notepad: Insert Time and Date into Text or Log File | Windows | Tech-Recipes

Windows Notepad: Insert Time and Date into Text or Log File | Windows | Tech-Recipes

Read More

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

Thanks to: http://www.berryreview.com/2007/12/26/faq-how-to-password-protect-your-blackberry/

Read More

GoDaddy - Where is my Email?

Your email that's stored on GoDaddy is here: https://login.secureserver.net/index.php?app=wbe



If you do not remember your password: http://digital-qa.blogspot.com/2011/07/change-godaddy-email-passwords.html

Read More

Set up new Email in GoDaddy

To set up new email in GoDaddy for Outlook 2007, go to:

http://help.godaddy.com/topic/167/article/2649?plid=

Read More

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"."

http://www.google.com/chrome/eula.html?extra=devchannel

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." bystuartmorgan@chromium.org http://code.google.com/p/chromium/issues/detail?id=22937#c65

------------------------------------------

2/9/2010:

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.

Read More

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...."

3/21/2011 - Install from here: https://clients2.google.com/service/update2/crx?response=redirect&x=id%3Dpengoopmcjnbflcjbmoeodbmoflcgjlk%26uc%26lang%3Den&prod=chrome&prodversion=10.0.648.151

Read More

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: https://chrome.google.com/extensions/detail/pengoopmcjnbflcjbmoeodbmoflcgjlk

Read More

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

(Thanks to: http://www.howtogeek.com/howto/windows-vista/enable-the-hidden-administrator-account-on-windows-vista/ for the help in logging in as Administrator.)

Read More

Tivo Not Changing Channels with Motorola DCT700

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

Thanks to Broofa on Tivo and Digital Cable Motorola DCT700 [Text View] - TiVo Community:

"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."

Read More

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"/>


</form>





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.

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 http://www.digital-qa.blogspot.com/.

Read More

Excel | How to conditionally format a cell based on the contents of another cell

The Occasional Tech: How to conditionally format a cell based on the contents of another cell

Read More

Block Spam Text Message (Verizon Wireless)

• Sign in to your Verizon Wireless account.


• Select "Safeguards": 

• 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>>

https://text.vzw.com/customer_site/secure/jsp/msg_intercept_new_blocking.jsp: Call & Message Blocking

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 http://www.digital-qa.blogspot.com/.

Read More

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.

Read More

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.

Read More

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

Read More

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

Read More

Excel - Chart is missing X-axis Labels

Took awhile but finally figured this out!



Go into Chart Options for the chart.

Click the "Axis" tab.

Under Primary Axis check the box beside Category X Axis and Automatic.



How that got unchecked I have no idea...

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 http://www.digital-qa.blogspot.com/.

Read More

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

http://www.mrexcel.com/forum/showthread.php?t=298477

-------

Jon Peltier, Peltier Technical Services, Inc.

http://PeltierTech.com/WordPress/

Read More

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.

Read More

Coffee Break: Tenderloin "Fear Head"

That's cool... my Flickr shot on Newsweek's BudgetTravel.com

Tenderloin Mural "Fear Head"

(beckysnyder/Flickr)

Read More

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.



...gone!

Read More

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": http://www.mydigitallife.info/2008/06/22/restore-and-reset-file-association-in-windows-vista-back-to-original-default/

Read More

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



http://ask.metafilter.com/64163/What-Can-Be-Done-About-Laptop-Audio-Volume-Levels

http://www.google.com/search?aq=f&sourceid=chrome&ie=UTF-8&q=Echo+Indigo+(PCMCIA) - recommended external card per above link

Read More

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: http://www.google.com/search?hl=en&q=%22Thermal+Control+Strategy%22+laptop&btnG=Search&aq=f&aqi=&aql=&oq=&gs_rfai=

Read More

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.

Read More

Search for Cells that contain Specific Words in Excel

Formula: =FIND("?",A1)>0

where ? is your word or chacter



Source: http://www.exceltip.com/st/Find_if_a_character_is_in_a_cell_in_Microsoft_Excel/393.html

Read More

Chrome - Quickly reopen last tab closed

CTRL SHIFT T



Cool, right?

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 http://www.digital-qa.blogspot.com/.

Read More

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

ActiveSheet.Hyperlinks.Delete

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 

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 http://www.digital-qa.blogspot.com/.

Read More

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:

http://www.google.com/support/forum/p/reader/thread?tid=3b5e82d12b9a35c2

Read More

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?"

Read More

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.

Thanks to Indiana University IT Services!

Read More

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"



Save!

Read More

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):

http://rim.lithium.com/t5/BlackBerry-Curve-BlackBerry-8300/Stopping-automatic-device-application-updates/m-p/194234;jsessionid=A480A2C982DC0E65C72C2DB3F691040A



Thanks JerryD!



(The info in this next link did not work for me, but saving for reference:http://www.blackberryforums.com/general-blackberry-discussion/159789-why-wont-my-os-update-i-deleted-vendor-xml-file.html)

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 http://www.digital-qa.blogspot.com/.

Read More

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.

Read More

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.

Read More

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!

Read More

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.

Read More

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!



Awesome!

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 http://www.digital-qa.blogspot.com/.

Read More

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?

Read More

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.

Read More