Saturday, August 13, 2011

How to sort colored cells from left to right in ms excel ?

Excel provides support for sorting a range based on the cells colors. If you want to sort based on cell color (by either the background fill color or the font color),

Don’t worry about if picture is not visible, hope you can able to make out cell colored. Color given location wise.

We going to learn how to sort colored cells from left to right in Ms excel.

First select the Table.
Click the " Sort" under Data. or press Alt+A+S to open "sort" window

In sort window click
"Options..." to choose sort " sort top to bottom" or "sort left to right".

click ok

Then Choose following in sort window.

Sort by = Table Header Row number
Sort on = Cell color (Even you can choose "Cell font" color if u want to sort by cell font color)
Order = Choose which ever color you want first in left.

Add level 's
to order the color.
after added 4 level Click ok.

you can make out below table got changed.

Drop your comments

Wednesday, August 10, 2011

How to Split MsExcel worksheet? How to view multiple excel file in same window?

Mostly Known option

How to work multiple excel file in same window? How to split Excel sheet?

To open multiple window for current document

Click view and click"New window" thrice if you want to open 3 window for same file.

If you Click Arrage all , "Arrage windows" will open ,

we can choose the option we want. I have selected “Vertical”

If you want to work different location in a same sheet.

How can we split Microsoft Excel window?

We can split the window Vertical and Horizontal

Split the window Horizontal

Double click Right top corner to split Horizontal

Current window will split in to two. Double click on top of the line to come b

ack to normal view

Split the window Vertical

Double click Right Bottom corner to split Vertical.

Even you can select View-split

If you click "split" window will split, if you click again split will remove from window. It will work like ON OFF switch.

share your inputs.

Twitter Bird Gadget