Monday, May 28, 2012

Excel and you: More quick tips

Today, as is fitting for a day of vacation, I have a couple of quick tips to speed up your Excel sessions.

First, we have a couple of table making items.

Have you ever created a table with a row of labels that you wanted to be vertical?

Class names, y r u so long?

Well, that’s an easy job, found in the cell format option when you rightclick on a cell.

Go here for fun times!

If you highlight the entire row, you format all of them, so go to the alignment tab, and flip the knob on the right from 0 to 90 or -90, and viola, you have a vertical row!

Much better!

Next, have you ever seen the fancy table where each row alternates colors?  If you thought you had to do that manually, guess again!  There is a handy function in the format as table button, allowing you to color a selection of a table you have created, and it puts in the filter selection automatically!

Look at all the options!

Lastly on this quick little roundup, I’ll deal with decimals.

Have you ever calculated a formula in Excel, only to have the decimals come out all wrong?

Well, if you want to have more, or less numbers after the decimal, there is a quick fix right in the home ribbon!

Why yes, I did spend excessive time on the arrow, thanks for noticing!

To give your number more decimals, highlight the cell, then click the button with the arrow pointing left!  To shrink the number of decimals(this does induce rounding), click the one with the arrow to the right!

And that’s all I have for you today! 

Have you ever thought, ‘I wish I could do x in Excel?'  Leave me a comment, and I’ll try to find a solution for you!

No comments:

Post a Comment