Skip to main content

How to add up\down arrow in excel..

Excel is a sea of very useful and compelling features. You just need to give proper time to explore and operate it in the best possible way. Here I am going to demonstrate how to portray your percentage data in excel in a way that not only looks professional but also, a great way to impress your colleague and boss with your reporting skills. 

Let’s begin:

Below is the sample table which we are carrying here to demonstrate this tool to you

So, in this data table, in the 'Difference' column we want to exhibit increase\decrease arrows to show if the sales went above the defined target or down.


Step 1. Go to the 'Insert' tab from the menu and select 'Symbols' from the right side. ( Refer to the below image)


Step 2. A new dialogue box will appear with multiple options. Just choose required titles as shown in the below image and add both up & down arrows to your excel sheet. (Refer to the below image)



Once the selection is complete, add both the symbols one by one by clicking the 'Insert'  button from the bottom. Press the 'Cancel' button from the bottom once done.

Step 3. Before we proceed further, select, and copy both the symbols first.


Step 4. Now go your data and select an entire data columns for which you want to add these up\down arrows and right-click. Select 'Format Cells' from the list of options in the next window. 

For instance, in our example, we want to insert these to our E (Difference column) to show the percentage of sales target difference if it was positive or negative (Refer to the below image)



Step 4. In the next window, go the 'custom' and choose 0.00% from the options available under Type Tab and paste both copied symbols prior to that just like we did in the below image.


Step 5. Now add a semicolon after 0.00% and cut (CTRL + X) down arrow from the initial and paste (CTRL + V) it after the semicolon. Once this is done, you need to add correspondence colors against each arrow between [ ] brackets. Follow the below image: 


In the above screenshot, I have commanded that all the minus ( - ) values in the data table should be considered as down and others must be up. So, all the negative percentage values would appear as red with a down arrow and positive ones as green with the up arrow.

Step 6. After you are done with these entries, press ok. Your data will be updated as the below image as you were anticipating.

Labels:

Comments

Post a Comment

Popular posts from this blog

How to create a webinar through Microsoft Teams with customized registration form for attendees

Microsoft Teams has a great range of features. Not only do they help us to schedule a meeting and connect with your co-workers instantly through chat or call, but also you can access your files stored on Microsoft cloud instantly when & where required. But here I am going to tell you about the feature which allows you to plan a webinar through Teams following simple steps, and you can also add customized forms for attendees to fill out to register for the webinar. I will show you how to schedule a webinar and add a response form to it for attended: 1. Start with going to your Microsoft teams and select Calendar from the left Panel. (Refer to the below screenshot) 2. Now on the right top-hand side, you can see a down arrow near the  New meeting  button. You will get three choices by pressing that arrow button which are Schedule meetings, webinars and live events. Please click on  Webinar . 3. In the next windows, you will have several options. We will start with cre...
Post a Comment
Read more

How to add CC recipients in Mail-Merge

Please refer How to do a Mail-Merge in MS Office to pursue this article further. I am going to explain the steps to send personalized emails to a huge group of receipts by looping people\groups in an email CC. Though, there is no straightforward technique for doing so. But there is one trick that functions like a charm. The trick is that we will create a new outlook rule which indicates whenever we send an email with the specific subject line, it will automatically include certain group\people in the CC. Steps to create this new rule in Outlook 1. Go to Rules in the menu bar and select Manage Rules & Alerts. 2. Then a dialogue box will appear. Click on the New Rule and choose Apply rule on messages I send in the following wizard (refer to the below screenshot) and Click Next. 3. In the subsequent window, tick the first line, which says with specific words in the subject line in Step 1 and click on a specific word from Step 2 (Refer to the below screenshot). 4. On clicking ...
Post a Comment
Read more

These instructions will allow you to save password-protected PDF attachments from Gmail to Google Drive.

Discover how to automatically save PDF attachments that require a password from Gmail to Google Drive and transform them into unencrypted versions that can be accessed conveniently washout a password. Financial statements are frequently sent by financial institutions as password-protected PDF files, including banks and credit card firms. Passwords formed from personal information, like your birthdate, Social Security number, or a special mix of details, are frequently used in these attachments. To access password-protected PDF files, you must enter the password each time. While Google Chrome allows for the permanent removal of passwords from PDFs, the manual and time-consuming nature of the process can be burdensome, especially if you have a substantial number of such attachments in your Gmail inbox. Imagine how easy it would be to have a solution that downloads all of your password-protected PDF attachments from Gmail straight to Google Drive and converts them into PDF files that aren...
Post a Comment
Read more