Downloaded 229 times
Uploaded byMuhammad Yasir Bhutta
Formatting in MS Excel
The document provides instructions for formatting cells and cell contents in Excel, including changing cell alignment, merging and splitting cells, wrapping text, applying number formats, borders and styles, setting column width and row height, and other cell formatting options. Key steps include selecting the relevant cells, using formatting tools on the Home tab, and specifying format properties.
In this document
Powered by AI
Discusses how to select cells, and change vertical/horizontal alignment, rotation, and indentation of cell contents.
Describes how to start a new line of text within a cell by double-clicking and using the Enter key.
Explains various number formats like currency, percentage, and date, and how to select formats using dialog boxes.
Describes cell styles, applying predefined styles, and removing styles to ensure consistency in formatting.
Discusses predefined table styles in Excel, how to apply them, and how to clear custom styles.
Explains applying cell borders, including predefined and custom options, along with removing borders.
Describes how to use images as sheet backgrounds in Excel and how to delete them.
Discusses displaying gridlines in worksheets, including altering gridline colors and visibility.
Describes methods for adjusting column widths including setting specific dimensions, using autofit, and copying widths.
Explains how to change row heights, including setting specific values and enabling autofit options.
More Related Content
Formatting in MS Excel
- 4. Select thecell or range of cells that contains the data that you want to reposition. On the tab, in the group, do one or more of the following: › To change the vertical alignment of cell contents, click , , or . › To change the horizontal alignment of cell contents, click , , or .
- 5. Select thecell or range of cells that contains the data that you want to reposition. On the tab, in the group To rotate the cell contents, click , and then select the rotation option that you want. Rotate Text
- 6. Select thecell or range of cells that contains the data that you want to reposition. On the tab, in the group To change the indentation of cell contents, click or
- 7. In aworksheet, select the cells that you want to format. On the tab, in the group, click . Notes :Data in the cell wraps to fit the column width. When you change the column width, data wrapping adjusts automatically.
- 8. Select twoor more adjacent cells that you want to merge. On the tab, in the group, click .
- 9. Select themerged cell. When you select a merged cell, the Merge and Center button also appears selected in the Alignment group on the Home tab. To split the merged cell, click Merge and Center .
- 11. To starta new line of text at a specific point in a cell, double-click the cell, click the location where you want to break the line in the cell, and then press .
- 13. Excel 2007provides a variety of number formats that you can apply to the values (numbers) you enter in a worksheet to make the data easier to interpret. These number formats include: › currency, accounting, percentage, date, time, fraction, and scientific, as well as a few special formats.
- 14. Select thecell(s) containing the value(s) you want to format. Choose a format from the drop-down list in the Number group on the Home tab.
- 15. Select thecells containing the numbers you want to format. From the tab, click the in the bottom-right corner of the Number group. The Format Cells dialog box appears, with the Number tab on top. In the Category list, select Number. Select the Use 1000 Separator (,) check box. Click OK.
- 16. Select thecells containing the numbers you want to format. From the tab, click the in the bottom-right corner of the Number group. The Format Cells dialog box appears, with the Number tab on top. In the Category list, select Currency. From the symbol list select Rs Urdu. Click OK.
- 17. Select thecell(s) containing the value(s) you want to format. Click on in group of tab.
- 18. Enter adate into a cell. From the tab, click the dialog box launcher. Click Date in the Category list Select a format for the selected cells. Click OK
- 21. A cellstyle is a defined set of formatting characteristics, such as fonts and font sizes, number formats, cell borders, and cell shading. To apply several formats in one step, and to make sure that cells have consistent formatting.
- 22. Select thecells that you want to format. On the Home tab, in the Styles group, click Cell Styles. Click the cell style that you want to apply.
- 23. Select thecells that are formatted with the cell style that you want to remove. On the Home tab, in the Styles group, click Cell Styles. Under Good, Bad, and Neutral, click Normal
- 25. Microsoft OfficeExcel provides numerous predefined table styles (or quick styles) that you can use to quickly format a table. If the predefined table styles don't meet your needs, you can create and apply a custom table style.
- 26. StepsExample On theworksheet, select a range of cells that you want to format by applying a predefined table style. On the tab, in the group, click . Under Light, Medium, or Dark, click the table style that you want to use.
- 27. On theworksheet, select the table from which you want to remove the current table style. On the Design tab, in the Table Styles group, click the More button. Click Clear.
- 29. Cell bordersthat you apply on cell in sheets to appear on printed pages. By using predefined border styles, you can quickly add a border around cells or ranges of cells. If predefined cell borders do not meet your needs, you can create a custom border.
- 30. On aworksheet, select the cell or range of cells. On the tab, in the group, To apply a new or different border style, click the arrow next to , and then click a border style.
- 31. On aworksheet, select the cell or range of cells that you want to remove a border from. On the Home tab, in the Font group, click the arrow next to Borders , and then click No Border .
- 33. In MicrosoftOffice Excel, you can use a picture as a sheet background for display purposes only. A sheet background is not printed on paper.
- 34. Click theworksheet that you want to display with a sheet background. Make sure that only one worksheet is selected. On the Page Layout tab, in the Page Setup group, click Background. Select the picture that you want to use for the sheet background, and then click Insert. The selected picture is repeated to fill the sheet.
- 35. Click theworksheet that is displayed with a sheet background. Make sure that only one worksheet is selected. On the Page Layout tab, in the Page Setup group, click Delete Background.
- 37. Gridlines arethe faint lines that appear around cells in Excel 2007. They are used to distinguish cells on the worksheet.
- 38. Click theMicrosoft Office Button , and then click Excel Options. In the Advanced category, under Display options for this worksheet, make sure that the Show gridlines check box is selected. In the Gridline color box, click the color you want.
- 39. Select oneor more worksheets. On the View tab, in the Show/Hide group, clear the Gridlines check box.
- 40. Select oneor more worksheets. On the View tab, in the Show/Hide group, select the Gridlines check box.
- 42. Select thecolumn or columns that you want to change. On the tab, in the group, click . Under , click . In the Column width box, type the value that you want.
- 43. Select thecolumn or columns that you want to change. On the Home tab, in the Cells group, click Format. Under Cell Size, click AutoFit Column Width.
- 44.
- 45. Select acell in the column that has the width that you want to use. On the Home tab, in the Clipboard group, click Copy, and then select the target column. On the Home tab, in the Clipboard group, click the arrow below Paste, and then click Paste Special. Under Paste, select Column widths.
- 46. To changethe width of one column, drag the boundary on the right side of the column heading until the column is the width that you want.
- 47. Select therow or rows that you want to change. On the Home tab, in the Cells group, click Format. Under Cell Size, click Row Height. In the Row height box, type the value that you want.
- 48. Select therow or rows that you want to change. On the Home tab, in the Cells group, click Format. Under Cell Size, click AutoFit Row Height.