Let me tell you about the useful 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

These are some time-saving shortcuts for better productivity.

1. Sum

[Alt] and [=]
One of the most common Excel function is sum. To sum a column of numbers, select the cell at the bottom of the column and then press two keys at once – Alt and = . That will insert the sum function.

2. Show the formulas of the cells : [Ctrl] and [~]
The math formulas are hidden in excel cells and the results are shown. You can click on the cell to see the formula in the formula bar. But, there is a shortcut that shows all the formula (instead of the results in the cell) in one go – all your formulas will be revealed in their cells when you press Ctrl and tilde key. The tilde key is usually in the upper left corner of most of the keyboards and it looks like ” ~ ”

3. Select a Column or a Row: Ctrl-Spacebar or Shift-Spacebar
[Ctrl] and [A] selects everything on a page. But, if you don’t want everything but a column you can select one cell in the column and  press [Ctrl] and [Spacebar] keys.

To select a single row – press [Shift] and [Spacebar].

4. Takes you home – to the first cell – Ctrl-Home
Instead of scrolling to the top, Ctrl-Home is useful to go to the first cell (A1), from whereever you are in an Excel sheet.

Another useful key is Ctrl-End; that takes you to the last cell of the sheet.


5. Add the current Date: Ctrl-Semicolon
Ctrl-Semicolon inserts today’s date on the selected cell. Ctrl-Shift-Semicolon inserts the current time on the cell.

A video :


Incoming search terms:

  • how to change small letter to capital letter in excel shortcut key
  • shortcut key to make capital letters
  • shortcut key to convert uppercase to lowercase in excel from keyboard
  • yhs-fullyhosted_003
  • shortcut key for uppercase in excel

28 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 –

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


    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:


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

    Hope this was usefull…


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

  8. Nice Article.
    any idea, How to change the range of cells into upper case.

    Example:- how to change case for the cell range A2:M40

    • I don’t see that feature in Excel.
      What I would do is — copy the text to MS-Word and convert it to upper case (“Font” dialogue has that option in MS-Word).
      Then, copy and paste in Excel.

  9. I want to create capital all words in same column.
    ie.Greenwich Meridian Logistics I want to make GREENWICH MEDIAN LOGISTICS
    Please suggest if any shortcut.

  10. Thank you, I have just been searching for information approximately this subject for ages and yours is the best I have came upon till now. But, what concerning the conclusion? Are you certain in regards to the supply? aabegeekkegd

Leave a Reply

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