Posts

Columns side-by-side or stacked -- CSS to adjust for screen width

Image
I recently had to brush up on my CSS skills to develop a solution where two buttons would appear side-by-side unless the viewport was less than 480 pixels, in which case they should then display stacked. Through a bit of research, I found a couple of solutions. When I tried to implement the solutions as presented, the buttons didn't appear side-by-side, but instead on separate rows -- I'm sure something I must have overlooked, but nevertheless, I, therefore, came up with my own modified solution. My particular example used 3 columns -- the middle just for space, which could be done with padding and/or margin. The key is using "@media." By default the widths of the columns were all set for 100% -- configured for stacking. When the screen was 480 pixels or larger, using "@media" the widths are adjusted 45%, 10%, and 45%. If you're not sure what each of these CSS properties does for you, try searching "css [property]" such as " css clear

Comcast will use your service to offer WiFi to other customers

Image
Yes, you heard that right! If you're a Comcast customer and you rent a cable internet modem from them, then it has a separate wireless channel that other Comcast customers can use. This means as a Comcast customer, you can surf the Internet from any neighborhood where Comcast has an install base. While in theory I like the flexibility as a Comcast customer to get WiFi anywhere ( Xfinity WiFi Hotspots ), in practice I'm not too pleased. Why I'm not pleased. I pay Comcast to have their Internet service, which enables this capability. I pay another $8 to rent their modem, which is also required for this capability. I was never asked; my account was opted-in. If I have an issue with my connection, I have to hold a long time (typically), and if something is wrong at my end, I have to pay for them to correct, yet again Comcast benefits from my service working. If you live in an apartment complex, Comcast advertises your apartment complex on the list of available hots

Firefox Status Bar gone missing? Let's bring it back!

Image
With the release of Firefox 29, the Status Bar workaround no longer worked. I don't recall when it stopped displaying, but now there's no option. I found a handy add-on that brings back the Status Bar, Status-4-Evar , so my other add-ons display again.

Remove all hyperlinks within Excel

Image
Ever copy a webpage of data into Excel, and it brings along a bunch of hyperlinks? Of course, it isn't practical to remove each hyperlink manually. Fortunately, there are a couple of options to perform a bulk removal of hyperlinks. Note that I'm using Excel 2007 in my examples. OPTION 1 Select the cells that contain hyperlinks. On the Home tab, in the Editing section, click the Clear drop-down arrow. Click Clear Hyperlinks . I have found in some cases that the Clear Hyperlinks option isn't available. In those cases, use option 2 below. OPTION 2 Use the following macro: Sub NoMoreHyperlinks() ActiveSheet.Hyperlinks.Delete End Sub For those of us that need a reminder on how to create macros, here's a more detailed process. Press Alt-F8 to display the Macro dialog box Enter a new macro name (such as "NoMoreHyperlinks") in the text box just below "Macro name:" - This will change the Create button from an inactive to activ

Helpful Outlook Shortcuts

I'm always looking for shortcuts to reduce the time I spend moving the mouse. My company just sent this email with a few helpful Outlook shortcuts, and therefore I'm sharing them with you... Outlook 2010 Shortcuts Ctrl + E will help you find a message or other item. Ctrl + Alt + R will reply to an email with a meeting request. Ctrl + Shift + A will create an appointment. Ctrl + Alt + F will forward an email as an attachment. Ctrl + Shift + M will draft a message from any Outlook view. Outlook 2011 for Mac Shortcuts Shift + ⌘ + K will send all the messages in your outbox. Shift + ⌘ + O will display all unread messages in your inbox. Ctrl + ⌘ + C will check recipient names in an open message. Ctrl + 2 will flag an item for follow up for “tomorrow;” Ctrl + 3 will flag for “this week;” Ctrl + 4 will flag for “next week”.

Lenovo Yoga (Synaptics) Touchpad Adjustments

I recently purchased a Lenova Yoga, which is a laptop - tablet hybrid (an article for another time). I am quite happy with it, but have been rather annoyed with one "feature." While using the touchpad, what seemed like for no reason, the screen would switch to the last program I was using. I finally discovered it was caused when I moved my finger to the right on the touchpad -- which is common when moving the cursor. I move it right, I move it left, I move it up, I move it down... you get the idea, we move the cursor on the screen, because that's how it works. I found the device properties, and learned that this was a "feature" of the touchpad. A left-to-right movement from the edge of the touchpad is an indication you want to see the last program used. Simply disabling the "Edge Swipes" feature solved this annoyance. By the way, the same feature exists in Windows 8 for touchscreens. I find this to be a great feature, and use it frequently. For

Delete all objects in Excel

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 Extension not working in Chrome

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.

Search and replace special characters in Word

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

Eurogames for iOS / mobile devices

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