Excel sheets can be awfully drab, and if you’ve got a lot of data to look at, the reader’s eyes might start to drift aimlessly over the page. Adding a splash of color, however, can make a spreadsheet more interesting and easier to read, so try shading every other row.

You may also enjoy this csi divisions excel spreadsheet trending images

Excel sheets can be awfully drab, and if you’ve got a lot of data to look at, the reader’s eyes might start to drift aimlessly over the page. Adding a splash of color, however, can make a spreadsheet more interesting and easier to read, so try shading every other row.

Sometimes Excel is much more than you have ever imagined. When it comes to manage tons of data values, you can’t ignore its stupendous capability that makes things easier for you. All you need is a single formula and almost everything that you do manually can be done automatically.

Sometimes, you may want to reorganize data and combine info from different Excel cells into one entry. You can do this using the concatenate function. In this example, we have a basketball fantasy league roster, with fields for players’ last names, first names, and positions. If we want to combine all that information in one field, we will need a formula that reads “=concat(first cell, second cell, third cell),” or, in this case, “=concat(C6,B6,D6)” without the quotes.

Unfortunately, concatenate doesn’t automatically put spaces between text from different cells. To make an Excel space appear, you will need to add quotation marks with a space in between. Now the function should read “=concat(C6,” “,B6,” “,D6).”