Posted on August 16th, 2008 16 comments
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
Incoming search terms:
- how to change case in excel 2007 shortcut
- Short key to captilise a documemt in excel
- shortcut key to all capiital the small letters from excel
-->>> Next Post: MS-WORD SHORTCUT KEYS
how to change letters from lower case to upper case or vise versa
how to change upper key words into smaller key words.
how change text case in microsoft excel
short cut keys
I want To convert my Text in Column to uppercase to lower case and wise versa.
I have to tried all the above formulas but it cant take effect but it can give an error.
please send the m.s. excel & m.s. word short cut keys in excel format
Guys you can refer to this example:
Type the following values in a worksheet:
To make these cells lowercase in Excel 2007/ 2010, follow these steps:
Type the following formula in cell B1:
The text that was in column A is now in lowercase:
To make these cells UPPERCASE in Excel 2003 / 2010 and earlier versions of excel, follow these steps:
And incase if the case in A1 is in mixed Format the
Formula in B1 =PROPER(A1)
Hope this was usefull…
One quick and dirty solution for small amount of data.
paste the fields in word and use shift+F3 and paste back into excel
The above UPPER() and LOWER() functions must be used in a different column than where the present values are. If you want to quickly convert a cell or a group of cells with single combo key strokes within the same cell as in word (shift+F3) the above is the solution.
This can be done in VBA as follows:
Open a NEW workbook
Copy this macro to the clipboard
If ActiveCell.Value = LCase(ActiveCell) Then
ActiveCell.Value = UCase(ActiveCell)
ElseIf ActiveCell.Value = UCase(ActiveCell) Then
ActiveCell.Value = _
ElseIf ActiveCell.Value = Application.WorksheetFunction _
ActiveCell.Value = LCase(ActiveCell)
Press ALT + F11
Insert > Module
Paste the macro into the Module area to the right.
Close back to Excel
Go to Tools > Macro > Macros
Highlight the macro ‘Set_Case’, if it is not already highlighted.
Select and enter a letter to be used as a keyboard shortcut. (Maybe… ‘c’ for case?)
Close back to Excel
File > Save As
Name the workbook Adjust Case
Reopen the Adjust Case workbook.
Open any other workbook you wish.
Click on any cell with text on any sheet in that workbook.
Press Ctrl + c (or whatever letter you chose).
Each time you enter this keyboard shortcut, the case will cycle through Proper, Upper, and Lower in a closed loop.
Note: You can make Excel automatically open Adjust Case.xls on startup by copying it the the XLStart folder. For Excel 2003, you would copy it to this location:
C:Program FilesMicrosoft OfficeOFFICE11XLStart
To make it truly seamless, you could copy a blank Book1 workbook into the XLStart folder also. Then, when you open Excel, the blank Book1 workbook would be the active workbook and Adjust Case would be open in the background. This would simulate a normal opening of Excel.
^ good grief! ^
go to new cell
don’t poop on it!
type =upper(# of cell u want) upper cased
type=lower(# OF CELL U WANT) lower cased
again-dont poop on it!
good luck! or another short cut f3
This is useful. Thank you.