CHRISdotTODD

I recently copied hundreds of rows of data from a webpage into Excel. Unfortunately it brought over several unwanted objects, which I needed to delete. It seemed quite consuming if I was to select and delete each individually. Worse I discovered that I couldn't select some of the objects (checkboxes). I learned two new techniques for mass deleting objects. If you can select the objects Press F5 -- this opens the "Go To" dialog box Click Special...  -- this opens the "Go To Special" dialog box Select the Objects radio button Click OK -- this closes the dialog box and all the objects in the worksheet are selected Press Delete  and all the objects are deleted If you don't want all the objects deleted, first un-select those you don't want to lose. If you get a message "no objects found", then move on to the next method. For those objects that can't be selected For those that know how to create a macro, here's the macro

RoboForm is one of those go-to programs that if it doesn't work in my browser, I don't use the browser. I became quite frustrated when RoboForm quit working in Chrome . I tried going into the Extensions manager to get any clues, and when I changed settings I got a pop up error message. As it turned out, Chrome has a Windows 8 mode and a Desktop mode, and I was in Windows 8 mode. Apparently some Extensions in Chrome don't work in Windows 8 mode. I switched to Desktop mode, and magically RoboForm worked.

Trying to find or replace special, non-viewable characters in Word? It's easy if you know how! Once you know how, you'll find many new uses. For example, I recently received a table of values in an email, and when I copied into Excel the values didn't go to the cells. With a little search and replace in Word, I reformatted the data so it was tab delimited, and then opening in Excel was a snap. In this case, I had three columns of data, all separated by various number of spaces so that it looked nice in the email. This is how to replace the spaces with tabs. When replacing several spaces at once, the trick is to find and replace the longest number of spaces first. This had some column spaces with 4 spaces, 5, spaces, and 6 spaces, so I started with searching for 6 spaces. Open the Find and Replace dialog box (Ctrl-H). Put 6 spaces in the "Find what:" field. In the "Replace with:" field, enter "^9". Note the following: No quotes "^

For the past several years I've started playing Eurogames . Eurogames are board games that are much more strategic in nature than the games we grew up with. Basically they require significantly more skill than luck. It's a great alternative to sitting in front of a computer by yourself playing a game. More recently there have been apps created that work just like the board games, and making setup and cleanup much easier. Most of these games have options to play against online opponents, pass-around mode, and a built-in AI. (Yes it puts you back on an electronic device, but you can do it in the living room or other public place.) I've enjoyed a few of these apps as they offer multiple benefits: Ability to practice strategies Usually faster than waiting on each person to take their turn You don't have to wait for a convenient time to gather enough players You can stop in the middle and resume later These have been my favorites Le Havre : Played on iPad 2 and

With the changes to iTunes 11, I struggled finding a couple of features. First, the left side-bar was missing. Hide or show the left side-bar by clicking CTRL-s (or CMD-s). The other thing I struggled with was finding the option to Manually manage music and video . It was quite easy once I found it. The problem was that it was hidden below the fold. Go to your device (iPod, iPhone, or iPad), and click on the Summary section. From the Summary section, scroll down. The option is located just above the Reset Warnings button. Then it's simply checking or unchecking the box and clicking Apply .

I recently had a situation where I needed to merge PowerPoint slides that had originated from two different language versions. While both were written in English, one group of slides were created from a Spanish install of PowerPoint. Of course the English text was displaying as incorrect spellings in the Spanish version. First, I was surprised to see the English text still displayed as spelled incorrect when I opened in my English install of PowerPoint. After that, I figured once the slides originating from the Spanish version of PowerPoint were inserted into an English version PowerPoint, it would correct itself. I found that still wasn't the case. All the slides that were authored in the Spanish version of PowerPoint still retained the Spanish dictionary, and therefore the English text on those slides indicated they were misspelled. Come to find out, each text box within PowerPoint is assigned its own dictionary language. In order to correct, follow these steps. (Note that I&

I frequently copy formulas from one months data to the next, but I run into trouble when I want to get a total off the last row, when the last row is different each month. I discovered a formula that will read the last value (before blanks) in a range. Enter the formula =INDEX($E$1:$E$5100,LARGE(IF($E$1:$E$5100<>"",ROW($E$1:$E$5100)),1),1) Press Ctrl-Shft-Enter The key here is you must use Ctrl-Shft-Enter. It will insert curly brackets, which wont work if you manually enter them. The curly brackets are needed as this is an array formula. See Introducing array formulas in Excel from Microsoft or search for other websites for further information.