2
Hi, Am sure the attachments would be of great use to you and others as well. Best Regards - srinivasan
From India, New Delhi
From India, New Delhi
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
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.
Advanced Excel 2003.pdf
152120-very-use ful-hr-manageme nt-software-bui lt-excel-psa-hr -manager-mainta in-payrrol-exce l-soft.zip
Competancy--exc el---mts___smts _289.xls