Formatting your spreadsheet

Font

You can apply the Bold, Italic, Underline, or Strikethrough feature to data to highlight it.

Make Text Bold

Perform the following to make text bold.
  1. Select a range of cells with text to be bold.
  2. Click Format-Font-Bold.

Change Font Properties

Perform the following to change font properties.
  1. Select a range of cells whose formatting you want to remove.
  2. Change font, text size, color, and other properties using the menus on the toolbar.

      

 

Number

You can display numbers and formulas in various formats.

Change Format

Perform the following to change the cell format.
  1. Select a range of cells whose data you want to display using a percent sign.
  2. Click Format-Number-Percentage.
    Or click the Percentage cell_format_percentage.png icon on the toolbar to change data format quickly.

Change Decimal Display

Perform the following to change the decimals.
  1. Select a range of cells whose data you want to change the decimals.
  2. Click Format-Number-Accounting.
  3. Click the Increase Decimal cell_format_increase.png icon an many as you want to display decimals on the toolbar.
    You can also reduce the decimal place by clicking the Decrease Decimal cell_format_decrease.png icon on the toolbar.

 

Border

You can use various border styles with various colors to distinguish data.

Apply Cell Border

Perform the following to apply cell borders.
  1. Select a range of cells that you want to change their border styles.
  2. Click Format-Border-All Borders.

Change Cell Border Color

Perform the following to change cell border color.
  1. Select a range of cells that you want to change the border color.
  2. Click the Line Color icon and select a border color from the color palette under the Border section on the Cell task pane.                   
      
  3. Select the border item under the Border section to apply the borders to the selected range of cells.
Was this article helpful?
1 out of 1 found this helpful

Comments

0 comments

Article is closed for comments.