This has been a guide to Formatting in Excel. We can add more conditions in the data through this option, like if data is less than 40 or greater than 60, so how the data look in this condition.
![how to pin a document in excel how to pin a document in excel](https://i.pinimg.com/736x/71/3c/90/713c905c3c06e67b51b3c89a38dd34b8--pixel-gay.jpg)
It will open the conditional formatting toolbox.For this, Select the data and do the right-click. Excel provides a very interesting feature through which we can do a quick analysis of our data.Through this option, we can do the formatting of the chart as per our requirements. When we insert the chart for the data as we created in Example 3, it will open the chart tools menu.ALT+H+V – It will open the paste dialog box.CTRL+C – Copy the data, CTRL+X – Cut the data, CTRL+V – Paste the data.Through which we can save a lot of time and effort. There are a lot of shortcut keys available for data formatting in excel.Data Formatting saves a lot of time and effort.Through the chart, we can easily analyze the data.Through formatting, we can highlight specific data like profit or loss in business.Click on Column Chart, Select Stacked Column under 2-D Column Chart. Select whole data and go to the Insert menu.Now we want to present this data in pictorial format. Now our data is looking like the below screenshot:Īgain we are assuming the same data.
![how to pin a document in excel how to pin a document in excel](https://support.content.office.net/en-us/media/d442e1e0-ff37-4214-8352-e7c56decc3c8.png)
We also can make the border of this data to look more visible by clicking on the Border button. In this example, we are choosing a bold font size of 12, the color of Orange.We can change the font type, style, size, color etc. This button has a lot of font styles available. Through the Alignment button, we can align the font in a different style.Through the Number button, we can change the data type like decimal, percentage etc.As we can see, there are a lot of options available to change the font style in various styles as we want. This will open a Format Cells dialog box.Select the whole records of that data and do the right-click.Now we want to highlight the Wednesday data. Let’s take an example of weather prediction of different cities day wise.
![how to pin a document in excel how to pin a document in excel](https://cdn.ablebits.com/_img-blog/ribbon/pin-ribbon-excel.png)
Let’s take the below data and will understand the data formatting in excel one by one. “B” is to make the font bold, “I” is for italic, “U” is for make underline, etc. In the below image, we have shown different font styles:
![how to pin a document in excel how to pin a document in excel](https://ih1.redbubble.net/image.1713020301.4030/ur,pin_small_back,tall_portrait,750x1000.jpg)
With this, we can add a border of the cells. For border style, Go to the Font section and click on an icon as per the below screenshot: Make the outline border of the heading field.The header field background color should be other than white color so that it should be properly visible in the data.The header font size should be larger than the other content of the data.It’s also available in the Font section in the toolbar. The column heading/row heading is a very important part of the report.Follow the below guidelines while formatting the data/report in excel: There are a lot of ways to format data in excel. Excel functions, formula, charts, formatting creating excel dashboard & others