MS-EXCEL SHORTCUT KEYS
By admin at 16 August, 2008, 11:11 am
F2 Edit the selected cell
F5 Go to a specific cell
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 worksheet
Ctrl + B Bold highlighted selection
Ctrl + I Italicize highlighted selection
Ctrl + C Copy selected text
Ctrl + V Paste
Ctrl + D Fill
Ctrl + K Insert link
Ctrl + F Open find and replace options
Ctrl + G Open go-to options
Ctrl + H Open find and replace options
Ctrl + U Underline highlighted selection
Ctrl + Y Underline selected text
Ctrl + 5 Strikethrough highlighted selection
Ctrl + O Open options
Ctrl + N Open new document
Ctrl + P Open print dialog box
Ctrl + S Save
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 & Page Down Move between Excel® worksheets in the same document
Ctrl + Tab Move between two or more open Excel® files
Alt + = Create formula to sum all of above cells
Ctrl + ‘ Insert value of above cell into current cell
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 + g Move to next section of text
Ctrl + Space Select entire column
Shift + Space Select entire row
Ctrl + W Close document
how to change letters from lower case to upper case or vise versa
Ramesh,
Excel doesn’t have formatting capability to change case. But it has functions that can do the job.
Worksheet functions to change text case are:
LOWER – Converts all uppercase letters in a text string to lowercase.
UPPER – Converts all lowercase letters in a text string to uppercase.
PROPER – Capitalizes the first letter in a text string.
More details can be found at – http://support.microsoft.com/kb/263580
how to change upper key words into smaller key words.
Eg: ABCDEFGH
to
abcdefgh
how change text case in microsoft excel
LOWER – Converts all uppercase letters in a text string to lowercase.
UPPER – Converts all lowercase letters in a text string to uppercase.
PROPER – Capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter. Converts all other letters to lowercase letters.
Usuage – upper(A1) converts lowercase text in A1 to uppercase.
short cut keys