Re: Excel Help - Urgent - Doc Download

asmitapathare
Can anyone forward me the excel formulaes and excel help urgently
Thanks
shilpa.u
Hi
Here am attaching the excel shortkeys. hpe it may be usefull
Thanks
1 Attachment(s) [Login To View]

asuri09
Hi,
Am sure the attachments would be of great use to you and others as well.
Best Regards - srinivasan
2 Attachment(s) [Login To View]

Sapana
Hi,



MS-Excel 97

Short Cut Key

Complete a cell entry

Enter

Cancel a cell entry

Esc

Repeat the last action

F4 or Ctrl + Y

Start a new line in the same cell

Alt + Enter

Delete the character to the left of the insertion point, or delete the selection

Backspace

Delete the character to the right of the insertion point, or delete the selection

Delete

Delete text to the end of the line

Ctrl + Delete

Move one character up, down, left or right

Arrow Keys

Move to the beginning of the line

Home

Complete a cell entry and move down in the selection

Enter

Complete a cell entry and move up in the selection

Shift +Enter

Complete a cell entry and move to the right in the selection

Tab

Complete a cell entry and move to the left in the selection

Shift + Tab

Start a formula

= (Equal Sign)

Edit the active cell

F2

Insert the AutoSum formula

Alt + = (Equal Sign)

Enter the date

Ctrl + ; (Semicolon)

Enter the time

Ctrl + Shift +:(Colon)

Insert a hyperlink

Ctrl + K

Copy the value from the cell above the active cell

Ctrl + Shift + " (Quotation Mark)

Alternate between displaying cell values and displaying cell formulas

Ctrl + ` (Single Left quotation Mark)

Copy a formula from the cell above the active cell

Ctrl + ' (Apostrophe)

Display the Cells command (Format menu)

Ctrl + 1

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 points

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 decimals, 1000 separator, and - for negative values

Ctrl + Shift + !

Apply or remove bold formatting

Ctrl + B

Apply or remove italic formatting

Ctrl + I

Apply or remove an underline

Ctrl + U

Copy the selection

Ctrl + C

Paste the selection

Ctrl + V

Cut the Selection

Ctrl + X

Clear the contents of the Selection

Delete

Insert blank cells

Ctrl + Shift + Plus Sign

Undo the last action

Ctrl + Z

Move to the beginning of the row

Home

Move to the beginning of the worksheet

Ctrl + Home

Move to the last used cell on the worksheet

Ctrl + End



I hope this helps too.



Sapana
If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute