Posts

Showing posts from 2013

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