Using Excel 2013 Formatting Cells

By default, all cell contents use the same format, which can make it difficult to read workbooks that contain a lot of information.

Basic formatting customizes the look and feel of your workbook, enabling you to draw attention to specific sections and making your content easier to see and understand.

You can also apply number formatting to tell Excel exactly what type of data you are using in your workbook, such as percentage (%), currency ($), etc.

Change font:
By default, the font of every new workbook is set to Calibri. However, Excel provides many other fonts that you can use to customize cell text. In the example below, we’ll format the header cell to help distinguish it from the rest of the worksheet.

text alignment
By default, any text entered into the worksheet will be aligned to the lower left corner of the cell, and any numbers will be aligned to the lower right corner. Changing the alignment of cell content allows you to choose how the content is displayed in any cell, which can make your cell content easier to read.

Change horizontal text alignment:
In the example below, we’ll modify the alignment of the header cell to create a more polished look and further differentiate it from the rest of the sheet.

Cell borders and fill colors
Cell borders and fill colors allow you to create clear and defined boundaries for different parts of the worksheet. Below, we’ll add a cell border and fill color to the header cells to help differentiate them from the rest of the worksheet.

Office key

Leave a Reply

Your email address will not be published. Required fields are marked *