Colorize the borders
June 9, 2010 at 9:13 AM | Posted in General | Leave a commentTags: borders, color, format
I saw an Excel Tips article about changing the color of borders.
As they say:
Many people add borders to cells on a regular basis, yet have no clue that you can change the color of those borders.
I think this is a great tip, and useful in many different situations.
Formatting the chart data tables
May 6, 2010 at 9:41 AM | Posted in General | Leave a commentTags: chart, format, data-table
You probably know that you can place a data table under a chart, along with the data’s visualization. It’s called a chart data table.
I agree with datapig’s complaint that the default formatting for such data tables is horrible, and needs fixing.
It’s not that the data isn’t presented right… it’s just hard to read, in an unnecessary way.
He suggests some very simple re-formatting, which makes the table much more readable to anyone who has eyes (e.g. not an OCR 
).
The secret five-M’s trick
May 5, 2010 at 9:23 AM | Posted in General | Leave a commentTags: date, format, month
datapig was onto something the other day:
I frankly didn’t know about this, but if you write five m’s in the date format, you get the first letter of the month’s name. For example, if you type ‘dmmmmmy‘ as the format for today’s date, May 5th 2010, you end up with 5M10 in the cell.
I digged further and it appears right there in the documentation (look under ‘Guidelines for date and time formats’)… So how come this is such a secret?
I believe that people are just not used to using a sequence of five characters in a format string.
In any case, there you have it, another trick hidden within our lovely Excel
Blog at WordPress.com. | Theme: Pool by Borja Fernandez.
Entries and comments feeds.
