CHRISdotTODD

When working with large spreadsheets in Excel, it's very inefficient to copy the same formula down all the rows. Many of us already know that once we have our formula in our first row, we can drag the handle down to populate the remaining rows. But when we have 100s or even 1000s of rows, even this is not efficient. To allow Excel to do this for you, instead of dragging the handle, just double-click the handle. Here's the steps: Create formula in top cell Move cursor top lower-right corner of cell -- cursor should change to a plus (+) sign Double-click

The cable providers are scared of losing their cash cow by people watching TV over the Internet. In the latest volley from the cable companies, Time Warner is rolling out restrictive caps that are high priced, and extremely high if you go over. Sure, $15 a month for Internet sounds good, until you realize it's for 1 GB of data and an additional $2 for each gig you go over . As Wired points out (in "Congressman Wants to Ban Download Caps"), that's 3 hours of Hulu video or half a standard definition movie delivered online. For a mere (cough, cough) $75 per month, you can get 100 GB per month, and only pay $1 penalty for each gig over. It sure makes Comcasts 250 MB cap at $50 - $55 per month look good. I've heard some folks defend the caps, claiming we don't need that much bandwidth, but each argument has been based on 1 user. The typical claim has been from 50 to 90 GB average usage. Multiply that by a family of 4 and now you're at 200 to 360 GBs. And if t

I had experienced problems with Word 2003 taking a long time to launch. I'm not sure when it occurred, though I suspect it was when I tested it as the email editing client for Outlook. Even though I disabled Outlook from using Word 2003, Word continued to launch slowly. I searched Google, but couldn't find much that would help. I resorted to using the Detect and Repair feature contained in the Help menu. After some processing, the Detect and Repair process asked me for my install disk. Since this is a company computer, Office was installed from a shared drive that I don't have access to, so I canceled the process. When I returned to Word, it acted as though it was the first time launching, and it now seems to open faster. Unfortunately, when I opened Outlook, it also acted like it was the first time launching. My profile was gone with my settings to access my email and the pointer to my email archives. Fortunately I keep all most of my email on the server, so I can access i

I had a fresh install of CorelDRAW X4, and each time I tried to start it, it would crash. After some searching through Google, I found the following fix. Open the folder C:\Program Files\Corel\CorelDRAW Graphics Suite X4\Programs\UIConfig\CorelDRAW Edit DrawUI.xml Find the line <dockpage guidref="bc1e2f70-3b58-41cd-8406-aaa550482972" visible="true" selected="true"> Change visible="false" and remove selected="true" <dockpage guidref="bc1e2f70-3b58-41cd-8406-aaa550482972" visible="false"> Save and close DrawUI.xml Fold down F8 and restart CorelDRAW X4 When prompted to update settings, select OK That did the trick for me. Apparently it is caused by a conflict with MFC dlls that are installed (version 1833) with SQL2008.

The iPhone's iPod player works great with audio. Start your favorite song or podcast, and while it plays, you can use other functions on the phone. This is one of the few background processes that works with the iPhone. If you try the same thing with a video, perhaps all you really care about is the audio portion, you're out of luck. As soon as you navigate away from the video player screen, the video stops playing. I have found a work-around, so you can listen to the video while you use other iPhone functions. Here are the steps: Find and start the video Navigate away from the video player by pressing the Home button Put the iPhone to sleep (press the top sleep/wake button) Wake the iPhone (press the top sleep/wake button, again) Double-click the Home button This will bring up the video, with the phone locked Press the play button Slide the slider to unlock the iPhone Now you will be able to listen to the video while you use other features of the iPhone. Have fun!

Steve Wozniak takes one for the (geek) team as he puts himself out there to be ridiculed by the judges for his lack of rhythm. It's this type of attitude that led Steve to innovate -- take risks, even though you might fail.

On February 26, 2009 I wrote about problems with XP and my CD/DVD drives . After a fix to the Registry, the last step was to re-install any software that I use to burn CDs and DVDs. It seemed all was good, but I apparently hadn't tried iTunes. The next time I launched iTunes, I was greeted with the following message: Warning! The registry settings used by the iTunes drivers for importing and burning CDs & DVDs are missing. This can happen as a result of installing other CD burning software. Please reinstall iTunes. With prior experience using iTunes, I was not about to uninstall iTunes. Instead I just tried a Repair through the Add/Remove Software interface. That failed. I then tried installing iTunes over my current install, and that failed too. Finally I went fishing on Apple's site. I found an entry that looked promising. Apple recommends I remove a Registry key, add an new one, and then re-install all CD/DVD burning software. Sounded a bit like a loop, so I tried just

I recently added a new email account to my Thunderbird client, and it failed in sending email (SMTP), though it did receive (pop3). I double and triple checked my configuration; I deleted and recreated the account; nothing seemed to work. I had two other SMTP accounts defined, and they never had the problem. Finally I found a reference (sorry I don't remember what website) that suggested trying to delete all my saved passwords. Sure enough, that did it. Even though when I had recreated the account I was challenged for password input on the first time, it had still failed. Also, I had copied and pasted the password from an alternate source, so I didn't make a typo. Some how the storage for passwords, just for the single account, was corrupt. If you use Thunderbird on Windows, to delete your passwords go to: Tools >> Options Click Privacy Click the Password tab Click Edit Saved Password Either click Remove All OR select the ones you want to delete and click Remove Click Clo

My previous post had a table that the browser pushed outside the defined dimensions, making half of it un-viewable. Beside the rather narrow body for the blog, which by-the-way makes it easier to read, most browsers just don't know how to break text strings that do not have white space. Turns out there is some CSS code that can be used that will correct this in most browsers. Use the following two CSS properties in your table definition (adjust width to meet your need). table-layout: fixed; width: 425px; Surprisingly, if you use Firefox, it shortens the width correctly but it still has trouble wrapping some lines, while IE and Safari seems to render the entire table correctly. Visit the W3C site to get details on other table options .

I've been using Verizon FIOS for about a year, and up until recently I've been happy. Unfortunately, recently my ip address (which Verizon assigns to my router) changed and now it appears I'm coming from Toronto, Canada. In fact if I run a Trace Route, it says I'm coming from Toronto, Canada as it's taking 21 hops and traveling over 2100 miles within the Verizon network before they release me onto the Internet. Hop Time Host IP Location 1 1.183 xo-gateway 140.239.191.1 Rowland Heights, CA, United States 2 7.517 ip65-47-242-9.z242-47-65.customer.algx.net 65.47.242.9 Culver City, CA, United States 3 7.119 ge6-3-0d0.mar1.santaana-ca.us.xo.net 207.88.81.193 , , United States 4 8.589 p5-1-0-3d0.rar1.la-ca.us.xo.net 65.106.5.81 , , United States 5 9.406 te-4-1-0.rar3.la-ca.us.xo.net 207.88.12.153 , , United States 6 22.022 207.88.12.154.ptr.us.xo.net 207.88.12.154 , , United States 7 9.234 205.158.79.122.ptr.us.xo.net 205.158.79.122 , , United States 8 12.424 0.so-2-2-0