• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 2. Format Annoyances > CELL FORMATTING ANNOYANCES

CELL FORMATTING ANNOYANCES

FORMAT PART OF A CELL'S CONTENTS

The Annoyance:

OK, I'll come clean: I've been using Excel for only a couple of days, and I'm not that great with computers anyway. But I did finally figure out how to format a cell: I click it and do whatever I want with the buttons on the Formatting toolbar, or sometimes I choose Format → Cells and work with the Format Cells dialog box. But how do I format part of a cell's contents? There has to be a way to make a single word bold!

The Fix:

This is so easy you'll kick yourself when I tell you. To format part of a cell's contents, click the cell to display its contents in the Formula Bar just above the worksheet and below Excel's toolbar. Select the characters you want to format in the Formula Bar, and use the buttons on the Formatting toolbar to change the characters' appearance. This might seem basic, but you'd be surprised how many folks miss this.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint