Cell displays a conditional format arrow Icon set which is on far left side of cell. The number in that cell is right aligned and I want to bring the arrow directly next to the number. I want the arrow to be closer to the number in the cell as i have other cells with arrows and it is confusing which arrow belongs to which box.
There is no way to move the icon set. However, you can achieve a visual effect that will help eliminate confusion with multiple columns displaying icons.
Highlight the column which you wish to bring the numbers and icon closer together.
Right Click.
Select Format Cells.
Click the Alignment tab if it does not appear by default.
Locate the Horizontal Text Alignment drop down box.
Select Right (Indent)
Change the Indent value to one that moves your numbers to a position that visually eliminates the confusion.
Click OK.
Check the results and adjust the Indent value as necessary.
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments