Book Image

101 Excel 2013 Tips, Tricks and Timesavers

By : John Walkenbach
Book Image

101 Excel 2013 Tips, Tricks and Timesavers

By: John Walkenbach

Overview of this book

Excel is a popular program. Millions of people throughout the world use it on a regular basis. But it’s a safe bet that the vast majority of users have yet to discover some of the amazing things this product can do. 101 Excel 2013 Tips, Tricks, & Timesavers?is packed with information that you need to know in order to confidently and seamlessly master the challenges that come with using Excel! Excel 2013 is excellent, but there's lots to learn to truly excel at Excel! In this latest addition to his popular Mr. Spreadsheet's Bookshelf series, John Walkenbach, aka "Mr. Spreadsheet," shares new and exciting ways to accomplish and master all of your spreadsheet tasks. From taming the Ribbon bar to testing and tables, creating custom functions, and overcoming "impossible" charts, mixing nesting limits, and more,?101 Excel 2013 Tips, Tricks, & Timesavers?will save you time and help you avoid common spreadsheet stumbling blocks.
Table of Contents (10 chapters)
Free Chapter
1
Cover
2
Table of Contents
3
Title Page
4
Introduction

Tip 99: Changing the Look of Cell Comments

Cell comments are useful for a variety of purposes. But sometimes you just get tired of looking at the same old yellow rectangle. This tip describes three tricks that you can use to make your comments stand out:

→ Format a comment.

→ Change the shape of a comment.

→ Add an image to a comment.

note.eps All of these changes require that the cell comment is visible. If the comment isn’t visible, right-click the cell and choose Show/Hide Comments from the shortcut menu.

Setting up your Quick Access toolbar

The operations described in this tip require commands that aren’t normally available in the Ribbon when a comment is selected. So the first step is to add three commands to your Quick Access toolbar:

1. Right-click the Quick Access toolbar and choose Customize Quick Access Toolbar.

The Customization section of the Excel Options dialog box appears.

2. From the Choose Commands From...