Formatting Tips in Excel

Question

What are some formatting tips in Excel?

Answer

The row titles will stand out better if they are in bold type. You click the column with the titles and then, on the Home tab, in the Font group, you click Bold.

While the titles are still selected, you decide to change their color and their size, to make them stand out even more.

  • In the Font group, you click the arrow on Font Color, and you see many more colors to choose from than before in Excel. You can see how the title will look in different colors by pointing at any color and waiting a moment. This preview means that you don't have to make a selection to see the color, and then undo your selection if it's not what you want. When you see a color you like, click it. 
  • To change the font size, you can either click the Increase Font Size button , or you can click the arrow beside the Font Size box to see a list of sizes (this method gives you the same live preview as for font colors).
  • While the titles are still selected, you decide to center them in the cells. In the Alignment group, you click the Center button, and that's done.

For more information about Microsoft Excel Basics, please view the full tutorial from the CTL here: Excel Part 1

If you need further assistance, please click the CTL Support Request button on this page.

CTL Support Request

Details

Article ID: 7870
Created
Thu 12/22/22 11:21 AM
Modified
Fri 11/3/23 3:35 PM
KCS Article Status
WIP: Only Problem & some Environment captured
Not Validated: Complete & Resolution captured, confidence lacks in structure, content, no feedback
Validated: Complete & reusable, used by licensed KCS user, confidence in resolution & std. compliance
Validated

Related Services / Offerings (1)

The Center for Teaching & Learning develops and supports a diverse and inclusive community dedicated to excellent teaching, learning, and student educational experience regardless of location, formality, or modality.