Formatting in Excel

 Formatting in Excel

Formatting in Excel

You have the freedom to format your data to make it look more professional. You could see different options on the Home ribbon to format cells and also data. You need to select the cell or cells which you plan to format and select appropriate formatting options.

Under Home ribbon, there are mainly three groups of tools including Font, Alignment and Number in order to format the cells visually.

Using the tools in Font group, you can: change the size and font of the data, make the text bold, italicized or underlined, include borders, and change the background color. Tools in Alignment group can be used to: position your data in the top, centre, bottom, left or right within a cell, change the orientation of the font, decrease or increase the margin space between the border and text within the cell, make the entire content display within the same cell without overflowing to other cells (wrap text), join cells across different rows and columns and center the text (merge and center).

You can use the options in Number group to determine how Excel need to understand and represent the data you enter. If you enter a number and wish Excel to consider it as currency, then you can achieve this with tools in Number group. You can make the data in accounting format, increase or decrease the number of decimals, include percentage or comma to the data and so on using these tools. You have Cells group in order to insert or delete cells, rows, columns or even worksheet. You can also make them visible or invisible; change the height or width of cells and much more with options in Cell group. If you just wish to adjust the width of the column or height of the row, then you can manually do it by dragging the boundary between two columns or two rows. You can achieve this also by clicking AutoFit Row Height or AutoFit Row Width in Cells Format group. You can also type the value of height or width after going to Row Height or Column Width.

You can use the Format Painter option in Clipboard group if you wish to use the same formatting options applied on a cell to another cell. You just need to select the cell whose formatting is to be copied, click on the Format Painter icon and then select the cell or cells to which you need to apply those formatting attributes. You can get all different formatting options by right clicking the cell and clicking on Format Cells option. You will get a window as given below.

Then, you can go to the required tab and apply proper formatting.

If you have lots of data in your worksheets and you need to scroll to the right and bottom very often, then you could not be able to see the column or row labels. This will be very difficult while working with actual data. Excel provides an option to make specific columns or rows visible always though you scroll through the worksheet. Click the View tab and then Freeze Panes option. You can keep the top row or first column or specific rows and columns fixed using three different options.

If you use these formatting options appropriately, it will make your Excel workbook more professional and user friendly. But, you should know which tool is to be applied for making the best use of it. For example, if you wish to make your accounting activities easier, then you can select the Accounting option in Number group, so that you can concentrate more on your work as Excel will take care of the number formatting.

Read More about Excel here

Leave a Reply