RSS feed

  • MS-EXCEL SHORTCUT KEYS


    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:

    • excel 2010 uppercase
    • shortcut to capitalize fields in excel 2007
    • shortcut key to change uppercase to lowercase in excel
    • shortcut key for uppercase letter in excel
    • shortcut from small letters to capital


  • -->>> Next Post:



 

16 responses to “MS-EXCEL SHORTCUT KEYS” RSS icon

  • 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.

  • 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:
    A1: ABCD
    A2: EFGH
    A3: IJKL
    A4: MNOP
    A5: QRST
    A6: UVWX
    A7: YZ

    To make these cells lowercase in Excel 2007/ 2010, follow these steps:

    Type the following formula in cell B1:
    =LOWER(A1)

    _____________________________________________________________

    And Now
    The text that was in column A is now in lowercase:
    A1: abcd
    A2: efgh
    A3: ijkl
    A4: mnop
    A5: qrst
    A6: uvwx
    A7: yz

    To make these cells UPPERCASE in Excel 2003 / 2010 and earlier versions of excel, follow these steps:

    =UPPER(A1)

    And incase if the case in A1 is in mixed Format the
    Formula in B1 =PROPER(A1)

    Hope this was usefull…

    Regards
    Affy

  • 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

    Sub Set_Case()
    If ActiveCell.Value = LCase(ActiveCell) Then
    ActiveCell.Value = UCase(ActiveCell)
    Exit Sub
    ElseIf ActiveCell.Value = UCase(ActiveCell) Then
    ActiveCell.Value = _
    Application.WorksheetFunction _
    .Proper(ActiveCell.Value)
    ElseIf ActiveCell.Value = Application.WorksheetFunction _
    .Proper(ActiveCell) Then
    ActiveCell.Value = LCase(ActiveCell)
    End If
    End Sub

    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.

    Click: Options

    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.

  • Name (Required)

    ^ good grief! ^

  • Administrator

    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.


Leave a reply