| A | B |
|---|
| Quick Access Toolbar | Collection of buttons that provide one click access to commonly used commands such as Save, Undo or Redo. You can also customize this according to your preference |
| Title Bar | A bar that displays the name of the active workbook |
| Ribbon | The main set of commands and controls organized in Tabs and Groups. You can also customize the ribbon according to your preference |
| Column Headings | The letters that appear along the top of the worksheet to identify the different columns in the worksheet |
| Worksheet Window | A window that displays an Excel worksheet, basically this is where you work all of the tasks. |
| Vertical Scroll Bar | Scroll bar to use when you want to scroll vertically through the worksheet window. |
| Horizontal Scroll Bar | Scroll bar to use when you want to scroll horizontally through the worksheet window. |
| Zoom Controls | Used for magnifying and shrinking of the active worksheet. |
| Zoom Controls | Used for magnifying and shrinking of the active worksheet. |
| View Shortcuts | Buttons used to change how the worksheet content is displayed. Normal, Page Layout or Page Break Preview. |
| Sheet Tabs | Tabs the display the name of the worksheet in the workbook, by default its name sheet 1, sheet 2, etc. You can rename this to any name the best represent to your sheet. |
| Sheet Tab Scrolling Buttons | Buttons to scroll the sheet tabs in the workbook. These are in the form of a left and right arrow in the bottom left corner of the workbook |
| Row Headings | The number that appears on the left of the worksheet window to identify the different rows. |
| Select All Button | A button that selects all the cells in the active worksheet. This is usually found in the upper left corner of the worksheet above Row Heading 1 and Column Heading A. |
| Active Cell | The cell selected in the active worksheet which is indicated by a green outline around the selected cell |
| Name Box | A bod that displays the cell reference of the active cell. This is found to the left of the Formula Bar |
| Formula Bar | A bar that displays the value or formula entered in the active cell |
| Office Button/File Tab | It provides access to workbook level features and program settings. You will notice that in Excel 2007 there is a circle Office button while on the Excel 2010 it replace with File Tab. If you click the circle office button you will see this. |
| Macro | A set of instructions that Excel recognizes and executes to save time. |
| Formula | A built-in Excel function that performs a task such as the SUM function which adds the sum of a set of numbers and/or cells |
| Ctrl + A | Highlights all cells that have data that are adjacent to each other |
| Ctrl + B | Bolds the text of the entire cell. You can't bold part of the text unless you select the text and then use the shortcut. |
| Ctrl + C | Copy the contents of the selected cells to Clipboard. |
| Ctrl + X | Cut the contents of the selected cells to Clipboard. |
| Ctrl + V | Insert the contents of the Clipboard into the selected cell(s). |
| Ctrl + Z | Undo your last action. Panic button :) |
| Ctrl + P | Open the "Print" dialog. |
| Ctrl + Y | Redo your last action. |
| Ctrl + N | Create a new workbook. |
| Ctrl + O | Open an existing workbook. |
| Ctrl + S | Save the active workbook. |
| F12 | Save the active workbook under a new name, displays the Save as dialog box. |
| Ctrl + W | Close the active workbook. |
| Ctrl + Tab | Switch to the next open Excel workbook. |
| Ctrl + PgDown | Switch to the next worksheet. Press Ctrl + PgUp to switch to the previous sheet. |
| Ctrl + G | Open the "Go to" dialog. Pressing F5 displays the same dialog. |
| Ctrl + F | Display the "Find" dialog box. |
| Home | Return to the 1st cell of the current row in a worksheet. |
| Ctrl + Home | Move to the beginning of a worksheet (A1 cell). |
| Ctrl + End | Move to the last used cell of the current worksheet, i.e. the lowest row of the rightmost column. |
| F2 | Edit the current cell. |
| Alt + Enter | In cell editing mode, enter a new line (carriage return) into a cell. (Wrap text) |
| Ctrl + ; | Enter the current date. Press Ctrl + Shift + ; to enter the current time. |
| Ctrl + Enter | Fill the selected cells with the contents of the current cell. |
| Ctrl + D | Copy the contents and format of the first cell in the selected range into the cells below. If more than one column is selected, the contents of the topmost cell in each column will be copied downwards. |
| Ctrl + Shift + V | Open the "Paste Special" dialog when clipboard is not empty. |
| Ctrl + Home or Ctrl + Shift + End | Select the entire range of your actual used data on the current worksheet. |
| Ctrl + Space | Select the entire column. |
| Shift + Space | Select the entire row. |
