Register Blogs Advertise with usHelp Desk Today's Posts Search

Rate this Entry

Make an Excel List Easier to Read

Submit "Make an Excel List Easier to Read" to Facebook
Posted 17th March 2012 at 12:33 PM by ddalgleish

If you're selling items online, you can usually export the sales date, and open the exported file in Excel.

Hopefully your list of sales will be very long! That's good for your bank account, but a long list can be hard to read on the computer screen.

To make the list easier to read, you can do two things:

  1. Create an Excel table, and use the built-in styles, to add bands of color
  2. Add lines to separate the dates, to quickly show where the sales dates start and end.
In the screen shot below you can see a red line at the start of each date.

Watch the Video

To see the steps for adding the date lines with Excel conditional formatting, you can watch this short video tutorial:
Separate Dates in Excel List With Lines
Views 578 Comments 0
Total Comments 0



All times are GMT -6. The time now is 01:03 PM.