Thursday, December 11, 2008

Excel short cut keys

Hi friends .. here is the list of Excel short cut keys .. make use of it and save your valuable time :)



Shortcut Keys

Description

F2

Edit the selected cell.

F5

Goto a specific cell. For example, C6.

F7

Spell check selected text and/or document.

F11

Create chart.

Ctrl + Shift + ;

Enter the current time.

Ctrl + ;

Enter the current date.

Alt + Shift + F1

Insert New Worksheet.

Shift + F3

Open the Excel formula window.

Shift + F5

Bring up search box.

Ctrl + A

Select all contents of the worksheet.

Ctrl + B

Bold highlighted selection.

Ctrl + I

Italic highlighted selection.

Ctrl + K

Insert link.

Ctrl + U

Underline highlighted selection.

Ctrl + 5

Strikethrough highlighted selection.

Ctrl + P

Bring up the print dialog box to begin printing.

Ctrl + Z

Undo last action.

Ctrl + F9

Minimize current window.

Ctrl + F10

Maximize currently selected window.

Ctrl + F6

Switch between open workbooks / windows.

Ctrl + Page up

Move between Excel work sheets in the same Excel document.

Ctrl + Page down

Move between Excel work sheets in the same Excel document.

Ctrl + Tab

Move between Two or more open Excel files.

Alt + =

Create a formula to sum all of the above cells

Ctrl + '

Insert the value of the above cell into cell currently selected.

Ctrl + Shift + !

Format number in comma format.

Ctrl + Shift + $

Format number in currency format.

Ctrl + Shift + #

Format number in date format.

Ctrl + Shift + %

Format number in percentage format.

Ctrl + Shift + ^

Format number in scientific format.

Ctrl + Shift + @

Format number in time format.

Ctrl + Arrow key

Move to next section of text.

Ctrl + Space

Select entire column.

Shift + Space

Select entire row.

Shortcut Keys

Description

F2

Edit the selected cell.

F5

Goto a specific cell. For example, C6.

F7

Spell check selected text and/or document.

F11

Create chart.

Ctrl + Shift + ;

Enter the current time.

Ctrl + ;

Enter the current date.

Alt + Shift + F1

Insert New Worksheet.

Shift + F3

Open the Excel formula window.

Shift + F5

Bring up search box.

Ctrl + A

Select all contents of the worksheet.

Ctrl + B

Bold highlighted selection.

Ctrl + I

Italic highlighted selection.

Ctrl + K

Insert link.

Ctrl + U

Underline highlighted selection.

Ctrl + 5

Strikethrough highlighted selection.

Ctrl + P

Bring up the print dialog box to begin printing.

Ctrl + Z

Undo last action.

Ctrl + F9

Minimize current window.

Ctrl + F10

Maximize currently selected window.

Ctrl + F6

Switch between open workbooks / windows.

Ctrl + Page up

Move between Excel work sheets in the same Excel document.

Ctrl + Page down

Move between Excel work sheets in the same Excel document.

Ctrl + Tab

Move between Two or more open Excel files.

Alt + =

Create a formula to sum all of the above cells

Ctrl + '

Insert the value of the above cell into cell currently selected.

Ctrl + Shift + !

Format number in comma format.

Ctrl + Shift + $

Format number in currency format.

Ctrl + Shift + #

Format number in date format.

Ctrl + Shift + %

Format number in percentage format.

Ctrl + Shift + ^

Format number in scientific format.

Ctrl + Shift + @

Format number in time format.

Ctrl + Arrow key

Move to next section of text.

Ctrl + Space

Select entire column.

Shift + Space

Select entire row.


cheers ...

shrikky :)

Basic PC shortcut keys -

Hi , friends ...

The below basic shortcut keys are a listing of shortcut keys that will work with almost all IBM compatible computers and software programs. It is highly recommended that all users keep a good reference of the below short cut keys and/or try to memorize the below keys. Doing so will dramatically increase your productivity.

Basic PC shortcut keys

Shortcut Keys

Description

Alt + F

File menu options in current program.

Alt + E

Edit options in current program

F1

Universal Help in almost every Windows program.

Ctrl + A

Select all text.

Ctrl + X

Cut selected item.

Shift + Del

Cut selected item.

Ctrl + C

Copy selected item.

Ctrl + Ins

Copy selected item

Ctrl + V

Paste

Shift + Ins

Paste

Home

Goes to beginning of current line.

Ctrl + Home

Goes to beginning of document.

End

Goes to end of current line.

Ctrl + End

Goes to end of document.

Shift + Home

Highlights from current position to beginning of line.

Shift + End

Highlights from current position to end of line.

Ctrl + Left arrow

Moves one word to the left at a time.

Ctrl + Right arrow

Moves one word to the right at a time



cheers ...
shrikky :)

Monday, December 8, 2008

Mumbai Attack -The Time To Think



I don't want to light a candle to bury my remembrance for those who have died .My heart full of anger,resentment,pain and revenge . i see no victory .i see no reason to celebrate.i see no reason to hoist my flag outside taj hotel.
10 terrorists had the power to make the entire nation go crazy for sixty hours ... we must fight back . If the government cant save us ,let the army rule this country . The subtle speeches of Manmohan singh and Prathiba patil fail to extinguish my anger .

For the first time in my life i didn't feel proud to be Indian .



A country which is unsafe ,volatile and corrupt. we want reaction . India need leaders ...
its time to awake ...

As kallam said the future of India is only in the hands of younger generation .. they should fight against the terrorism and should destroy its root .

Terrorism has no religion ... none of the religion should support that ....
without the involvement of some politicians and some bastards who are supporting terrorism inside and outside India under the name of particular religion.. this Mumbai incident is not possible .. so we should take right and necessary action on all those who are all involved in this blast without giving importance to religious factors ......

jai hind ...


Lets all join hands and make Blast as a thing of Past.

further Pakistan needs a nice lesson to be taught .. if it continues atacks like this . Then for sure those people who live in Pakistan wont leave peacefully . For everything there is a deadline .. we the indians not a coward . we are peace lovers . Those idiots dont know anything other than terrorism ... basicaly they are of that sort ... This is our last warning to them . If they wont stop . Then there wil be no PAKISTAN in world map .


Jai HIND .... :)

INDIA ROCKS ..... and Pakistan Sucks .............

cheers ...
shrikky ... :)