Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

You can help improve the readability of a worksheet by applying different types of formatting. For example, you can apply borders and shading to help define the cells in a worksheet.

How?

Icon image

Apply cell borders

  1. Select the cell or range of cells that you want to add a border to.

    Tips: 

    • To quickly select the whole worksheet, click the Select All button.

    • Select All button

  2. On the Home tab, in the Font group, click the arrow next to Borders Button image, and then click the border style that you want.

    Borders button in the Font group

Tip:  The Borders button displays the most recently used border style. You can click the Borders button (not the arrow) to apply that style.

Icon image

Change text color and alignment

  1. Select the cell or range of cells that contain (or will contain) the text that you want to format. You can also select one or more portions of the text within a cell and apply different text colors to those sections.

  2. To change the color of text in the selected cells, on the Home tab, in the Font group, click the arrow next to Font Color Button image, and then under Theme Colors or Standard Colors, click the color that you want to use.

    Note:  To apply a color other than the available theme colors and standard colors, click More Colors, and then define the color that you want to use on the Standard tab or Custom tab of the Colors dialog box.

  3. To change the alignment of the text in the selected cells, on the Home tab, in the Alignment group, click the alignment option that you want.

    Excel  Ribbon Image

    For example, to change the horizontal alignment of cell contents, click Align Text Left , Center , or Align Text Right .

Apply cell shading

  1. Select the cell or range of cells that you want to apply cell shading to.

  2. On the Home tab, in the Font group, click the arrow next to Fill Color , and then under Theme Colors or Standard Colors, click the color that you want.

Next steps

For more information and detailed instructions on formatting a worksheet, see the following topics:

Need more help?

You can always ask an expert in the Excel Tech Community or get support in Communities.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×