In this article, you will learn how to add Auto Bullet Points in Excel using Custom formatting. To add the auto bullet point in excel range below are the steps- Select the excel range. Press Alt+O+E to open the Format Cells window. Go to Number tab. Got to Custom. Put the below code in Type box- “ ■ General; ■ General; ■ General; ■ General” You can take any other
In this article, you will learn how to apply the Same Chart Format on the other Charts. Let’s say we have month-wise sales data chart and we do some formatting on this, now we want to apply same formatting on day-wise sales chart. [caption id="attachment_15802" align="aligncenter" width="835"] Month-Wise Sales Chart[/caption] Below are the steps: Just copy the month-wise sales chart Select the day-wise sales Go to Home tab >> Paste
In this article, you will learn how to display hidden data on the chart. if we create a chart for month wise sales and hide or collapse few months then those months data will not be visible on the chart. [caption id="attachment_15718" align="aligncenter" width="874"] March to July data is not visible[/caption] If you want to display the hidden data on the then below are the steps- Right click on the
In this article, you will learn how to sort the data by columns. If you have multiple columns in your excel sheet and you want to arrange the order of the columns according to your requirement then you can use this trick. Let’s say we have below given data. [caption id="attachment_15653" align="aligncenter" width="827"] Data set[/caption] Now we want the arrange the columns according to our requirements. Insert a row above
Many times, when we create a chart and our numbers are quite big then our data labels on the chart are not proper readable. In that case we can change the number format of data label of the charts in millions or thousands according to our numbers. To change the number format of data labels just right click on Chart and click on Format data labels. Go to the numbers
In this article, you will learn how to get count of persons from a Date of Birth data whose birthdays are in the specific month. You will also learn how to highlight the data using Conditional Formatting whose birthdays are in This Month, Last Month and Next Month. We have below given Date of Birth data for Employees- [caption id="attachment_14951" align="aligncenter" width="435"] Date of Birth data[/caption] We have created a
In this article, you will learn how to insert a picture in comments. Here I have taken the example for my popular Dashboards which are freely available to download. I have created a table of Dashboards, Youtube tutorial link and Free download link as given in the below image. [caption id="attachment_14560" align="aligncenter" width="1096"] Excel Table[/caption] I have added the comments for each dashboard and inserted the picture of the dashboard
Custom formatting is very useful in Excel. You can display some Icon with colors with the numbers. Here we have taken an example wherein we have displayed designer up/down arrow (➷➹) for Variance %. We have a table for Market wise sales for Current Year and Previous Year. We have displayed Variance % here with designer arrows. [caption id="attachment_12838" align="aligncenter" width="617"] Market Wise Data[/caption] In the Variance % column we
In this article you will learn how to highlight the Unmatched Cells values from another range using Conditional formatting. For Example, we have Sales and Product Master worksheets. In the Sales worksheet we need to highlight the Products which are not available in Product Master. [caption id="attachment_12307" align="aligncenter" width="1496"] Sales Data and Product Master Worksheets[/caption] Below are the steps to put the Conditional Formatting to highlight Product Name in Sales
In this article you will learn how to highlight the Consecutive Duplicates in Excel using Conditional Formatting. You will also learn how to highlight consecutive weekly off in an Attendance Sheet. Let’s say we have month wise sales wherein we have month name duplicate. We want to highlight the consecutive duplicate month as given in below image [caption id="attachment_12290" align="aligncenter" width="282"] Consecutive duplicate month[/caption] Below are the steps to put
