arrow

sksanjeev786

Well-known Member
Joined
Aug 5, 2020
Messages
939
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Hi Team,

Can i get the hollow arrow in excel or PPT with text format

1721936466702.png
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
You just have to find a font that has those characters (or similar) and set your cell font to that.
Arial has some basic ones but not that one that I could find.
 
Upvote 0
You just have to find a font that has those characters (or similar) and set your cell font to that.
Arial has some basic ones but not that one that I could find.
Hi Sir,

Thanks for checking on this:)


Yes! I even checked with other fonts but could not get a hollow arrow with the same format.

Regards
Sanjeev
 
Upvote 0
I found the icons online and pasted them into the cells. See if this helps.
Book3
ABC
111161
211163
Sheet1
Cell Formulas
RangeFormula
B1:B2B1=UNICODE(A1)
C1:C2C1=UNICHAR(B1)
 
Upvote 0
I found the icons online and pasted them into the cells. See if this helps.
Book3
ABC
111161
211163
Sheet1
Cell Formulas
RangeFormula
B1:B2B1=UNICODE(A1)
C1:C2C1=UNICHAR(B1)
Hey Cubist,

Thanks for checking on this but I need Hollow Arrow (completely unfilled) currently arrow has half black so I need with out that in text format
 
Upvote 0
Upvote 0
Hey Cubist,

Thanks for checking on this but I need Hollow Arrow (completely unfilled) currently arrow has half black so I need with out that in text format
Ok, but that's not what you asked for in the OP. Is this what you're looking for? I grabbed those from @Scott Huish link.
Book1
AB
18679
28681
Sheet5
Cell Formulas
RangeFormula
B1:B2B1=UNICODE(A1)
 
Upvote 0
Ok, but that's not what you asked for in the OP. Is this what you're looking for? I grabbed those from @Scott Huish link.
Book1
AB
18679
28681
Sheet5
Cell Formulas
RangeFormula
B1:B2B1=UNICODE(A1)
Hello sir,

I need the same format arrow mentioned in post 1 but arrow format should be unfilled collor(hollow arrow but same format as post 1
 
Upvote 0
What you need to do is select the cell that you want to display the Arrow and use the Insert Tab and then Symbol on the right search down for Wingdings and then look for the up or down arrow as needed. Example is shown below:

Example in cell.png


I have used cell G1 and inserted the first symbol via the Insert Tab and Symbol on the right. Dialog box is shown below:

Arrow images.png
 
Upvote 0

Forum statistics

Threads
1,221,539
Messages
6,160,412
Members
451,644
Latest member
hglymph

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top