MS-EXCEL SHORTCUT KEYS

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

Advertisement

Incoming search terms:

  • yhs-fullyhosted_003
  • excel uppercase shortcut
  • excel upper case shortcut
  • computer shut cut bottom
  • excel change to all caps shortcut

17 thoughts on “MS-EXCEL SHORTCUT KEYS

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

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

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

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

  4. One quick and dirty solution for small amount of data.

    paste the fields in word and use shift+F3 and paste back into excel

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

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

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

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>