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

Beauty Insides- Temu- DNM Matte Long Lasting Canster Lipstick- Reviews

When it comes to enhancing our lips, the possibilities are seemingly limitless: lipstick, lip gloss, lip stain. However, in the realm of cosmetics, often the little things have the biggest effects. Now for the little capsules lip colors on Temu—the unsung heroes of the cosmetics industry. What exactly is so great about these tiny lip colors, you ask? Let's explore the wonders of these small yet powerful devices that can drastically alter your appearance. A Shade for Every Mood There are eighteen different colors in a single packet, which makes them handy in a variety of occasions. These are an extensive range of tints and finishes available in little lip colors to suit any mood or occasion. There's a tiny lip color out there waiting to match your style and express your mood, whether you want a sheer, glossy, or matte appearance. Its you who will decide how want to carry one. Affordable Luxury When comparing the pricing of these small lip colors to their full-sized equivalents, ...
Post a Comment
Read more

All you need to know about Service now ITSM Standard & ITSM Professional

ServiceNow offers two primary editions for its IT Service Management (ITSM) solution: ITSM Standard and ITSM Professional. Here's an explanation of each edition: ITSM Standard: ITSM Standard is the foundational edition of ServiceNow's ITSM offering. It provides essential ITSM capabilities to streamline service delivery and improve IT support processes. Key features of ITSM Standard include: Incident Management: Allows IT teams to log, track, and resolve incidents efficiently, minimizing service disruptions and reducing downtime. Problem Management : Helps identify the root causes of recurring incidents and facilitates proactive problem resolution to prevent future disruptions. Change Management: Enables IT teams to plan, assess, and implement changes in a controlled manner, reducing risks and maintaining service stability. Service Catalog : Provides a self-service portal where users can request IT services, track their requests, and access knowledge articles to find answers t...
Post a Comment
Read more

Unveiling the Future: Exciting New Discoveries in the Realm of Information Technology

Information Technology (IT) continues to reshape our world at an astonishing pace, and recent advancements have unveiled groundbreaking discoveries that promise to revolutionize our digital landscape. From cutting-edge hardware innovations to groundbreaking software breakthroughs, the realm of IT is witnessing an era of unprecedented progress. In this article, we will explore some of the most intriguing new discoveries that are reshaping the way we interact with technology and opening up new possibilities for the future. Quantum Computing: A Paradigm Shift Quantum computing, long regarded as the holy grail of computational power, has made remarkable strides in recent years. Researchers have made significant breakthroughs in overcoming the limitations of qubits, the fundamental units of quantum information. These advancements have led to the development of more stable and scalable quantum systems, making quantum computing a tangible reality. With their unparalleled processing power, qua...
Post a Comment
Read more