The process of determining the final appearance of the worksheet and the data it contains is called formatting, and it is the subject of this chapter. The formatting options in Excel give you a lot of control over how your data appears on your spreadsheet.

You can change the font style, font size, font, or color for any cell entry. You can also wrap text entries in the cell or center them across the selection and adjust the orientation of items in the cells in several ways, like vertical, horizontal, and direction. You can use several built-in number formats or create your custom format for dates, numerical values, and timings. You can use various borders, designs, and colors in the cells that contain your data. You may also specify the most appropriate column widths and row heights to the worksheet grid itself so that the data in the structured worksheet is presented to its greatest advantage.

Formatting chosen data tables in an Excel worksheet has never been simpler or faster, thanks to the FORMATTING and TABLES choices on the Quick Analysis tool, as well as the immediately available mini-bar with it’s often used formatting buttons. 

If those options aren’t enough, the Table Styles and Cell Styles galleries, as well as all the command buttons in the Alignment, Font, and Number groups on the Home tab of the Ribbon, are available to make your spreadsheet data seem exactly perfect.

This is due to Excel’s Live Preview feature, which allows you to see how a new typeface, font size, table, or cell style will look on your data extracted before implementing it (saving you tones of time otherwise wasted applying format after format until you finally select the right one). 

You can now fine-tune the formatting of a cell in a worksheet by performing practically all needed adjustments right from the Ribbon, owing to buttons for all the most regularly used formatting commands being right up front on the Home tab.

By admin