109 Excel | How to compare values visually? episode artwork

EPISODE · Dec 17, 2010 · 0 MIN

109 Excel | How to compare values visually?

from Daily Office Tips by Office ToDo · host Office ToDo

Perhaps the easiest way is to enter the data bars inside the cells. To do this, select the cells you wish to be analyzed and go under Home tab into Style section. From the row click on the first button called “Conditional Formatting”. From there click on “Data Bars” and apply the style of your liking. Another option would be to add icons inside the cells representing the values compared to other values in the selection. Again, go to the “Conditional Formatting” button and choose “Icon Sets” from the menu. This view offers more possibilities so hover over to see the preview and decide which suits you best. - Office ToDo

Episode metadata supplied by the publisher feed · Published Dec 17, 2010

Embed this episode

NOW PLAYING

109 Excel | How to compare values visually?

0:00 0:44

No transcript for this episode yet

We transcribe on demand. Request one and we'll notify you when it's ready — usually under 10 minutes.

No similar episodes found.

No similar podcasts found.

Frequently Asked Questions

How long is this episode of Daily Office Tips by Office ToDo?

This episode is 0 minutes long.

When was this Daily Office Tips by Office ToDo episode published?

This episode was published on December 17, 2010.

Can I download this Daily Office Tips by Office ToDo episode?

Yes. Use the download control on the episode player to save the publisher-provided media file.
URL copied to clipboard!