Miscellaneous

How to sort coloumns or rows by color in excel 2003

Wednesday, December 28, 2011 Posted by Satya

Hi.. Friends....
After long time, i am going post an excel tip for
sorting by color. Yesterday when i was working on excel, i got this probelm. Actually this color sorting is available in excel 2007, but not in excel 2003. some times we have to submit different fields data which was completed by you but indicates by different colors. Then we need to sort by those colors. For that i got a small solution.
We have to give formula in first beside coloumn cell what we are going to sort out. Later copy that formula in remain that coloums cells.
Formula:
=colorindex(A1)
This colorindex command gives different index numbers to different colors, so by using those cnumbers we can sort out our data.
All the best... Read more...

post your comment below......

Right alt key is not working on combination alt + key

Monday, July 4, 2011 Posted by Satya

This is the common problem, we faced in keyboard shortcuts. I mean when we are using shortcuts with alt combination, it works with left alt key but there is no response from right alt key combination. We are all manage with alternative but Sometimes it ( right alt key) may get more importance or it must. At that times we have to activate that key...for that.
1) go to control panel

2) open regional languages settings

3) in that click on languages tab

4) click details (under text services and input languages)

Here the language could be anything but the keyboard option has to be US.

Then you can use right alt key properly... Read more...

post your comment below......

How to disable dont send error on internet explorer and other programmes

Sunday, July 3, 2011 Posted by Satya

Hi friends....i know this is the small and wellknown change on windows through given settings.... But i came to know recently thats why i am posting here now... Coming to this error... We oftenly face it when we are working, the programme gets any error, then it gives error report like don't send or send. Its not big problem..but when we are working on internet explorer safe sites, those are closed when you get that error. So, To remove that option ( error reporting option)
1. Go to my computer properties.
2. There you find advanced tab, in that you have to choose error reporting option.
3. In that you find two option which are one is notify error reporting or not
4. Then you have to select which is the better one for you, i mean the option is showing error or not.. Read more...

post your comment below......