Skip to main content
Microsoft 365

Microsoft 365 Blog

Recent articles

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>
Published 
2 min read

OneNote Mobile for Android is now available worldwide 

<p>You asked, we listened. Today marks the exciting debut of OneNote Mobile for Android in over 20 international markets. With this release, OneNote Mobile is available across a variety of platforms, all of which let you effortlessly collect, find, use, and share your notes and ideas on the go. Read the full blog post to download OneNote Mobile to your Android phone and to get a first look at the app!</p>
Published 
1 min read

“Office 15” Begins Technical Preview 

<p>This morning, we reached an important development milestone: the beginning of the "Office 15" Technical Preview Program. Office 15 is the codename for the next generation of the Microsoft Office products and services, and the Technical Preview is the first time we share our work with a select group of customers under non-disclosure agreements. These customers play a key role in our development process by testing early builds and providing feedback, which we incorporate into the final release. </p>
Published 
3 min read

Customize! 5 table of contents tricks 

<p>The Word 2010 gallery makes adding a basic table of contents quick: Click the References tab, click Table of Contents, and then click the gallery table of contents you want. But what if you want more? What if your table of contents needs to provide different information--more levels, or fewer levels? What if you want a table of contents at the beginning of each chapter? What if you want to change the font? Here are some of the ways you can customize your table of contents.</p>