Adding background color for readability


show more Adding background color for readability provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010 Power Shortcuts show less
please wait ...

Adding background color for readability

When you are looking at a large database sometimes it becomes difficult to read, particularly if it's got a lot of dense scientific data. This one might be not so bad, but how about this one here, this particular worksheet which has a lot of scientific data? And one thing that would help would be to somehow be able to add color to every tenth row, every sixth row, whatever seems to fit your needs. One approach could be to turn this into a table, and in Excel if you click the Insert tab and choose Table, Excel quickly figures out the range of your data, click OK, and you can get this effect. That would certainly make it more readable, and there are quite a few variations in here. But maybe what you would like to be able to do is to control this with your own sets of colors and possibly your own groupings.

Maybe it makes sense to look at this data and think of it as pieces five and ten, for example, five rows, every ten rows, something like that. So, although this might be appropriate ...

Adding background color for readability
Video duration: 3m 43s 3h 43m Intermediate

Viewers:

Adding background color for readability provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010 Power Shortcuts

Subject:
Business
Software:
Excel
Author:
please wait ...