Saving time in a SharePoint Person/Group field

When you’re working in SharePoint and you have to fill in someone’s name, you’re seeing what is commonly called a People Picker field. It’s a field that’s set up to allow for names, and it has two icons to check the name format as well as to look up a name in the Select People and Groups dialog box.

However, I often see people clicking on the Address Book icon even if they know the name of the person they want to add to the field. Following are some various ways to add a person’s name into the field and maybe save yourself some clicking around to do so.

Removing excess formatting from an Excel spreadsheet

Sometimes when working with Excel, you may end up with a spreadsheet that has an excessive amount of formatting. That formatting can come with a cost, such as large file sizes and long wait times to launch the spreadsheet.

File protection for Excel, Word, and PowerPoint files

I had a question yesterday from someone asking if there was a way to password protect an Excel file. I just assumed that everyone knew that was possible, but I didn’t have a direct answer that said “click here, here, and here” to help her. Thus, today’s tip on how to password protect files in Excel, Word, and PowerPoint.

Adding Favorites to a minimized Outlook Folder Pane

Sandra showed me a cool trick last week that I was unaware of. She likes to keep her Outlook Folder Pane minimized down the left side of the screen, but I’ve always disliked it because it didn’t list the folders I cared about. She fixed that problem by showing me how to add Favorites there! Here’s how you do it…

Adding numbers in an Excel column with hidden rows

A customer asked us a question a while back related to Auto Sum on a column with hidden rows. Not being an Excel wizard, I left the question in my inbox to investigate later. Fortunately, the answer arrived in an Efficiency 365 email!

Removing names from the Outlook Autocomplete list

Over time, Outlook builds up quite a collection of email addresses that it “helpfully” assists you with when you start to type a name in the To field. However, people move on, change email addresses, or no longer qualify as someone you want or need to email. Here’s how you can get rid of those names that just clutter things up.

How to Write Effective Emails that People Will Actually Read

But sometimes I read something that is a bit more general, but is *very* important in terms of being effective with the Office tools that you have. In this case, I read the following article: How to Write Effective Emails that People Will Actually Read.

Adjusting Outlook incoming email alerts

Do you wish there was some way to be notified when new emails come in? Do you hate the fact that you *do* get notified when new emails come in?

Where did my Ribbon Bar commands go?

Some time and somehow over the last couple of days, my Outlook email started showing up with the Ribbon Bar tabs appearing but none of the commands underneath them. To do anything with my email, I had to click the Messages tab to get all the related commands. Since this had One Minute Office Magic tip written all over it, I decided to figure out what I did and how to fix it.