Last month, I shared a tip about how to clear out the numeric/text error in Excel without having to correct it one cell at a time. I mentioned there was no blanket way to turn it off, but I was… WRONG! A colleague pointed out an option setting in Excel that allows you to ignore that error completely.
Seeing who was in a Skype meeting
Have you ever been in a Skype meeting, and wondered who all attended after the fact? Here’s a cool trick to see who was in the meeting…
Expiring mail in Outlook
There’s a feature in Outlook that allows you to send an email that “expires” at a certain date and time. Sandra and I were discussing it the other day, and we really didn’t know what it would do. I decided to figure it out for today’s tip. 🙂
AutoRecover in Excel, Word, and PowerPoint
So have you ever been working away on a Word document or Excel file, only to have the power go out or your laptop throw the Blue Screen of Death? All your work… gone.
But not necessarily… if you have AutoRecover configured in your Office programs (specifically, I’m referring to Word, Excel, and PowerPoint), you will only lose a limited amount of work. Here’s how you do that…
Sharing your desktop in Skype in one easy step
When I’ve been working with people and ask them to share their desktop, I’ve noticed that a lot of people select the desktop sharing option, but forget to click the Present button at the bottom…
Printing the row letters and column numbers on an Excel spreadsheet
Most of the time when you print a spreadsheet, you only want to see the data, not the letters for each column and the numbers for each row. However, there is a way to get the letters and numbers to show up if you need them on your printout.
Zooming the text in an Outlook email
Depending on the quality of your eyesight (and the font size choice of your email sender), you might find that you need some extra “help” in reading the text in a particular email. Outlook provides a couple of ways that you can easily zoom in and increase the text size of your email.
Tabbing your way through OneNote sections
If you use the CTRL+Tab key combination, you can move across the section tabs from left to right at the top of your OneNote notebook.
Excel Spell Check Options
One of our Enterprise Service Center (ESC) supervisors shared a cool Excel tip yesterday. They often hear complaints about how there is no automated Spell Checker in Excel. However, there are a couple of different ways that you can complete a spell check.