Excel Shortcuts

Excel Shortcut Key Combinations to Common Tools and Features

Here is a quick list of Shortcut Keys to Using Many of Excel's Common Tools and Features.
Insert a New Worksheet in Excel
Insert a New Worksheet in Excel. © Ted French
This Excel tip shows you how to insert a new worksheet into a workbook using a keyboard shortcut. Insert a New Excel Worksheet Using a Keyboard Shortcut Press and hold down the SHIFT key on the keyboard. Press and release the F11 key on the keyboard. A new worksheet will be inserted into the current workbook. To add additional worksheets continue to press and release the F11 key while holding down the SHIFT key. More »
Wrap Text on Two Lines in Excel
Wrap Text on Two Lines in Excel. © Ted French

Wrap text in a cell If you want text to appear on multiple lines in a cell, you can format the cell so that the text wraps automatically, or you can enter a manual line break. What do you want to do? Wrap text automatically Enter a line break Wrap text automatically In a worksheet, select the cells that you want to format. On the Home tab, in the Alignment group, click Wrap Text Button image. Excel Ribbon Image Notes Data in the cell wraps to fit the column width. When you change the column width, data wrapping adjusts automatically. If all wrapped text is not visible, it may be because the row is set to a specific height or that the text is in a range of cells that has been merged. To make all wrapped text visibly, do the following to manually adjust the row height: Select the cell or range for which you want to adjust the row height. On the Home tab, in the Cells group, click Format. Excel Ribbon Image Under Cell Size , do one of the following: To automatically adjust the row height, click AutoFit Row Height. To specify a row height, click Row Height, and then type the row height that you want in the Row height box. Tip You can also drag the bottom border of the row to the height that shows all wrapped text. Top of Page Top of Page Enter a line break You can start a new line of text at any specific point in a cell. Double-click the cell in which you want to enter a line break. Keyboard shortcut You can also select the cell, and then press F2. In the cell, click the location where you want to break the line, and then press ALT+ENTER.

Excel's wrap text feature is a handy formatting feature that allows you to control the look of labels and headings in your spreadsheet.

 

Wrap text allows you to place text on multiple lines within a single cell rather than have the text spread over multiple cells in the worksheet.

The "technical" term for this feature is wrapping text and the key combination for wrapping text is:

 Alt  + Enter    

 

Example: Using Shortcut Keys to Wrap Text

 

Example using Excel's wrap text feature:

 

  1. In cell D1 type the text: Monthly Income and press the Enter key on the keyboard.
  2. Since the text is too long for the cell, it should spill over into the cell E1.
  3. In cell E1 type the text: Monthly Expenses and press the Enter key on the keyboard.
  4. By entering data into E1 the label in cell D1 should be cut off at the end of cell D1. As well, the text in E1 should spill over into the cell to the right.
  5. To correct the problems with these labels, highlight cells D1 and E1 in the worksheet.
  6. Click on the Home tab.
  7. Click on the Wrap Text button on the ribbon.
  8. The labels in cells D1 and E1 should now both be fully visible with the text broken into two lines with no spill over into adjacent cells.

Excel's wrap text feature is a handy formatting feature that allows you to control the look of labels and headings in your spreadsheet. Rather than widening worksheet columns to make long headings visible, wrap text allows you to place text on multiple lines within a single cell. Excel's Wrap Text Example For help with this example, see the image above. In cell G1 type the text: Monthly Income and press the ENTER key on the keyboard. Since Monthly Income is too long for its cell, it will spill over into the cell H1. In cell H1 type the text: Monthly Expenses and press the ENTER key on the keyboard. Once data is entered into cell H1 the first label Monthly Income should be cut off. To correct the problem, drag select cells G1 and H1 on the spreadsheet to highlight them. Click on the Home tab. Click on the Wrap Text button on the ribbon. The labels in cells G1 and H1 should now both be fully visible with the text broken into two lines with no spill over into adjacent cells.

This tutorial covers how to type on multiple lines within a single worksheet cell.

 

The "technical" term for this feature is wrapping text and the key combination for wrapping text is:

 Alt  + Enter    

 

Example: Using Shortcut Keys to Wrap Text

To use Excel's wrap text feature using just the keyboard:

  1. Click on the cell where you want the text to be located
  2. Type the first line of text
  3. Press and hold down the Alt key on the keyboard
  4. Press and release the Enter key on the keyboard without releasing the Alt key
  5. Release the Alt key
  6. The insertion point should move to the line below the text just entered
  7. Type the second line of text
  8. If you wish to enter more than two lines of text, continue to press Alt + Enter at the end of each line
  9. When all the text has been entered, press the Enter key on the keyboard or click with the mouse to move to another cell
More »
Add the Current Date
Add the Current Date. © Ted French

This tutorial covers how to quickly add the current date to a worksheet using just the keyboard.

The key combination for adding the date is:

 Ctrl  + ;   (semi-colon key)  

Example: Using Shortcut Keys to Add the Current Date

To add the current date to a worksheet using just the keyboard:

  1. Click on the cell where you want the date to go.
  2. Press and hold down the Ctrl key on the keyboard.
  3. Press and release the semi-colon key ( ; ) on the keyboard without releasing the Ctrl key.
  4. Release the Ctrl key.
  5. The current date should be added to the worksheet in the selected cell.

Note: This keyboard shortcut does not make use of the TODAY function so the date does not change every time the worksheet is opened or recalculated. More »

Sum Data in Excel Using Shortcut Keys
Sum Data in Excel Using Shortcut Keys. © Ted French

Sum Data in Excel Using Shortcut Keys

This tip covers how to quickly enter Excel's SUM function to add up data using shortcut keys on the keyboard.

 

The key combination to enter the SUM function is:

" Alt " + " = "

 

Example: Entering the SUM Function using Shortcut Keys

  1. Enter the following data into cells D1 to D3 of an Excel worksheet: 5, 6, 7
  2. If necessary, click on cell D4 to make it the active cell
  3. Press and hold down the Alt key on the keyboard
  4. Press and release the equal sign ( = ) on the keyboard without releasing the Alt key
  5. Release the Alt key
  6. The SUM function should be entered into cell D4 with the range D1:D3 highlighted as the function's argument
  7. Press the Enter key on the keyboard to complete the function
  8. The answer 18 should appear in cell D4
  9. When you click on cell D4 the complete function =SUM( D1 : D3 ) appears in the formula bar above the worksheet.

This shortcut can be used to sum data in rows as well as columns.

Note: The SUM is designed to be entered at the bottom of a column of data or at the right end of a row of data .

If the SUM function is entered into a location other than these two, the range of cells selected as the function's argument may be incorrect.

 

To change the selected range, use the mouse pointer to highlight the correct range before pressing the Enter key to complete the function More »

Adding the Current Time
Adding the Current Time. © Ted French

This tutorial covers how to quickly add the current time to a worksheet using just the keyboard:

The key combination for adding the time is:

 Ctrl  + Shift  +  :  (colon key)  

Example: Using Shortcut Keys to Add the Current Time

To add the current time to a worksheet using just the keyboard:

  1. Click on the cell where you want the time to go.

  2. Press and hold down the Ctrl and the Shift keys on the keyboard.

  3. Press and release the colon key ( : ) on the keyboard without releasing the Ctrl and Shift keys.

  4. The current time will be added to the spreadsheet.

Note: This keyboard shortcut does not make use of the NOW function so the date does not change every time the worksheet is opened or recalculated.

Other Shortcut Keys Tutorials

More »
Insert a Hyperlink
Insert a Hyperlink. © Ted French

Insert a Hyperlink in Excel Using Shortcut Keys

Related tutorial: Insert Hyperlinks and Bookmarks in Excel

This Excel tip covers how to quickly insert a hyperlink for selected text using shortcut keys in Excel.

The key combination that can be used to insert a hyperlink is:

Ctrl + k

Example: Insert a Hyperlink using Shortcut Keys

For help with these instructions click on the image above

  1. In an Excel worksheet click on cell A1 to make it the active cell
  2. Type a word to act as anchor text such as Spreadsheets and press the Enter key on the keyboard
  3. Click on cell A1 to again make it the active cell
  4. Press and hold down the Ctrl key on the keyboard
  5. Press and release the letter ( k ) key on the keyboard to open the Insert Hyperlink dialog box
  6. In the Address: line at the bottom of the dialog box type a full URL such as:
    http://spreadsheets.about.com
  7. Click Ok to complete the hyperlink and close the dialog box
  8. The anchor text in cell A1 should now be blue in color and underlined indicating it contains a hyperlink

Testing the Hyperlink

  1. Place the mouse pointer over the hyperlink in cell A1
  2. The arrow pointer should change to the hand symbol
  3. Click on the hyperlink anchor text
  4. Your web browser should open to the page identified by the URL

Remove the Hyperlink

  1. Place the mouse pointer over the hyperlink in cell A1
  2. The arrow pointer should change to the hand symbol
  3. Right click on the hyperlink anchor text to open the Context drop down menu
  4. Click on Remove Hyperlink option in the menu
  5. The blue color and the underline should be removed from the anchor text indicating that the hyperlink has been removed

Other Keyboard Shortcuts

  • Apply Currency Formatting
  • Applying Italics Formatting
  • Add Borders in Excel
  • More »
    Show Formulas
    Show Formulas. © Ted French
    The key combination that can be used to show formulas is: Ctrl + ` (grave accent key) On most standard keyboards, the grave accent key is located next to the number 1 key on the top left corner of the keyboard and looks like a backwards apostrophe. Show Formulas using Shortcut Keys Example Press and hold down the Ctrl key on the keyboard Press and release the grave accent key ( ` ) key on the keyboard without releasing the Ctrl key Release the Ctrl key About Show formulas Show formulas does not change the spreadsheet, only the way it is displayed. Makes it easy to find cells containing formulas It allows you to quickly read through all formulas to check for errors When you click on a formula, Excel outlines in color the cell references used in the formula. This helps you to trace the data being used in a formula. Print spreadsheets with show formulas turned on. Doing so, will allow you to search a spreadsheet for hard to find errors. More »

    This Excel shortcut key tutorial shows you how to "undo" changes made to an Excel worksheet.

    Related tutorial: Excel 's Undo Feature.

    Note: It's important to remember that when you use Undo, it "undoes" your actions in the exact reverse order that you applied them.

    The shortcut key combination used to "undo" changes is:

    • Ctrl + " Z "

    Example of How to Undo Changes using Shortcut Keys

    1. Type some data into a cell, such as A1 in the spreadsheet and press the Enter key on the keyboard.

    2. Click on that cell to make it the active cell.

    3. Click on Home tab of the ribbon.

    4. Apply the following formatting options to your data:
      • change the font color,
      • widen the column,
      • underline,
      • change the font type to Arial Black,
      • center align the data

    5. Press and hold down the Ctrl key on the keyboard.

    6. Press and release the letter " Z " on the keyboard.

    7. The data in the cell should change back to left alignment as the last change (center alignment) is undone.

    8. Press and hold down the Ctrl key on the keyboard again.

    9. Press and release the letter " Z " on the keyboard twice without releasing the Ctrl key.

    10. Not only will the underline be removed but the font will no longer be Arial Black.

    11. This happens because, as mentioned above, the undo feature "undoes" your actions in the exact reverse order that you applied them.

    Other Excel Shortcut Keys Tutorials

    More »
    Selecting Non-Adjacent Cells
    Selecting Non-Adjacent Cells. © Ted French

    Select Non-Adjacent Cells in Excel

    Related Tutorial: Select Non-Adjacent Cells Using the Keyboard and Mouse

    By selecting multiple cells in Excel you can delete data, apply formatting such as borders or shading, or apply other options to large areas of a worksheet all at one time.

    At times these cells are not located in a contiguous block. In these situations it is possible to select non-adjacent cells.

    This can be done using the keyboard and mouse together or solely using the keyboard.

    Using the Keyboard in Extended Mode

    To select non-adjacent cells with just the keyboard requires you to use the keyboard in Extended Mode.

    Extended mode is activated by pressing the F8 key on the keyboard. You shut off extended mode by pressing the Shift and F8 keys on the keyboard together.

    Select Single Non-Adjacent Cells in Excel Using the Keyboard

    1. Move the cell cursor to the first cell you want to select.
    2. Press and release the F8 key on the keyboard to start Extended Mode and to highlight the first cell.
    3. Without moving the cell cursor, press and release the Shift + F8 keys on the keyboard together to shut off extended mode.
    4. Use the arrow keys on the keyboard to move the cell cursor to the next cell you wish to highlight.
    5. The first cell should remain highlighted.
    6. With the cell cursor on the next cell to be highlighted, repeat steps 2 and 3 above.
    7. Continue to add cells to the highlighted range by using the F8 and Shift + F8 keys to start and stop extended mode.

    Selecting Adjacent and Non-Adjacent Cells in Excel Using the Keyboard

    Follow the steps below if the range you wish to select contains a mixture of adjacent and individual cells as shown in the image above.

    1. Move the cell cursor to the first cell in the group of cells you want to highlight.
    2. Press and release the F8 key on the keyboard to start Extended Mode.
    3. Use the arrow keys on the keyboard to extend the highlighted range to include all cells in the group.
    4. With all cells in the group selected, press and release the Shift + F8 keys on the keyboard together to shut off extended mode.
    5. Use the arrow keys on the keyboard to move the cell cursor away from the selected group of cells.
    6. The first group of cells should remain highlighted.
    7. If there are more grouped cells you wish to highlight, move to the first cell in the group and repeat steps 2 to 4 above.
    8. If there are individual cells that you wish to add to the highlighted range, use the first set of instructions above for highlighting single cells.
    More »
    Select Non-Adjacent Cells in Excel with Keyboard and Mouse
    Select Non-Adjacent Cells in Excel with Keyboard and Mouse. © Ted French

    Related Tutorial: Selecting Non-Adjacent Cells Using the Keyboard

    By selecting multiple cells in Excel you can delete data, apply formatting such as borders or shading, or apply other options to large areas of a worksheet all at one time.

    While using the drag select method with the mouse to quickly highlight a block of adjacent cells is probably the most common way of selecting more than one cell, there are times when the cells you want to highlight are not located beside each other.

    When this occurs, it is possible to select non-adjacent cells. Although selecting non-adjacent cells can be done solely with the keyboard, it is easier to do using the keyboard and mouse together.

    Selecting Non-Adjacent Cells in Excel

    For help with this example, see the image above.

    1. Click on the first cell you want to select with the mouse pointer to make it the active cell.

    2. Release the mouse button.

    3. Press and hold down the Ctrl key on the keyboard.

    4. Click on the rest of the cells you want to select them Without releasing the Ctrl key.

    5. Once all the desired cells are selected, release the Ctrl key.

    6. Do Not click anywhere else with the mouse pointer once you release the Ctrl key or you will clear the highlight from the selected cells.

    7. If you release the Ctrl key too soon and wish to highlight more cells, simply press and hold down the Ctrl key again and then click on the additional cell(s).

    Other Shortcut Keys Tutorials

    More »
    ALT - TAB Switching in Windows
    ALT - TAB Switching in Windows.

    Not just an Excel shortcut, ALT - TAB Switching is a quick way to move between all open documents in Windows (Win key + Tab in Windows vista).

    Using the keyboard to accomplish a task on a computer is usually much more efficient than using a mouse or other pointing device, and ALT - TAB Switching is one of the most used of these keyboard shortcuts.

    Using ALT - TAB Switching

    1. Open at least two files in Windows. These can be two Excel files or an Excel File and a Microsoft Word file for example.

    2. Press and hold down the Alt key on the keyboard.

    3. Press and release the Tab key on the keyboard without letting go of the Alt key.

    4. The ALT - TAB Fast Switching window should appear in the middle of your computer screen.

    5. This window should contain an icon for each document currently open on your computer.

    6. The first icon on the left will be for the current document - the one visible on the screen.

    7. The second icon from the left should be highlighted by a box.

    8. Below the icons should be the name of the document highlighted by the box.

    9. Release the Alt key and windows switches you to the highlighted document.

    10. To move to other documents shown in the ALT - TAB Fast Switching window, continue to hold down the Alt while tapping the Tab key. Each tap should move the highlight box left to right from one document to the next.

    11. Release the Alt key when the desired document is highlighted.

    12. Once the ALT - TAB Fast Switching window is open, you can reverse the direction of the highlight box - moving it from right to left - by holding down the Shift key as well as the Alt key and then tapping the Tab key.

    Other Keyboard Shortcuts

    More »
    Excel's Go To Feature
    Excel's Go To Feature.

    Related tutorial: Excel Name Box Navigation.

    The Go To feature in Excel can be used to quickly navigate to different cells in a spreadsheet. This article includes an example of how to use the Go To feature to move to different cells using a keyboard shortcut.

    Although not necessary for worksheets that use only a few columns and rows, for larger worksheets it can be useful to have easy ways of jumping from one area of your worksheet to another.

    To activate the Go To feature using the keyboard, press the F5 key

    Example using Excel's Go To feature for Navigation:

    1. Press the F5 key on the keyboard to bring up the Go To dialog box.
    2. Type in the cell reference of the desired destination in the Reference line of the dialog box. In this case: HQ567.
    3. Click on the OK button or press the ENTER key on the keyboard.
    4. The black box that surrounds the active cell should jump to cell HQ567 making it the new active cell.
    5. To move to another cell, repeat steps 1 to 3.

    Related Tutorials

    More »
    Excel Fill Down Command
    Excel Fill Down Command.

    If you need to input the same data - text or numbers - into a number of adjacent cells in a column, the Fill Down command can quickly do this for you by just using the keyboard.

    This Excel tip shows you how to apply the Fill Down command in an Excel spreadsheet using a keyboard shortcut.

    The key combination that applies the Fill Down command is:

    • Ctrl + D

    Example: Using Fill Down with a Keyboard Shortcut

    For help with this example, see the image above.

    1. Type a number, such as 395.54 into cell D1 in Excel.

    2. Press and hold down the Shift key on the keyboard
    3. Press and hold down the Down Arrow key on the keyboard to extend the cell highlight from cell D1 to D7.
    4. Release both keys.
    5. Press and hold down the Ctrl key on the keyboard.
    6. Press and release the " D " key on the keyboard.
    7. Cells D2 to D7 should now be filled with the same data as cell D1.

    Other Keyboard Shortcuts

    More »
    14
    of 27

    Applying Italics Formatting

    Applying Italics Formatting
    Applying Italics Formatting.

    This Excel tip shows you how to apply italics formatting using Shortcut keys on the keyboard.

    There are two key combinations that can be used to add or remove italics formatting to data:

    • Ctrl + " I " keys
    • Ctrl + " 3 " keys

    Example: Using Shortcut Keys to Apply Italics Formatting

    For help with this example, see the image to the right.

    1. Type some data into a cell, such as E1 in the spreadsheet and press the Enter key on the keyboard.

    2. Click on that cell to make it the active cell.

    3. Press and hold down the Ctrl key on the keyboard.

    4. Press and release the letter " I " on the keyboard.

    5. Italics formatting should be applied to the data in the cell.

    6. Press and release the Ctrl + " I " keys again to remove the italics formatting.

    Other Keyboard Shortcuts

    Apply Number Formatting
    Apply Number Formatting.

    This tutorial covers how to apply number formatting to selected cells using just the keyboard:

    The number formats applied to the selected data are:

    • two decimal places
    • the comma as thousands separator ( , )
    • the minus sign ( - ) for negative values

    The key combination that can be used to apply currency formatting to data is:

    Ctrl + Shift + ! (exclamation point)

    Example: Using Shortcut Keys to Apply Number Formatting

    This example is shown in the image above


    1. Add the following data to cells A1 to A4:
            4578.25102
            45782.5102
            457825.102
            4578251.02
      
    2. Highlight cells A1 to A4 to select them
    3. Press and hold down the Ctrl and Shift keys on the keyboard
    4. Press and release the exclamation point key ( ! ) on the keyboard without releasing the Ctrl and Shift keys
    5. Release the Ctrl and Shift keys
    6. The numbers in cells A1 to A4 should all be formatted to display only two decimal places even though several of the numbers have more than two
    7. The cells should also have the comma added as a thousands separator
    8. Clicking on any of the cells displays the original unformatted number in the formula bar above the worksheet

    Other Keyboard Shortcuts

    More »
    Apply Currency Formatting
    Apply Currency Formatting.

    This tutorial covers how to quickly apply currency formatting to selected cells using just the keyboard:

    The key combination that can be used to apply currency formatting to data is:

    • Ctrl + Shift + 4

    Example: Using Shortcut Keys to Apply Currency Formatting

    For help with this example, see the image to the right.

    1. Add the following data to cells A1 to B2: 7.98, 5.67, 2.45, -3.92

    2. Drag select cells A1 to B2 to highlight them.

    3. Press and hold down the Ctrl and Shift keys on the keyboard.

    4. Press and release the number four key ( 4 ) on the keyboard without releasing the Ctrl and Shift keys.

    5. In cells A1, A2, and B1 the dollar sign ( $ ) should be added to the data.

    6. In cell B2, because the data is a negative number, it should be red and surrounded by round brackets in addition to having the dollar sign ( $ ) added.

    Other Keyboard Shortcuts

    More »
    Apply Percent Formatting
    Apply Percent Formatting.

    This Excel tip covers applying Percent formatting to selected cells in an Excel spreadsheet using a shortcut keys on the keyboard.

    The key combination that can be used to apply currency formatting to data is:

    • Ctrl + Shift + 5

    Example of How to Apply Percent Formatting using Shortcut Keys

    For help with this example, see the image above.

    1. Add the following data to cells A1 to B2: .98, -.34, 1.23, .03

    2. Drag select cells A1 to B2 to highlight them.

    3. Press and hold down the Ctrl and Shift keys on the keyboard.

    4. Press and release the number five key ( 5 ) on the keyboard without releasing the Ctrl and Shift keys.

    5. In cells A1 to B2 the data should be converted to a percent with the percent sign ( % ) added to the data.

    Other Shortcut Keys Tutorials

    More »
    Select All Cells in an Excel Data Table
    Select All Cells in an Excel Data Table.

    This Excel tip covers how to select all cells in an Excel data table using a keyboard shortcut. Doing so allows you to apply changes such as formatting, column width, etc. to a worksheet all at once.

    Related article: Creating a Data Table in Excel .

    Note: For help with this example, see the image to the right.

    Example of How to Select All Cells in a Data Table

    1. Open an Excel worksheet containing a data table or create a data table .

    2. Click on any cell in the data table.

    3. Press and hold down the Ctrl key on the keyboard.

    4. Press and release the letter " A " key on the keyboard without releasing the Ctrl key.

    5. All cells in the data table should be highlighted.

    6. Press and release the letter " A " a second time.

    7. The heading row of the data table should be highlighted as well as the data table.

    8. Press and release the letter " A " a third time.

    9. All cells in the worksheet should be highlighted.

    Other Keyboard Shortcuts

    More »
    Select an Entire Row in Excel Using Shortcut Keys
    Select an Entire Row in Excel Using Shortcut Keys.

    Select Rows in a Worksheet

    This Excel tip covers how to quickly select or highlight an entire row in a worksheet using shortcut keys on the keyboard in Excel.

    The key combination that is used to select a row is:

    SHIFT + SPACEBAR

    Example: Using Shortcut Keys to Select an Entire Worksheet Row

    1. Open an Excel Worksheet - there doesn't need to be any data present
    2. Click on a cell in the worksheet - such as A9 - to make it the active cell
    3. Press and hold down the SHIFT key on the keyboard
    4. Press and release the SPACEBAR key on the keyboard without releasing the SHIFT key
    5. Release the SHIFT key
    6. All cells in the selected row should be highlighted - including the row header
    More »
    Save in Excel
    Save in Excel.

    Excel Save Shortcut Keys

    This Excel tip covers how to quickly save data using a shortcut keys on the keyboard in Excel.

     

    The key combination that can be used to save data is:

    Ctrl + S

     

    Example: Using Shortcut Keys to Save a Worksheet

    1. Press and hold down the Ctrl key on the keyboard
    2. Press and release the letter ( S ) key on the keyboard without releasing the Ctrl key
    3. Release the Ctrl key

    First Time Save

    If you have previously saved the worksheet the only indication that Excel is saving your file may be the mouse pointer changes briefly into an hourglass icon and then back to the normal white plus sign.

    The length of time the hourglass icon remains visible depends on the amount of data Excel must save. The greater the amount of data to save, the longer the hourglass icon will be visible.

    If you are saving a worksheet for the first time the Save As dialog box will open.

    When a file is saved for the first time two pieces of information must be specified in the Save As dialog box:

    • the name of the file (up to 255 characters including spaces)
    • the location (folder) where the file will be stored

    Save Frequently

    Since using the Ctrl + S shortcut keys is such an easy way to save data it is a good idea to save frequently - at least every five minutes - to avoid loss of data in the event of a computer crash. More »

    Formatting the Date
    Formatting the Date.

    This Excel tip shows you how to format the date (day, month, year format) in an Excel spreadsheet using a keyboard shortcut.

    Formatting the Date using a Keyboard Shortcut

    1. Add the desired date to a cell in an Excel spreadsheet.

    2. Click on the cell to make it the active cell.

    3. Press and hold down the Ctrl and Shift keys on the keyboard.

    4. Press and release the number sign key ( # ) on the keyboard without releasing the Ctrl and Shift keys.

    5. The date in the active cell will be formatted in the day, month, year format.

    Other Keyboard Shortcuts

    More »
    Formatting the Current Time
    Formatting the Current Time.

    This Excel tip shows you how to format the current time (hour, minute, and AM/PM format) in an Excel spreadsheet using a keyboard shortcut.

    Formatting the Current Time using a Keyboard Shortcut

    1. Use the NOW function to add the current date and time to cell D1.

    2. Click on cell D1 to make it the active cell.

    3. Press and hold down the Ctrl and Shift keys on the keyboard.

    4. Press and release the number two ( 2 ) on the keyboard without releasing the Ctrl and Shift keys.

    5. The NOW function in cell D1 will be formatted to show the current time in the hour, minute, and AM/PM format.

    Other Keyboard Shortcuts

    More »
    Switch Between Worksheets
    Switch Between Worksheets.

    As an alternative to using the mouse, it is easy to use a keyboard shortcut to switch between worksheets in Excel.

    The keys used are the CTRL key plus either the PGUP (page up) or the PGDN (page down) key



    Example - Switch Between Worksheets in Excel

    To move to the right:

    1. Press and hold down the CTRL key on the keyboard.
    2. Press and release the PGDN (page down) key on the keyboard.
    3. To move another sheet to the right press and release the PGDN key a second time.

    To move to the left:

    1. Press and hold down the CTRL key on the keyboard.
    2. Press and release the PGUP (page up) key on the keyboard.
    3. To move another sheet to the left press and release the PGUP key a second time.

    Other Keyboard Shortcuts

    Note: To select multiple worksheets using the keyboard, press: Ctrl + Shift + PgUp to select pages to the left Ctrl + Shift + PgDn to select pages to the right More »
    Edit Cells with the F2 Function Key
    Edit Cells with the F2 Function Key.

    Excel Edit Cells Shortcut Key

    The function key F2 allows you to quickly and easily edit the data of a cell by activating Excel's edit mode and placing the insertion point at the at the end of the active cell's existing contents.

    Example: Using F2 Key to Edit a Cell's Contents

    This example covers how to edit a formula in Excel

    1. Enter the following data into cells 1 to D3: 4, 5, 6
    2. Click on cell E1 to make it the active cell
    3. Enter the following formula into cell E1:
           = D1 + D2
    4. Press the Enter key on the keyboard to complete the formula - the answer 9 should appear in cell E1
    5. Click on cell E1 to again make it the active cell
    6. Press the F2 key on the keyboard
    7. Excel enters edit mode and the insertion point is placed at the end of the current formula
    8. Modify the formula by adding + D3 to the end of it
    9. Press the Enter key on the keyboard to complete the formula and leave edit mode - the new total for the formula - 15 - should appear in cell E1

    Note: If the option to allow editing directly in cells is turned off, pressing the F2 key will still put Excel in edit mode, but the insertion point will be moved to the formula bar above the worksheet in order to edit the cell's contents. More »

    Select All Cells in an Excel Worksheet
    Select All Cells in an Excel Worksheet.
    27
    of 27
    Add Borders
    Add Borders.

    This Excel tip covers how to add a border to selected cells in an Excel spreadsheet using a keyboard shortcut.

    Related tutorial: Adding/Formatting Borders in Excel.

    The key combination for adding the time is:

     Ctrl  +Shift  +  7   

    Example of How to Add Borders using a Keyboard Shortcut

    For help with this example, see the image to the right.

    1. Enter the numbers 1 to 9 into cells D2 to F4.

    2. Drag select cells D2 to F4 to highlight them.

    3. Press and hold down the Ctrl and the Shift keys on the keyboard.

    4. Press and release the number seven key ( 7 ) on the keyboard without releasing the Ctrl and Shift keys.

    5. Cells D2 to F4 should be surrounded by a black border.


    Other Keyboard Shortcuts

    More »