Thursday, August 22, 2013

How to Apply Text Attributes Cell Borders in Microsoft Excel


1. Click on the 'Home' tab to display the 'Home' ribbon. For Excel 2003, skip this step.
2. Select the cell or cells to which you want to apply your text attributes.
3. Click on the 'B' button located in the 'Font' section of the ribbon (Excel 2007) or in the formatting toolbar (Excel 2003). This will make your text bold. Click on the 'I' to italicize the text. Click on the 'U' to underline the text. To remove a text attribute, click on the same button you used to apply the attribute.
4. Click on the diagonal arrow in the bottom right corner of the 'Font' section to display the 'Format Cells' dialog box. For Excel 2003, click on 'Format' in the main menu. Then, select 'Cells.' Opening this dialog box gives your more options for formatting your text. Select the options you wish to apply and click the 'OK' button to close the dialog box.
5. Select the cell or cells to which you want to apply cell borders.
6. Click on the arrow next to the square (partitioned into four equal parts) graphic located next to the 'U' in the 'Font' section (Excel 2007) or formatting toolbar (Excel 2003). A drop-down will appear. This drop-down shows the various ways to apply borders to your selection. Select 'Bottom Border' to apply a bottom border to all of your selected cells. There are a variety of ways to apply borders: top, left, right, all, thick, and many more. Play around with the options to become more familiar. You can always select the 'No Border' option to remove all borders from a selection.

Blogger news