When you enter this shortcut, a new worksheet is inserted into the current workbook. To add additional worksheets, press and hold the Shift key, press F11, and release both keys. To set the cell to automatically wrap, select the cell and press this keyboard shortcut: This opens the Format Cells dialog box. Go to the Alignment tab, and select the Wrap text check box. The text automatically wraps inside the cell. Another approach is to manually insert a line break in the cell text by selecting the cell you want to edit and pressing the F2 key. This changes the cell to Edit mode. Next, select the place in the text where you want the line break and press Alt+Enter. This moves the rest of the text down to the next line and fits the entire text inside the cell. This shortcut works whether you’ve clicked once on the cell, or double-clicked on the cell to enter Edit mode. The shortcut inserts the current date into the cell. This shortcut sums all of the adjacent cells above the selected cell in the worksheet. To use this keyboard shortcut in a worksheet: If the SUM function is entered into a location other than adjacent to a row or column filled with numbers, the range of cells selected as the function’s argument may be incorrect. To change the selected range, highlight the correct range before pressing the Enter key to complete the function. The time shortcut works whether the cell is selected or in Edit mode. The shortcut inserts the current time into the cell. To use this shortcut in a worksheet, follow these steps: To check formulas in a worksheet for errors, highlight the entire worksheet and use this shortcut to display all of the formulas. Select a formula and Excel adds a color outline around the cell references used in the formula. This traces the data used in a formula. To undo your actions: When these cells are not located in a contiguous block, it’s possible to select non-adjacent cells. This can be done using the keyboard and mouse together or using only the keyboard. Use the Keyboard in Extended ModeTo select non-adjacent cells with just the keyboard, use the keyboard in Extended Selection mode. To activate Extended Selection mode, press the F8 key on the keyboard. To turn off Extended Selection mode, press the Shift and F8 keys together. Select Adjacent and Non-Adjacent Cells in Excel with the KeyboardFollow the steps below if the range you wish to select contains a mixture of adjacent and individual cells as shown in the image above. To jump from one area of a worksheet to another, follow these steps: Apply the Fill Down command in an Excel spreadsheet using this keyboard shortcut: Here’s how to use the Fill Down keyboard shortcut: To remove italics formatting from any cell, use this keyboard shortcut: This formatting can be applied to a single cell, or to multiple selected cells at once. To apply the General number format, select the cell and press: To apply the Number format that adds two decimal places and the thousands separator to a number, select the cell and press: To apply the Currency format to data, select the cell and press: The Currency format adds the Dollar Sign in front of the numbers, uses the thousands separator, and add two decimal places after the number. When you select a cell and apply this shortcut, it multiplies the value in the cell by 100 and adds a Percent Symbol (%) after the number. Before you apply the Percentage format, make sure the data in the cell is in Number format with two decimal places. The Percentage format shifts the decimal place two digits to the right and turns the value into a whole number percentage. This selects the entire sheet, and common formatting can be applied to every cell at one time. This ensures that data is formatted uniformly across an entire sheet, either before or after you enter data. Before using this shortcut key, select a cell in the row you want to highlight (it doesn’t have to be the leftmost cell). After you use the shortcut, the row that contains the active cell is highlighted. Use this shortcut when you want to apply common formatting to one row in a worksheet, such as the header row. If this is the first time the worksheet is being saved, the Save As dialog box opens. 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.
After the file is saved using the Save As dialog box, it takes a few seconds to save your file as you work by using this shortcut. If the worksheet has been saved previously, the mouse pointer changes to an hourglass icon and then back to the normal white plus sign. To convert numbers to a date, use this shortcut: To use this shortcut, select a cell that has a date in it and apply the shortcut. This keyboard shortcut ensures that date formatting in a worksheet is common across the entire sheet. To use the Time format, press: Use the Time format shortcut on a single cell or on multiple cells and keep all date formats the same across your entire worksheet. To shift to the next sheet on the right, press: To shift to the next sheet on the left, press: This shortcut does the same thing as double-clicking a cell to edit the contents. Apply a border to a single cell, or any group of cells, depending on which cells you select before applying the shortcut.
