Conditional Formatting Rules Simplified

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…


Go beyond the basic chart type

Excel comes with lots of predefined chart types, including column, line, pie, and so on. However, many of you ask how to make other kinds of charts, such as floating column charts, Gantt charts, combination charts, org charts, flow charts, hierarchy charts, histograms, or Pareto charts. Though these charts aren’t available in the list of predefined chart types, don’t worry. There are ways to create them in Excel.


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

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.


Q&A with Access developer Juan Soto

Working in an ice cream factory in Chicago led Juan Soto to found IT Impact, Inc.,  an Access development consulting firm. The ice cream factory’s large Enterprise Resource Planning system required that he spend hours manually calculating whether a final batch of ice cream really made the company money. He had to factor the waste for every step of the manufacturing process and soon realized that he could automate the…


Tip: How to cut and paste without messing up formatting

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…


OneNote Mobile for Android is now available worldwide

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…

“Office 15″ Begins Technical Preview

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…