Browse by Tags
All Tags »
Formatting & Printing (RSS)
If you use Excel to track identification numbers (serial numbers, tracking numbers, etc.) you may find that if the IDs have more than 15 digits, Excel loses the digits after the 15th and makes them all zero. In other words, type "123456789123456789" into
Read More...
I've decided to start posting some of the replies I send to customers who write me asking for help on how to do something in Excel or Excel Services, especially those which I think might be solutions to problems others are likely to have. For my first
Read More...
A few weeks ago I posted a series of articles about great-looking documents. I have had a few questions about shapes since I wrote those posts, so I thought I would write a quick post on changes to shapes in Excel 2007 (and Office 2007 really – anything
Read More...
In the post last week on Page Layout view , some of you may have noticed the words “Click to add header” in a few of the screenshots, which was a hint that there have been some changes in headers and footers in Excel 2007. I am going to review those changes,
Read More...
A few posts back when I provided an overview of our work in the area of “better looking documents”, I mentioned that two of our goals were to “Make it easy to see what your work will look like printed as you create it “ and “Make it easier to maintain
Read More...
Yesterday we looked at Table Styles . Today, I wanted to revisit PivotTable Styles (see a post here where I introduced PivotTable styles a few months ago – you might want to re-read that before proceeding). This post will be a bit shorter, because most
Read More...
Last post we looked at Cell Styles – both the changes we made to the feature as well as the set of Cell Styles that will ship in the Office public beta. Today, I wanted to revisit another (completely new) set of styles that are part of Excel 2007 – Table
Read More...
A few posts ago, I presented an overview of the work we are doing in the area of great looking documents . Over the next few posts, I want to walk through a number of the improvements we have made to styles. Today, let’s cover Cell Styles. “Cell Styles”
Read More...
Last time, we looked at what a Document Theme (“theme”) was, some of the places it shows up in the Excel UI, and a few examples of why themes are useful. Today I wanted to cover how to change, create, and modify themes, how to tweak themes, and themes
Read More...
In the last post, I presented an overview of the work we are doing in the area of “great looking documents”. Over the next few posts, I want to walk through a number of the improvements in a bit more detail. Today, I am going to introduce the idea of
Read More...
One of the themes we focused on with Office 2007 was “great looking documents”. For the next half-dozen articles, I am going to explain what that means for Excel, and some of the cross-application features that users will see in Office 2007. Way back
Read More...
