EzineArticles - Expert Authors Sharing Their Best Original Articles



  Submit Articles
  Members Login
  Benefits
  Expert Authors
  Read Endorsements
  Editorial Guidelines
  Author TOS

  Terms of Service
  Ezines / Email Alerts
  Manage Subscriptions
  EzineArticles RSS

  Blog
  Forums
  About Us
  What's New
  Contact Us
  Article Writing Shop
  Advertising
  Affiliates
  Privacy Policy
  Site Map


Advanced Search


Would you like to be notified when a new article is added to the Software category?

Email Address:


Your Name:


Prefer RSS?
Subscribe to the
Software
RSS Feed:

How to Make Bold in Part of an Excel Cell
Print This Article Ezine Publisher Send To Friends Add To Favorites Post A Comment Suggest Topic Report Author

Microsoft Excel offers a large number of formatting options, including the ability to create bold, italics, underline, font color, cell background color and cell highlighting. Other formatting options in Excel include the ability to:

a. change the width of an entire column

b. align cell text or numbers

c. change alter the type of data that Excel recognizes is in the cell (e.g., text, general number, currency, date, etc.)

d. or remove cell borders

e. display data as a table

f. apply pre-configured Cell Styles

Excel even offers a Conditional Formatting feature, meaning that you can have Excel automatically adjust the look of a cell based upon its contents.

Applying Formatting to an Entire Cell, Row or Column

Most formatting features in Excel apply to the entire cell. To apply cell formatting to an entire cell, row, or column, you should first highlight the cell or range (group of cells) in question. Then, in the Home tab in your Excel Ribbon (at the top of your screen), select the formatting option you prefer. Most formatting options are found in the Home tab in the Font, Number, Alignment and Styles sections.

How to Make Bold in Part of an Excel Cell

Formatting features such as bold, italics, and underline can also be applied to just one portion of a cell's contents. To make bold (or add italics or underline) just a part of an Excel cell, you will need to actually enter the cell so that you can directly edit the text therein. Here's how:

1. Click on the cell whose text you want to partially bold.

2. Enter the cell and directly edit the content by clicking on F2 (one of the buttons at the very top of your computer's keyboard). Or, you can use your mouse to click directly on the Formula Bar just above your worksheet.

3. Now, you will notice that when you click on the cell's contents, you can actually highlight just a portion of its contents without highlighting the whole thing. Highlight the portion of the cell you want to make bold using your mouse.

4. While this portion is still highlighted, click on the "B" icon (for bold) found in the Font section of the Home tab. Or, just click [Ctrl + B]. Now press Enter.

You're done! As you can see, just the portion of the cell you highlighted should be bold.

Looking to improve your MS Excel skills? Download your copy of this FREE Excel cheat sheet at: http://www.Untangle-Your-Thoughts.com/.

Article Source: http://EzineArticles.com/?expert=Jed_C._Jones_Ph.D.

Jed C. Jones Ph.D. - EzineArticles Expert Author

Other Recent EzineArticles from the Computers-and-Technology:Software Category:

Most Viewed EzineArticles in the Computers-and-Technology:Software Category (90 Days)

  1. The Benefits of the RegCure Software Product
  2. How to Delete The Total Security Virus From Your Computer - A Total Security Removal
  3. How to Remove Security Tool - Get Rid of Security Tool and Regain Your Safety
  4. How to Remove The Green Antivirus 2009 - Uninstall 'Green AV' Quick and Easy
  5. How to Remove Cyber Security - Uninstall Cyber Security and Get Rid of it Forever!
  6. Javascript Calendar - Add an Event Calendar to Your Website
  7. Fix Windows Vista Shut Down Issues - How to Fix Them in a Very Easy Way Instantly
  8. Follow These 5 Easy Steps - How to Speed Up Computer Instantly - Do the Steps & Speed Up in Minutes
  9. The Best and Simplest Way to Speed Up My Computer - How to Increase Computer Speed Massively
  10. 4 Things You Should Know How to Fix Windows XP Error Messages - Resolve Windows Error Made Easy
  11. Fix BSOD Problem - How to Fix the Blue Screen Physical Memory Dump Easily
  12. 3 Easy Ways How to Fix Bad Pool Caller Issue Instantly - Solving Bad Pool Problem
  13. 3 Steps to Speed Up My Computer - Make Your Computer Work Faster in Minutes!
  14. How to Tweak Windows XP Speed? - Follow These 3 Steps on How to Increase Your Windows XP Speed Now
  15. How to Remove Alpha Antivirus - The Easiest Alpha Antivirus Removal Available!

Most Published EzineArticles in the Computers-and-Technology:Software Category

  1. Workstation Optimizer - What is It? And Does it Work?
  2. How Do I Get Rid of a Trojan Virus From Your Computer? Best Tips to Protect Computer From Virus
  3. Need a Trojan Horse Remover? Remove Trojans Virus Easily and Effectively
  4. Internet Antivirus Pro Removal - 3 Top Ways to Protect Your Computer From Trojan Virus Instantly
  5. Trojan Virus Removal - 3 Steps How to Get the Trojan Virus Off My Computer Quickly
  6. Learn 5 Fast Steps Instructions of Removing Personal Antivirus From Your Computer
  7. 3 Fast Ways - How Do I Get Pav Exe off My Computer? What Should You Do?
  8. Remove PAV - 3 Top Tips How to Conduct A PAV Virus Removal
  9. How to Remove Google Redirect Virus? Use These Google Redirect Virus Fix Instructions to Fix Your PC
  10. How to Remove Antivirus System Pro - Follow These Instruction in 5 Minutes
  11. How Do I Get Rid of Personal AV Instantly? Remove it Now in Less Than 5 Minutes
  12. Google Redirect Virus Removal - 5 Steps How to Get Rid Of Google Redirect Virus Instantly
  13. 6 Easy Ways to Do Internet Antivirus Pro Removal - How to Remove Internet Antivirus Pro Instantly!
  14. How to Completely Remove Trojan Horse Instantly - Use This Trojan Horse Remover Now!
  15. How to Remove Crazy Trojan Horse Virus Quickly? Use Automatic Trojan Horse Removal to Get Rid of It

 

This article has been viewed 88 time(s).
Article Submitted On: October 14, 2009



© EzineArticles.com - All Rights Reserved Worldwide.