Skip to main content
Microsoft 365

Microsoft 365 Blog

Recent articles

Published 
1 min read

Grouping emails by conversations 

<p>Have you ever had to find an email that was part of a long thread--an email with lots of replies about the same topic? For example, your boss might have asked for the results of last month's important meeting, and you know Sherry sent an email outlining them, but then you remember that Todd followed hers with more information. If you group your emails into conversations, you can find the emails you want more quickly.</p>
Published 
2 min read

Using a Combo Box to search as you type 

<p>Here's a neat trick that you can use to filter a Continuous or Split form while your users are typing in a Combo Box. As the user types, the form filter updates to display full or partial matches for the value entered. This example uses a slightly modified version of the Northwind 2007 Template, available for download from Microsoft. The "Customer List" form is a Split form that displays a list of all customers. We want to allow users to filter this list to easily find a customer, even without knowing the full customer name.</p>
Published 
9 min read

VLOOKUP Tutorial: Updating prices in a master price list 

<p>In honor of VLOOKUP Week, MVP Bill Jelen has created a VLOOKUP tutorial for those of you who have a basic working knowledge of Excel but want to improve your skills. This tutorial assumes you've heard about VLOOKUP and its benefits, but that you don't really know how to use it. Bill uses the example of updating prices in a product list to introduce the value of this time-saving function. </p>
Published 
<1 min read

Yammer + Ultimate Software = More Engaged Workplace 

Today, we are thrilled to announce an integration with Ultimate Software, a leading provider of unified human capital management SaaS solutions, at the company's Ultimate Connections Conference in Las Vegas. The bi-directional integration allows updates from Ultimate Software to appear in Yammer, as well as conversations from Yammer to be published in a custom feed inside…
Published 
2 min read

5 tips on using Bcc in Outlook email 

It's kind of funny that a software application would use abbreviations that refer to pre-software days. Remember carbon copies? Cc means carbon copy and Bcc means blind carbon copy. For emailing, you use Cc when you want to copy others publicly, and Bcc when you want to do it privately. Any recipients on the Bcc line of an email are not visible to others on the email. These five tips get beginners started and provide info for those who already know how to use Bcc.
Published 
1 min read

Change the default line spacing in Word 

<p>When the default line spacing in documents changed from single spacing in Word 2003 to a slightly roomier 1.15 spacing in Word 2007 and Word 2010, customers asked the inevitable: Why did the default line spacing change? And how do I change it back? The short answer is that the default line spacing changed in Word 2007 to make online documents more readable. If you want to change the default line spacing in Word 2007 or Word 2010, or learn how to set the line spacing in a single document, here are the best resources we've found for step-by-step instructions.</p>
Published 
4 min read

Conditional Formatting Rules Simplified 

<p>Conditional formatting is a popular feature and is a great way to easily identify cells with a range that meet some criteria. However, users often want to create conditional formatting rules that go beyond comparing a cell’s value to a single value or a single cell reference - row or column comparisons are commonly requested operations. In this blog post, we will learn how to use relative references in conditional formatting rules to make such tasks easier.</p>
Published 
1 min read

Circular Reference? Excel’s most popular (!#?%) error message explained 

<p>Millions of people using Excel don't get why they see the "circular reference" error message right after they've entered a formula. The message means that your formula is trying to calculate its own cell--kind of like when a dog chases its own tail. Because so many of you (millions) searched on "circular reference" on Office.com, we thought we should very clearly explain how to remove or fix your formula. </p>
Published 
1 min read

Tip: How to cut and paste without messing up formatting 

<p>Why does formatting sometimes get messed up when you cut and paste text? And what is that thing that appears at the end of the last sentence every time you paste-like a fly returning to honey. That thing--the Paste Options button--is your friend, a worker bee and not a fly whose only job is to follow your formatting instructions. Learning how it works keeps you from wasting time manually formatting pasted text. </p>