- Jul 1
Flexible Arrow Format in a Cell in Excel
- Neale Blackwood
- Tips & Shortcuts
- 0 comments
Sometimes you like to point to a cell from the cell on the left using something like ===>. Here is an easy way to automate the length of the arrow based on the width of the cell.
Sign up to hear about free Excel training.
I won't share your email with anyone.
1 min read
The solution involves a custom number format.
In the image below you can see this format in action.
Custom number formats are entered in the Format Cells dialog and the Number tab.
The format for a right pointing arrow is.
@*=">"Point to the left
You can achieve a similar effect pointing to the left – see image below.
The format for a left pointing arrow is.
"<"*=@