When formatting text within an Excel worksheet, you have the choice of working at the cell level or at the text level. If you wish to work at the cell level you simply highlight one or more cells and choose your format settings. Any formatting that you choose will then apply to all text within the cell or cells.
For example, to change the font size of your data in Microsoft Excel, you can of course use the drop-down menu next to the font name and choose one of the preset sizes. Another way of changing the size is to use the Grow Fond and Shrink Font buttons located on the right of the font size. These two buttons simply take you up and down the same preset sizes available on the preset size drop-down. You can also use the cursor keys on your keyboard to move through different sizes. Yet another option is to enter a particular size then press the enter key. When doing so, you are permitted to enter decimals, such as 10.5.
In a similar way, when you want to choose a font, you can highlight the current name and start to type the name of font you have in mind, for example Times new Roman. Once you have typed enough to let Excel know which font you mean, the font name will be displayed and you simply press the Enter key.
Colour can be similarly be applied in two ways in your worksheets either as a background to the cell or to the text inside the cell. Because background colour applies to the cell it cannot be applied at the text level. With the creation of Themes in Excel 2007, Microsoft have made it very easy to come up with colour combinations which look good together.
To work at the text level, you need to go into Edit mode. You can enter Edit mode in a couple of ways: the first is to double-click on any cell; the second is to click once on the cell and then click anywhere in the formula bar. You will know when you're in Edit mode by the appearance of the Cancel and Enter buttons on the left of the formula bar.
When working in Edit mode, it becomes possible to highlight individual characters and change their attributes. For example, say a cell contains the text "Google"; you could highlight each letter individually and change it to the colour used in the Google logo.
This facility of having different formats within the same cell is very useful for headings. It is not so useful for the rest of the data in your worksheets since it slows down data entry and makes editing difficult.
For example, to change the font size of your data in Microsoft Excel, you can of course use the drop-down menu next to the font name and choose one of the preset sizes. Another way of changing the size is to use the Grow Fond and Shrink Font buttons located on the right of the font size. These two buttons simply take you up and down the same preset sizes available on the preset size drop-down. You can also use the cursor keys on your keyboard to move through different sizes. Yet another option is to enter a particular size then press the enter key. When doing so, you are permitted to enter decimals, such as 10.5.
In a similar way, when you want to choose a font, you can highlight the current name and start to type the name of font you have in mind, for example Times new Roman. Once you have typed enough to let Excel know which font you mean, the font name will be displayed and you simply press the Enter key.
Colour can be similarly be applied in two ways in your worksheets either as a background to the cell or to the text inside the cell. Because background colour applies to the cell it cannot be applied at the text level. With the creation of Themes in Excel 2007, Microsoft have made it very easy to come up with colour combinations which look good together.
To work at the text level, you need to go into Edit mode. You can enter Edit mode in a couple of ways: the first is to double-click on any cell; the second is to click once on the cell and then click anywhere in the formula bar. You will know when you're in Edit mode by the appearance of the Cancel and Enter buttons on the left of the formula bar.
When working in Edit mode, it becomes possible to highlight individual characters and change their attributes. For example, say a cell contains the text "Google"; you could highlight each letter individually and change it to the colour used in the Google logo.
This facility of having different formats within the same cell is very useful for headings. It is not so useful for the rest of the data in your worksheets since it slows down data entry and makes editing difficult.
About the Author:
The writer of this article is a developer and trainer with Macresource Computer Solutions, an independent computer training company offering Microsoft Excel 2007 training courses at their central London training centre.
No comments:
Post a Comment