Friday, December 29, 2006

Color Codes in MS Excel

If you want to apply some color in your Excel Sheet through the UDF, then use the following Color codes:




SL No. Color Color Code
1 White 2
2 Lavender 39
3 Pale Blue 37
4 Light Turquoise 34
5 Light Green 35
6 Light Yellow 36
7 Tan 40
8 Rose 38
9 Grey 25% 15
10 Plum 54
11 Sky Blue 33
12 Turquoise 8
13 Bright Green 4
14 Yellow 6
15 Gold 44
16 Pink 7
17 Grey 40% 48
18 Voilet 13
19 Light Blue 41
20 Aqua 42
21 Sea Green 50
22 Lime 43
23 Light Orange 45
24 Red 3
25 Grey 50% 16
26 Blue-Grey 47
27 Blue 5
28 Teal 14
29 Green 10
30 Dark Yellow 12
31 Orange 46
32 Dark Red 9
33 Grey 80% 56
34 Indigo 55
35 Dark Blue 11
36 Dark Teal 49
37 Dark Green 51
38 Olive Green 52
39 Brown 53
40 Black 1

Ctrl+Shift+Numericals Excel Keyboard Shortcuts

Short Cut Name
Ctrl+Shift+` Apply General format
Ctrl+Shift+1 Apply Number format
Ctrl+Shift+2 Apply Time format
Ctrl+Shift+3 Apply Date format
Ctrl+Shift+4 Apply Currency format
Ctrl+Shift+5 Apply percentage format
Ctrl+Shift+6 Apply Exponential number format
Ctrl+Shift+7 Apply an outline border to selection
Ctrl+Shift+8 Select Box
Ctrl+Shift+9 Display hidden rows in selection
Ctrl+Shift+0 Display hidden columns in selection
Ctrl+Shift+[ Go to All the Precedents
Ctrl+Shift+] Go to All the Dependents
Ctrl+Shift+\ In a selected column, select the cells that don't match the value in the active cell.
Ctrl+Shift+. Copies the cell to theleft (similar to Ctrl+D)
Ctrl+Shift+, Fill as Above
Ctrl+Shift+' Fill as Above and let it edit
Ctrl+Shift+/
Ctrl+Shift+`
Ctrl+Shift+- Remove outline border from selection
Ctrl+Shift+: Insert the current time
Ctrl+Shift+= Insert Cee/Row Funcion- Similar to Insert>Cell Menu

Ctrl+Shift+Alphabet Excel Keyboard Shortcuts

Short Cut Name
Ctrl+Shift+A
Ctrl+Shift+B
Ctrl+Shift+C
Ctrl+Shift+D
Ctrl+Shift+E
Ctrl+Shift+F Short Cut to Fonts
Ctrl+Shift+G
Ctrl+Shift+H
Ctrl+Shift+I
Ctrl+Shift+J
Ctrl+Shift+K
Ctrl+Shift+L
Ctrl+Shift+M
Ctrl+Shift+N
Ctrl+Shift+O Select all cells that contain a comment
Ctrl+Shift+P Shortcut to Font Size
Ctrl+Shift+Q
Ctrl+Shift+R
Ctrl+Shift+S
Ctrl+Shift+T
Ctrl+Shift+U
Ctrl+Shift+V
Ctrl+Shift+W
Ctrl+Shift+X
Ctrl+Shift+Y
Ctrl+Shift+Z

Ctrl+Numerical Excel Keyboard Shortcuts

Short Cut Name
Ctrl+1 Open the Format Cells dialog box
Ctrl+2 Bold
Ctrl+3 Italics
Ctrl+4 Underline
Ctrl+5 Strike through the selection
Ctrl+6 Display Place Holders for Objects
Ctrl+7 Show /Hide Standard Tool Bar
Ctrl+8 Show Outline Symbols
Ctrl+9 Hide selected rows
Ctrl+0 Hide selected columns
Ctrl+. Blank
Ctrl+, Blank
Ctrl+' Deletes the contents of the cell and prepares the same for Editing
Ctrl+/ Select the array containing the active cell.
Ctrl+` Show Formula
Ctrl+- Delete Cell/Row Similar to Edit>Delete
Ctrl+; Insert the current date
Ctrl+= Blank
Ctrl+[ Select cells that a selected formula directly references
Ctrl+] Select formulas that directly reference the active cell
Ctrl+\ In a selected row, select the cells that don't match the value in the active cell.

Ctrl+Alphabet Excel Keyboard Shortcuts

Short Cut Name
Ctrl+A Select All
Ctrl+B Bold Selection
Ctrl+C Copy the selected text or objects to the Clipboard
Ctrl+D Fill data down through selected cells
Ctrl+E Blank
Ctrl+F Open the Find tab of the Find And Replace dialog box
Ctrl+G Open GoTo
Ctrl+H Open the Replace tab of the Find And Replace dialog box
Ctrl+I Italicize the selection
Ctrl+J Blank
Ctrl+K Insert a hyperlink
Ctrl+L Create List
Ctrl+M Blank
Ctrl+N Create a new workbook
Ctrl+O Open a workbook
Ctrl+P Print a workbook
Ctrl+Q Blank
Ctrl+R Fill data through selected cells to the right
Ctrl+S Save a workbook
Ctrl+T Blank
Ctrl+U Underline the selection
Ctrl+V Paste the contents of the Clipboard
Ctrl+W Close a workbook
Ctrl+X Cut the selected text or objects to the Clipboard
Ctrl+Y Repeat last action
Ctrl+Z Undo last edit

Thursday, December 28, 2006

Newtons Laws applied to IT Industry

Source: Digit

I) Newton’s Law Of Motion: Every body continues its state of rest or uniform motion unless it is acted by external unbalanced force.

  • (In IT Industry) Every Software Engineer continues chatting or forwarding mails or sending posts on humor unless he is assigned work by his manager.

II) Newton’s Law: The rate of change of velocity of a body is directly proportional to the
applied force & takes place in the same direction in which force is applied

  • (In our IT Industry) The rate of changes made in the software are directly proportional to the payment received from client and takes place at the faster rate as deadline approaches.

III) Newton’s Law: For every action there is equal and opposite reaction.

  • (In our IT Industry) For every virus, there exist an equally powerful antivirus, & after release of that antivirus some more destructive virus comes into existence.

IV) Law of Conservation of Energy: Energy can neither be created nor be destroyed. It can be converted from one form to another.The total amount of energy in the universe always remains constant.

  • (In IT Industry) Bug can neither be inserted nor be removed from software. It can only be converted from one form to another.The total number of bugs in the software always remains constant.

Monday, December 25, 2006

A View from my class room


Early morning, the sun has not risen


there's a cat, a canteen a view


some leaves

Sunday, December 24, 2006

At the Restaurant - Noodle House


This is from Noodle House, near Satyam theater, Royapeth, Chennai. It is a Chinese Restaurant, the place looks long and the seats are compartmentalized. Food is good same goes for the crowd. Prices are also not very expensive. Service is however can be improved.

Friday, December 22, 2006

Who’s horny?

Source: E-mail forward

Two married men are out drinking one night, when one turns to the other and says, “You know, I don’t know what to do. Whenever I go home after we’ve been out drinking, I turn the headlights off before I get to the driveway. I shut off the engine and coast into the garage. I take my shoes off before I go into the house, I sneak up the stairs, get undressed in the bathroom, stick my foot in the toilet and pee down my leg to prevent splashing sounds. I ease into bed and my wife STILL wakes up, and yells at me for staying out so late.”

His friend looks at him and says “Well, you’re obviously taking the wrong approach. I screech into the driveway, slam the door, storm up the steps, pee hard into the toilet water, then use the full flush, throw my shoes in the closet, undress in the bedroom, then jump into bed, slap her on the arse and say!, ‘WHO’S HORNY????!!!’ and she acts like she’s sound asleep! Works Every Time!!!”

Understanding Women

Source: E-mail forward

A man, walking along a California beach, was deep in prayer. Suddenly, the sky clouded above his head and, in a booming voice, the Lord said “Because you have TRIED to be faithful to me in all ways, I will grant you one wish”.
The man said, “Build a bridge to Hawaii so I can drive over any time I want”.
The Lord said, “Your request is very materialistic. Think of the enormous challenges for that kind of undertaking. The supports required to reach the bottom of the Pacific! The concrete and steel it would take!

It will nearly exhaust several natural resources. I can do it, but it is hard for me to justify your desire for worldly things. Take a little more time and think of something that would honour and glorify me”.

The man thought about it for a long time. Finally he said, “Lord, I wish I could understand my wife. I want to know how she feels inside, what she’s thinking when she gives me the silent treatment, why she cries, what she means when she says ‘nothing’s wrong’ and how can I make a woman truly happy”.

The Lord said, “You want 4 lanes or 8 lanes on that bridge?”

Sunday, December 17, 2006

tech-related oneliners

Source: Digit Forum

  1. A TV can insult your intelligence, but nothing rubs it in like a computer.
  2. The nice thing about Windows - it does not just crash; it actually displays a dialogue box and lets you press OK first.
  3. Error : Press any key except.. no, No, NO NOT THAT ONE!
  4. Any system or program, however complicated, when looked at in exactly the right way will become even more complicated.
  5. To err is human, but to really screw things up requires a computer.
  6. Bad command or filename. Go stand in the corner.
  7. C code. C code run. Run, code, run! PLEASE!
  8. Programmer: An ingenious device that converts caffeine into code.
  9. When you get to the point where you really understand your computer, it’s probably obsolete.
  10. A computer program will always do what you tell it to, and seldom what you want it to.
  11. How do I set my laser printer on stun?
  12. — If you cut here, you’ll probably destroy your monitor —
  13. ASCII stupid question, get a stupid ANSI.
  14. Do files get embarrassed when they’re unzipped?
  15. My life needs a rewind/erase button.
  16. Ask not for whom the bell tolls. Let the machine get it.
  17. A life… cool.. where can I download one of those?
  18. A printer consists of three main parts: the case, the jammed paper tray and the blinking red light.
  19. After months of training, when you finally understand all of a programs commands, the new revised edition arrives with a new command structure.
  20. /earth: file system full.
  21. Any technology distinguishable from magic is insufficiently advanced.
  22. Artificial Intelligence: The art of making real computers act like the ones in movies.
  23. Computers are not intelligent. They only think they are.
  24. Lisp in action is like a finely choreographed ballet. Basic in action is like a waltz of drugged elephants. C in action is like a sword dance on a freshly waxed floor.
  25. Error 7.0b1 - The item could not be deleted because it was missing.
  26. There are two major products to come out of Berkley: LSD and UNIX. We don’t believe this to be a coincidence.
  27. There are two ways to construct a software design. Make it so simple that there are obviously no deficiencies; or make it so complicated that there are no obvious deficiencies.
  28. UNIX: when you can’t afford the very best.
  29. A fail-safe circuit will destroy all other circuits.
  30. The important things are always simple.
  31. The simple things are always hard.
  32. Earth is 98% full. Please delete anyone you can.
  33. Computers will never replace books. You can’t stand on a floppy disk to reach a high shelf.
  34. The world will end in five minutes. Please log out.
  35. WARNING: Keyboard Not Attached. Press F10 to Continue.
  36. COFFEE.EXE is missing. Insert cup and press any key.
  37. Bad Command or File Name. Good try, though.
  38. Enter any 11-digit prime number to continue.
  39. Error reading FAT record. Try the SKINNY one? (Y/N)
  40. General Failure’s Fault. Not Yours.
  41. Hit any user to continue.
  42. Scandisk is now checking your hard drive. You can start praying.
  43. Smash forehead on keyboard to continue.
  44. Cannot find REALITY.SYS…Universe halted.
  45. Whom computers would destroy, they must first drive mad.
  46. If you can’t beat your computer at chess, try kickboxing.
  47. Why can’t DOS ever say “Excellent command or filename”?
  48. A picture may be worth a thousand words but it uses up a thousand times more memory!
  49. Robots will be able to buy happiness, but in condensed chip form.

Friday, December 15, 2006

Interview With Siddhu

Source: E-mail forward

HB: Sherry, let us start from the beginning. Tell us about your early life.

NS: I was born in patiala on 29th October in 1969. My earliest memories are of my father telling me “Son, never be a Zerox”. So I always believe in being original. I speak English like a native, a native Indian villager. My father was a lawyer by profession, who used to gobble his rivals like sausages with his smart phrases. I used to watch him at court cross-examine witnesses and learnt the fine art of commentary from him. All I do, is translate those phrases and proverbs from Hindi to English

HB: You made your debut in 1983 against the Windies, but made it big-time only four years later.

NS: My big break came in 1987 world cup, when I bamboozled and mesmerized all opposition, scoring four half-centuries in five innings.

HB: Just when you were all set for bigger things, you got involved in a police case.

NS: Yes, it was the most unfortunate incident of my life. Punjab police booked me and my close friend for culpable homicide. I was accused of killing one Gurmit Singh. I am telling you I was innocent, as innocent as a freshly laid egg.

HB: But you did beat up that guy?

NS: But then I am a Sikh, a born fighter, someone who will fight with a rattlesnake and give him the first two bites. Believe me, that guy was asking for it. How can you kill anyone who is hell-bent on committing suicide?

HB: Do you regret that incident?

NS: Oh, yes Harsha I do, If only on that fateful day I had been able to check my emotions, which flew like the fare in Indian Taxi - but ifs and buts were pots and pans, there would be no tinkers After that my cricket career went in downward spiral. I became like kumbhakarna - six months in the team, then for another six months resting behind bars. My fortunes were swinging like a rubber ball in a tidal wave. Earlier I was traveling on a German autobahn, but now I was on an Indian road. For about five years I was in and out of the Indian cricket team, and my performance became as erratic as electricity supply in most Indian cities

HB: After Sunny’s retirement, you had several opening partners. Tell us about your experiences with them.

NS: Yes, there were several. There was Srikanth, completely unorthodox. The gap between his bat and pad used to be so much that I would have driven a Rolls Royce through it…and our fellow commentator Ravi, who was his exact opposite, very slow like Indian three-wheeler which will suck a lot of diesel but cannot go beyond 30.

HB: What would you regard as the high point of your career?

NS: When the Australians toured India with Shane Warne. Along with Sachin, I took Warne apart like a child tearing up the wrapping paper from his birthday present! I made incemeat of the mighty Aussies and ate them withTomato sauce. I was on rampage, just like an Indian elephant I trampled them like the elephant tramples the paddy fields.

HB: What is your opinion of current Indian team?

NS: Indian team’s performance is like current Hindi movies, too many flops and too few hits. It is too dependent on Sachin, Dravid, Srinath and Harbajan. Indian team without these four is like CHICKEN BIRYANI without Chicken, Rice, Muttor, Biryani-Masala. It’s an empty plate you can not eat it nor throw it away. Our cricketers are very volatile like the Bombay Stock Exchange (BSE). You never know how they perform on a given day. They are like bicycles in a cycle stand - one falls down and the complete row will be down!

HB: … and skipper Saurav?

NS: Saurav Ganguly is too open-minded. If you leave a soda bottle open the gas will vanish! You have to close it times. As a captain he sets a bad example for his team by his poor fielding. He moves so slowly on the field like Jack of Jack n Jill who goes to fetch pail of runs for the opposition.

HB: Sherry, you have made a dramatic comeback as a commentator. But don’t you feel embarrassed by the constant ridicule heaped on you for your flowery style of commentary?

NS: You can take the tiger out of the jungle, but u can’t take the jungle out of the tiger. Why should I be embarrassed about it? In fact, at present there are only two super stars in Indian cricket - the two S’s -Sachin & Sidhu. Let me tell you a secret. Star Sports-ESPN need me, as they can no longer rely on the performances of Indian cricket team. After Sachin gets out, they need someone to keep the viewers entertained. That is why they are now bringing that Bakra-guy Cyrus to commentate. I am telling you Harsha, your job is in danger, not mine. Soon the focus will be less on the game, more on us. It is going to become Sidhu-Cyrus show. The world is all about mind and matter, I don’t mind and you don’t matter.

We the People

Source: E-mail forward

For long, India’s colonial rulers divided the country’s population by the numbers. And as current-day politicians continue with that unholy task, we present a shortcut to make their work easier. Here’s distinguishing India’s different cultures by the numbers:

MALAYALEES
One Malayalee is a narial-pani shop.
Two Malayalees is a boat race.
Three Malayalees is a Gulf job racket.
Four Malayalees is an oilslick.

TAMILIANS
One Tamilian is a fugitive sandalwood smuggler.
Two Tamilians is a suicide-bomb squad.
Three Tamilians is a classical music school.
Four Tamilians is a Jayalalitha fan club.

ANDHRAITES
One Andhraite is a cycle-rickshaw driver.
Two Andhraites is a spice shop.
Three Andhraites is a Naxalite outfit.
Four Andhraites is the Telugu film industry.

BENGALIS
One Bengali is a rosagulla shop.
Two Bengalis is a black-and-white movie.
Three Bengalis is a Mohun Bagan support group.
Four Bengalis is a Marxist movement.

RAJASTHANIS
One Rajasthani is a cattle-seller.
Two Rajasthanis is a mason.
Three Rajasthanis is a puppet show.
Four Rajasthanis is a folk dance-drama.

GOANS
One Goan is Remo Fernandes.
Two Goans is a Feni distillery.
Three Goans is a football club.
Four Goans is an all-night-long beach party.

MANGALOREANS
One Mangalorean is a supari seller.
Two Mangaloreans can’t stand one another.
Three Mangaloreans is an Udupi restaurant.
Four Mangaloreans is a fanatical Konkani Sabha.

BOMBAYITES
One Bombayite is a hawker.
Two Bombayites is a film industry.
Three Bombayites is a slum.
Four Bombayites is the rush-hour train crowd.

MAHARASHTRIANS
One Maharashtrian is a bus conductor.
Two Maharashtrians is a kabaddi match.
Three Maharashtrians is a Ganpati procession.
Four Maharashtrians is a Shiv Sena Shakha.

GUJARATIS
One Gujarati is a share broker in a Mumbai train.
Two Gujaratis is the total chatter in a Mumbai train.
Three Gujaratis is a rummy game in a Mumbai train
Four Gujaratis is a dandiya-raas session all night long.

KUTCHIES
One Kutchi is a kirana shop.
Two Kutchis is a stationery shop.
Three Kutchis is a saree shop.
Four Kutchis is the entire Bombay retail trade.

SARDARJIS
One Sardarji is a truck-driver.
Two Sardarjis is a roadside dhaba.
Three Sardarjis is a terrorist outfit.
Four Sardarjis are always found in jokes.

SINDHIS
One Sindhi is a currency racket.
Two Sindhis is a papad factory.
Three Sindhis is a duplicate goods shop.
Four Sindhis is a lot of gas around (yeech!).

BIHARIS
One Bihari is Laloo Prasad Yadav.
Two Biharis is a booth-capturing squad.
Three Biharis is a caste killing.
Four Biharis is the total literate population of the state.

BHAIYYAS
One Bhaiyya is a milkman.
Two Bhaiyyas is a chanawala (or panipuri wala).
Three Bhaiyyas is a temple-destruction squad.
Four Bhaiyyas is a halwai shop.
(And 12 Bhaiyyas is one SMALL family).

KASHMIRIS
One Kashmiri is a boatman.
Two Kashmiris is a carpet factory.
Three Kashmiris is a tourist agency.
Four Kashmiris is a terrorist outfit.

KANNADIGAS
One Kannadiga is a coffee estate.
Two Kannadigas is a Udupi restaurant.
Three Kannadigas is a pepper powder factor.
Four Kannadigas is an anti-Cauvery squad.

PUNJABIS
One Punjabi is chhole-bathure 5 times a week.
Two Punjabis is one bottle of whisky in one night.
Three Punjabis is a public fist-fight.
Four Punjabis is 200 kg of excess weight.

PARSIS
One Parsi is a sentence punctuated with BC’s and MC’s.
Two Parsis is a doctor and a lawyer.
Three Parsis is a 75 year old man and his two unmarried sisters.
Four Parsis is half their remaining population.

PAKISTANIS
One Pakistani is one too many…………..

You are a true Hyderabadi if:

Source: E-mail forward


@>> Your address reads as 23-404-32/67A-43 (New MCH number 56-678/4A/B-22), while you actually live in the second house beside Zamzam cafe in lane behind Anand Theatre on SP Road.

@>> You end up buying only a salwar kameez, whether it is a theatre workshop, food mela, consumer expo, designer jewellery show, science show or an automobile convention.

@>> Your street has at least one roadside mobile hotel that serves Chinese delicacies such as Vegetable soft needles, Navrotten Kurma, Chicken Manchewurea or American Chompsee.

@>> Your answer is ’seedha chale jao’ when somebody asks you for directions, whether it is to Malakpet, Masab Tank, Malkajgiri or Moosapet.

@>> You come across tailors sporting the board: Immidiot delivery in two days onli.

@>> If you can speak Hindi, Urdu, English and Hyderabadi, except Telugu, fluently.

@>> Your answer is ‘not in my pockets’ when somebody asks you ‘Where is X Y Z ?’ and you also roll on the floor laughing at your joke.

@>> If you ask the waiter to get you some ‘Mango pickle’ even if you are sitting at a lavish continental banquet dinner with exotic Chinese, Mexican, Italian and Lebanese cuisines.

@>> You order for a tea just after having had a Caramel custard.

@>> If you have at least one Srinivas, Raju or Venkatesh within six square feet. In other words, you have at least one cousin, friend, colleague or acquaintance with these names.

@>> If you have at least one cousin, friend, colleague or acquaintance in the US in software.

@>> If everytime somebody gives you a piece of good news, the first thing you ask them is ‘Party kab hain?’

@>> You are reading this and secretly admitting that you are, after all, a true blue Hyderabadi.

Woman as countries

Source: E-mail forward

Between the ages of 15 - 18 a woman is like China or Iran. Developing at a sizzling rate with a lot of potential but as yet still not free or open.

Between the ages of 18 - 21 a woman is like Africa or Australia. She is half-discovered, half-wild and naturally beautiful with bush land around the fertile deltas.

Between the ages of 21 - 30 a woman is like America or Japan. Completely discovered, very well developed and open to trade especially with countries with cash or cars.

Between the ages of 30 - 35, she is like India or Spain. Very hot, relaxed and convinced of its own beauty.

Between the ages of 35 - 40 a woman is like France or Argentina. She may have been half destroyed during the war but can still be a warm and desirable place to visit.

Between the ages of 40 - 50 she is like Yugoslavia or Iraq. She lost the war and is haunted by past mistakes. Massive reconstruction is now necessary.

Between the ages of 50 - 60 she is like Russia or Canada. Very wide, quiet and the borders are practically un-patrolled but the frigid climate keeps people away.

Between the ages of 60 - 70 a woman is like England or Mongolia. With a glorious and all conquering past but alas no future.

After 70, they become like Afghanistan. Everyone knows where it is, but there’s no f***ing way you’re going to go there.

Men are from Mars and Women from Venus

Source: E-mail forward


Her Side of the Story :
==============
He was in an odd mood Saturday night. We planned to meet at a pub for a drink. I spent the afternoon shopping with the girls and I thought it might have been my fault because I was a bit later than I promised, but he didn’t say anything much about it. The conversation was very slow going so I thought we should go off somewhere more intimate so we could talk a bit more privately. We went to this restaurant and he was STILL acting a bit funny. I tried to cheer him up and started to wonder whether it was me or something else. I asked him, and he said no. But I wasn’t really sure. So anyway, in the car on the way back home, I said that I loved him deeply and he just put his arm around me. I didn’t know what the hell that meant because you know he didn’t say it back or anything, this is really worrying me. We finally got back home and I was wondering if he was going to leave me! So I tried to get him to talk but he just switched on the TV, and sat with a distant look in his eyes that seemed to say it’s all over between us. Reluctantly, I said I was going to go to bed. Then after about 10 minutes, he joined me and to my surprise, he responded to my advances . But, he still seemed really distracted, so afterwards I just wanted to confront him but I just cried myself to sleep. I just don’t know what to do anymore. I mean, I really think he’s seeing someone else and that my life is a disaster.

His Side of the Story:
==============
India lost to Pakistan

Monday, December 11, 2006

The Cat









This cat was there on the tree, happily taking a nap. As if it is least bothered about what is happening around her. When I went near her, she warned me....dare you come near and bother me. I respected its privacy and held back. She was however has to retreat when some people working there decided to play spoil sport.

Tuesday, December 05, 2006

At the Restaurant - Breach





These are the pictures from Breech, Mylapore Chennai. It is a fast food joint, selling Sandwiches, Burgers Hot dogs etc. Always bearing a deserted look, not many visit the place. Quality of food is not exceptional, prices are reasonable.

Sunday, November 26, 2006

Santhom Basilica





This is St Thomas Basilica. Built by Portuguese between the 14th and the 15 century AD. It is close to the seaport. A towering neo gothic spire dominates the 55 meters high San Thome Cathedral.

Monday, November 20, 2006

Chennai when it rains






When it rains in Chennai, all the roads are like inundated. This stretch of road is North Usman Road in T Nagar

Saturday, November 18, 2006

A Park





After the class was over, it was time for me to visit to the nearest park. This is the Vallurkottam Park in Chennai. Google for more.

Wednesday, November 15, 2006

First Picture of My SE K750i



This is the first picture I took with the camera phone that I have bought today. It is the Sony Ericsson K750i. It has a 2 mega-pixel camera, which seems to take good pictures. And did you notice, it's me.

Friday, November 10, 2006

Excel Macros

Over the years I have been developing Macros to be used by me in my day to day work. Here are the links to the files that I have prepared for the same.

Copy the PERSONAL.XLS to Documents and Settings>Your User Name>Application Data>Microsoft>Excel>XLSTART.

Please note that these folders have to be unhidden. You can do that from the folder options.
The PERSONAL. XLS will automatically open at when Excel is started.

the links are:

Macro file - PERSONAL.xls
Macro List

Tuesday, October 24, 2006

Copying Tables from the Internet:

It is observed that many times while copying tables with numbers from Internet or some Databases, the numbers are not useable, in the sense that if you add them no result is found. This happens due to the fact that the data copied also includes some hidden text potion preceding the numbers in each cell that is not visible. What to do? Simple copy hidden text from one cell and do a find the hidden text (Ctrl+H) and replace that text with blank data (Ctrl+V; Ctrl+A)

Excel Keyboard Shortcuts

Source: E-mail forward

Since it is the first posting to this site it is befitting that I start with the most common Shortcut Keys.

I have noticed that many people are more comfortable with using mouse, rather than using the keyboard to work in Excel. However I strongly feel that it significantly slows down the pace of work. Common difficulty in using the keyboard is that people can’t simply remember the shortcut keys. Here I would advise to take the same approach, when you first learnt to ride a bicycle. Practice.

Rather than trying to read and remember the shortcut keys so that you can apply, you try to learn the shortcut keys by applying them while you work. First step in doing that would be to access the most commonly used menu function using keyboard. The second step would be to use the other keyboard shortcuts that are inbuilt in the Excel.

Hope the following shortcut keys are useful to you.

Happy Excelling!


Keys for moving and scrolling in a worksheet or workbook
Arrow keys: Move one cell up, down, left, or right
CTRL+arrow: key Move to the edge of the current data region
HOME: Move to the beginning of the row
CTRL+HOME: Move to the beginning of the worksheet
CTRL+END: Move to the last cell on the worksheet, which is the cell at the intersection of the rightmost used column and the bottom-most used row (in the lower-right corner), or the cell opposite the home cell, which is typically A1
PAGE DOWN: Move down one screen
PAGE UP: Move up one screen
ALT+PAGE DOWN: Move one screen to the right
ALT+PAGE UP: Move one screen to the left
CTRL+PAGE DOWN: Move to the next sheet in the workbook
CTRL+PAGE UP: Move to the previous sheet in the workbook
CTRL+F6 or CTRL+TAB: Move to the next workbook or window
CTRL+SHIFT+F6 or CTRL+SHIFT+TAB: Move to the previous workbook or window
F6: Move to the next pane in a workbook that has been split
SHIFT+F6: Move to the previous pane in a workbook that has been split
CTRL+BACKSPACE: Scroll to display the active cell
F5: Display the Go To dialog box
SHIFT+F5: Display the Find dialog box
SHIFT+F4: Repeat the last Find action (same as Find Next)
TAB: Move between unlocked cells on a protected worksheet

Keys for moving in a worksheet with End mode on
END: Turn End mode on or off
END, arrow key: Move by one block of data within a row or column END, HOME: Move to the last cell on the worksheet, which is the cell at the intersection of the rightmost used column and the bottom-most used row (in the lower-right corner), or the cell opposite the home cell, which is typically A1
END, ENTER: Move to the last cell to the right in the current row that is not blank; unavailable if you have selected the Transition navigation keys check box on the Transition tab (Tools menu, Options command)

Keys for moving in a worksheet with SCROLL LOCK on
SCROLL LOCK: Turn SCROLL LOCK on or off
HOME: Move to the cell in the upper-left corner of the window
END: Move to the cell in the lower-right corner of the window
UP ARROW or DOWN ARROW: Scroll one row up or down
LEFT ARROW or RIGHT ARROW: Scroll one column left or right
Tip When you use scrolling keys (such as PAGE UP and PAGE DOWN) with SCROLL LOCK turned off, your selection moves the distance you scroll. If you want to preserve your selection while you scroll through the worksheet, turn on SCROLL LOCK first.

Keys for previewing and printing a document
CTRL+P or CTRL+SHIFT+F12: Display the Print dialog box Work in print preview
Arrow keys: Move around the page when zoomed in
PAGE UP or PAGE DOWN: Move by one page when zoomed out
CTRL+UP ARROW or CTRL+LEFT ARROW: Move to the first page when zoomed out
CTRL+DOWN ARROW or CTRL+RIGHT ARROW: Move to the last page when zoomed
out

Keys for working with worksheets, charts, and macros
SHIFT+F11 or ALT+SHIFT+F1: Insert a new worksheet
F11 or ALT+F1: Create a chart that uses the current range
ALT+F8: Display the Macro dialog box
ALT+F11: Display the Visual Basic Editor
CTRL+F11: Insert a Microsoft Excel 4.0 macro sheet
CTRL+PAGE DOWN: Move to the next sheet in the workbook
CTRL+PAGE UP: Move to the previous sheet in the workbook
SHIFT+CTRL+PAGE DOWN: Select the current and next sheet in the workbook
SHIFT+CTRL+PAGE UP: Select the current and previous sheet in the workbook

Keys for entering data on a worksheet
ENTER: Complete a cell entry and move down in the selection
ALT+ENTER: Start a new line in the same cell
CTRL+ENTER: Fill the selected cell range with the current entry
SHIFT+ENTER: Complete a cell entry and move up in the selection
TAB: Complete a cell entry and move to the right in the selection
SHIFT+TAB: Complete a cell entry and move to the left in the selection
ESC: Cancel a cell entry
BACKSPACE: Delete the character to the left of the insertion point, or delete the
selection
DELETE: Delete the character to the right of the insertion point, or delete the selection
CTRL+DELETE: Delete text to the end of the line
Arrow keys: Move one character up, down, left, or right
HOME: Move to the beginning of the line
F4 or CTRL+Y: Repeat the last action
SHIFT+F2: Edit a cell comment
CTRL+SHIFT+F3: Create names from row and column labels
CTRL+D: Fill down
CTRL+R: Fill to the right
CTRL+F3: Define a name

Keys for working in cells or the formula bar
BACKSPACE: Edit the active cell and then clear it, or delete the preceding character in
the active cell as you edit cell contents
ENTER: Complete a cell entry
CTRL+SHIFT+ENTER: Enter a formula as an array formula
ESC: Cancel an entry in the cell or formula bar
CTRL+A: Display the Formula Palette after you type a function name in a formula
CTRL+SHIFT+A: Insert the argument names and parentheses for a function after you type a function name in a formula
CTRL+K: Insert a hyperlink
ENTER (in a cell with a hyperlink): Activate a hyperlink
F2: Edit the active cell and position the insertion point at the end of the line
F3: Paste a defined name into a formula
SHIFT+F3: Paste a function into a formula
F9: Calculate all sheets in all open workbooks
CTRL+ALT+F9: Calculate all sheets in the active workbook
SHIFT+F9: Calculate the active worksheet
= (equal sign): Start a formula
ALT+= (equal sign): Insert the AutoSum formula
CTRL+; (semicolon): Enter the date
CTRL+SHIFT+: (colon): Enter the time
CTRL+SHIFT+" (quotation mark): Copy the value from the cell above the active cell into the cell or the formula bar
CTRL+` (single left quotation mark): Alternate between displaying cell values and displaying cell formulas
CTRL+' (apostrophe): Copy a formula from the cell above the active cell into the cell or the formula bar
ALT+DOWN ARROW: Display the AutoComplete list Keys for formatting data
ALT+' (apostrophe): Display the Style dialog box
CTRL+1: Display the Format Cells dialog box
CTRL+SHIFT+~: Apply the General number format
CTRL+SHIFT+$: Apply the Currency format with two decimal places (negative numbers appear in parentheses)
CTRL+SHIFT+%: Apply the Percentage format with no decimal places
CTRL+SHIFT+^: Apply the Exponential number format with two decimal places
CTRL+SHIFT+#: Apply the Date format with the day, month, and year
CTRL+SHIFT+@: Apply the Time format with the hour and minute, and indicate A.M. or P.M.
CTRL+SHIFT+!: Apply the Number format with two decimal places, thousands separator, and minus sign (–) for negative values
CTRL+SHIFT+&: Apply the outline border
CTRL+SHIFT+_: Remove outline borders
CTRL+B: Apply or remove bold formatting
CTRL+I: Apply or remove italic formatting
CTRL+U: Apply or remove an underline
CTRL+5: Apply or remove strikethrough formatting
CTRL+9: Hide rows
CTRL+SHIFT+( (opening parenthesis): Unhide rows
CTRL+0 (zero): Hide columns
CTRL+SHIFT+) (closing parenthesis): Unhide columns

Keys for editing data
F2: Edit the active cell and put the insertion point at the end of the line
ESC: Cancel an entry in the cell or formula bar
BACKSPACE: Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contents
F3: Paste a defined name into a formula
ENTER: Complete a cell entry
CTRL+SHIFT+ENTER: Enter a formula as an array formula
CTRL+A: Display the Formula Palette after you type a function name in a formula
CTRL+SHIFT+A: Insert the argument names and parentheses for a function, after you type a function name in a formula
F7: Display the Spelling dialog box

Keys for inserting, deleting, and copying a selection
CTRL+C: Copy the selection
CTRL+X: Cut the selection
CTRL+V: Paste the selection
DELETE: Clear the contents of the selection
CTRL+HYPHEN: Delete the selection
CTRL+Z: Undo the last action
CTRL+SHIFT+PLUS SIGN: Insert blank cells

Keys for moving within a selection
ENTER: Move from top to bottom within the selection (down), or move in the direction that is selected on the Edit tab (Tools menu, Options command)
SHIFT+ENTER: Move from bottom to top within the selection (up), or move opposite to the direction that is selected on the Edit tab (Tools menu, Options command)
TAB: Move from left to right within the selection, or move down one cell if only one column is selected
SHIFT+TAB: Move from right to left within the selection, or move up one cell if only one column is selected
CTRL+PERIOD: Move clockwise to the next corner of the selection
CTRL+ALT+RIGHT ARROW: Move to the right between nonadjacent selections
CTRL+ALT+LEFT ARROW: Move to the left between nonadjacent selections Keys for selecting cells, columns, or rows
CTRL+SHIFT+* (asterisk): Select the current region around the active cell (the current region is a data area enclosed by blank rows and blank columns)
SHIFT+arrow key: Extend the selection by one cell
CTRL+SHIFT+arrow key: Extend the selection to the last nonblank cell in the same column or row as the active cell
SHIFT+HOME: Extend the selection to the beginning of the row
CTRL+SHIFT+HOME: Extend the selection to the beginning of the worksheet
CTRL+SHIFT+END: Extend the selection to the last used cell on the worksheet (lowerright corner)
CTRL+SPACEBAR: Select the entire column
SHIFT+SPACEBAR: Select the entire row
CTRL+A: Select the entire worksheet
SHIFT+BACKSPACE: Select only the active cell when multiple cells are selected
SHIFT+PAGE DOWN: Extend the selection down one screen
SHIFT+PAGE UP: Extend the selection up one screen
CTRL+SHIFT+SPACEBAR: With an object selected, select all objects on a sheet CTRL+6: Alternate between hiding objects, displaying objects, and displaying placeholders for objects
CTRL+7: Show or hide the Standard toolbar
F8: Turn on extending a selection by using the arrow keys
SHIFT+F8: Add another range of cells to the selection; or use the arrow keys to move to the start of the range you want to add, and then press F8 and the arrow keys to select the next range
SCROLL LOCK, SHIFT+HOME: Extend the selection to the cell in the upper-left corner of the window
SCROLL LOCK, SHIFT+END: Extend the selection to the cell in the lower-right corner of the window
Tip When you use the scrolling keys (such as PAGE UP and PAGE DOWN) with SCROLL LOCK turned off, your selection moves the distance you scroll. If you want to keep the same selection as you scroll, turn on SCROLL LOCK first.

Keys for extending the selection with End mode on
END: Turn End mode on or off
END, SHIFT+arrow key: Extend the selection to the last nonblank cell in the same column or row as the active cell
END, SHIFT+HOME: Extend the selection to the last cell used on the worksheet (lowerright corner)
END, SHIFT+ENTER: Extend the selection to the last cell in the current row. This keystroke is unavailable if you selected the Transition navigation keys check box on the Transition tab (Tools menu, Options command).

Keys for selecting cells that have special characteristics
CTRL+SHIFT+* (asterisk): Select the current region around the active cell (the current region is a data area enclosed by blank rows and blank columns)
CTRL+/: Select the current array, which is the array that the active cell belongs to
CTRL+SHIFT+O (the letter O): Select all cells with comments
CTRL+\: Select cells in a row that don't match the value in the active cell in that row. You must select the row starting with the active cell.
CTRL+SHIFT+|: Select cells in a column that don't match the value in the active cell in that column. You must select the column starting with the active cell.
CTRL+[ (opening bracket): Select only cells that are directly referred to by formulas in the selection
CTRL+SHIFT+{ (opening brace): Select all cells that are directly or indirectly referred to by formulas in the selection
CTRL+] (closing bracket): Select only cells with formulas that refer directly to the
active cell
CTRL+SHIFT+} (closing brace): Select all cells with formulas that refer directly or indirectly to the active cell
ALT+; (semicolon): Select only visible cells in the current selection

Keys for selecting a chart sheet
CTRL+PAGE DOWN: Select the next sheet in the workbook, until the chart sheet you want is selected
CTRL+PAGE UP: Select the previous sheet in the workbook, until the chart sheet you want is selected

Keys for selecting an embedded chart
Note The Drawing toolbar must already be displayed.
1. Press F10 to make the menu bar active.
2. Press CTRL+TAB or CTRL+SHIFT+TAB to select the Drawing toolbar
3. Press the RIGHT ARROW key to select the Select Objects button on the
Drawing toolbar.
4. Press CTRL+ENTER to select the first object.
5. Press the TAB key to cycle forward (or SHIFT+TAB to cycle backward) through
the objects until sizing handles appear on the embedded chart you want to select.
6. Press CTRL+ENTER to make the chart active.

Keys for selecting chart items
DOWN ARROW: Select the previous group of items
UP ARROW: Select the next group of items
RIGHT ARROW: Select the next item within the group
LEFT ARROW: Select the previous item within the group

Keys for working with a data form
ALT+key, where key is the underlined letter in the field or command name: Select a field or a command button
DOWN ARROW: Move to the same field in the next record
UP ARROW: Move to the same field in the previous record
TAB: Move to the next field you can edit in the record
SHIFT+TAB: Move to the previous field you can edit in the record
ENTER: Move to the first field in the next record
SHIFT+ENTER: Move to the first field in the previous record
PAGE DOWN: Move to the same field 10 records forward
CTRL+PAGE DOWN: Move to a new record
PAGE UP: Move to the same field 10 records back
CTRL+PAGE UP: Move to the first record
HOME or END: Move to the beginning or end of a field
SHIFT+END: Extend a selection to the end of a field
SHIFT+HOME: Extend a selection to the beginning of a field
LEFT ARROW or RIGHT ARROW: Move one character left or right within a field
SHIFT+LEFT ARROW: Select the character to the left
SHIFT+RIGHT ARROW: Select the character to the right

Keys for using AutoFilter
Arrow keys to select the cell that contains the column label, and then press
ALT+DOWN ARROW: Display the AutoFilter list for the current column
DOWN ARROW: Select the next item in the AutoFilter list
UP ARROW: Select the previous item in the AutoFilter list
ALT+UP ARROW: Close the AutoFilter list for the current column
HOME: Select the first item (All) in the AutoFilter list
END: Select the last item in the AutoFilter list
ENTER: Filter the list by using the selected item in the AutoFilter list

Keys for outlining data
ALT+SHIFT+RIGHT ARROW: Group rows or columns
ALT+SHIFT+LEFT ARROW: Ungroup rows or columns
CTRL+8: Display or hide outline symbols
CTRL+9: Hide selected rows
CTRL+SHIFT+( (opening parenthesis): Unhide selected rows
CTRL+0 (zero): Hide selected columns
CTRL+SHIFT+) (closing parenthesis): Unhide selected columns

Keys for the PivotTable and PivotChart Wizard
UP ARROW or DOWN ARROW: Select the previous or next field button in the list
LEFT ARROW or RIGHT ARROW: Select the field button to the left or right in a multicolumn field button list
ALT+C: Move the selected field into the Column area
ALT+D: Move the selected field into the Data area
ALT+L: Display the PivotTable Field dialog box
ALT+P: Move the selected field into the Page area
ALT+R: Move the selected field into the Row area

Keys for page fields in a PivotTable or PivotChart report
CTRL+SHIFT+* (asterisk): Select the entire PivotTable report Arrow keys to select the cell that contains the field, and then ALT+DOWN
ARROW: Display the list for the current field in a PivotTable report Arrow keys to select the page field in a PivotChart report, and then ALT+DOWN
ARROW: Display the list for the current page field in a PivotChart report
UP ARROW: Select the previous item in the list
DOWN ARROW: Select the next item in the list
HOME: Select the first visible item in the list
END: Select the last visible item in the list
ENTER: Display the selected item
SPACEBAR: Select or clear a check box in the list

Keys for laying out a PivotTable or PivotChart report
1. Press F10 to make the menu bar active.
2. Press CTRL+TAB or CTRL+SHIFT+TAB to select the PivotTable toolbar.
3. Press the LEFT ARROW or RIGHT ARROW key to select the menu to the left or
right or, when a submenu is visible, to switch between the main menu and submenu.
4. Press ENTER (on a field button) and the DOWN ARROW and UP ARROW keys to
select the area you want to move the selected field to.
Note To scroll to the top or bottom of the field list, press ENTER on the More Fields
or button.

Keys for grouping and ungrouping PivotTable items
ALT+SHIFT+RIGHT ARROW: Group selected PivotTable items
ALT+SHIFT+LEFT ARROW: Ungroup selected PivotTable items

Keys to use with the OLAP Cube Wizard
Use these keys to complete Step 2 in the OLAP Cube Wizard.
To move a field from the Source fields list to the Dimensions box
1. Press the TAB key to select the Source fields list.
2. Press the UP ARROW or DOWN ARROW key to select the field you want to move.
Because you cannot change the order of a field after you move it, select first the field
you want to appear at the top of the Dimensions box.
3. Press the TAB key to select the > button, and then press ENTER.
4. To move other fields, repeat steps 1 through 3.

To move a field to a lower or higher level in the Dimensions box
1. Press the TAB key to select the Dimensions box.
2. Press the UP ARROW or DOWN ARROW key to select the field you want to move.
3. Press CTRL+X.
4. Press the UP ARROW or DOWN ARROW key to select where you want to move the
field.
5. Press CTRL+V.