asmitapathare
2

Can anyone forward me the excel formulaes and excel help urgently Thanks
From India, Mumbai
shilpa.u
9

Hi Here am attaching the excel shortkeys. hpe it may be usefull Thanks
From India, Bangalore
Attached Files (Download Requires Membership)
File Type: doc shortcut_key_184.doc (145.0 KB, 161 views)

asuri09
Hi, Am sure the attachments would be of great use to you and others as well. Best Regards - srinivasan
From India, New Delhi
Attached Files (Download Requires Membership)
File Type: xls excel_shortcuts_728.xls (68.5 KB, 524 views)
File Type: xls excel_formula_207.xls (114.5 KB, 555 views)

Sapana
15

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

From India, Pune
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.