Home Video Tutorials Free Macros Keyboard Shortcuts Forum Contact

• Home
• Video Tutorials
  • Arrays
  • Charts & Graphs
  • Financial Functions &
  • Models
  • Formatting
  • Formulas
  • Data Analysis Tools
  • Import / Export / Link
  • Lists & Forms
  • Macros
  • Printing
  • Security
  • Tips & Tricks
• Free Macros
• Excel 2007 Resources
• Keyboard Shortcuts
• Forum
• Contact/About

Create your first Formula

Create your first Chart or Graph

Password protect your Workbook

Hide Rows, Columns, and Tabs

Using Conditional Formatting

 General Shortcuts


Ctrl + O	Open existing file
Ctrl + N	Create new workbook
Ctrl + S	Save current workbook
Ctrl + F4	Close current workbook
Ctrl + Z	Undo last action
Ctrl + Y	Redo last action
Ctrl + C	Copy selection
Ctrl + X	Cut selection
Ctrl + V	Paste selction
Ctrl + P	Print (displays print menu and options)
Ctrl + S	Save file
F12	Save file as

 Entering Data


Enter	Complete cell data entry and move to cell below.
Ctrl + Shift + Enter	Enter/create array formula
Alt + Enter	Start new line in the same cell.
Ctrl + Enter	Fill selected cell range with current entry.
Shift + Enter	Complete cell data entry and move to cell directly above current cell.
Tab	Complete cell data entry and move to the cell to the right.
Shift + Tab	Complete cell data entry and move to the cell to the left.
Esc	Cancel a cell entry and go back to what was there before.
Arrow Keys	Move one cell left, right, up, or down.
Home	Move to the first column (A).
F4 / Ctrl + Y	Repeat last action.
Ctrl + Shift + F3	Create names for row and column labels.
Ctrl + D	Fill down.
Ctrl + R	Fill to the right.
Ctrl + F3	Define a name for a cell or range of cells.
Ctrl + K	Insert a hyperlink.
Enter (after insertion of hyperlink)	Activate a hyperlink.
Ctrl + ;	Enter the current date.
Ctrl + Shift + :	Enter the current time.
Alt + Down Arrow	Display a drop-down list of the values in the current column of a list.
Ctrl + Z	Undo the last action.
Alt + F8	Displays macro dialog box.
Alt + F11	Displays the visual basic editor.
Ctrl + F11	Inserts an Excel 4.0 macro sheet.

 Edit Data


F2	Edit highlighted cell - cursor is at the end of cell contents.
Alt + Enter	Start a new line in the same cell.
Backspace	When cell is highlighted, deletes cells contents.
Delete	Deletes cells contents if cell is highlighted.
Ctrl + Delete	Deletes text to the end of the line.
F7	Runs spell-check.
Shift + F2	Inserts and edits comments.
Enter	Completes cell entry and moves to cell below.
Ctrl + Z	Undo last action.
Esc	Cancel a cell entry, previous contents are restored.
Ctrl + Shift + Z	When the autocorrect smart tags is displayed, undo or redo the last automatic correction.
Ctrl + C + Ctrl + C	Displays the clipboard (where copied items are).
Ctrl + -	Removes/deletes selected cells from the sheet.
Ctrl + Shift + "+"	Inserts blank cells.

 Format Data


Alt + '	Display style dialog box.
Ctrl + 1	Display format cells dialog box.
Shift + Spacebar	Highlight row
Ctrl + Spacebar	Highlight column
Ctrl + Shift + ~	Apply the 'general number' format to selected cells.
Ctrl + Shift + $	Apply the 'currency number' format with two decimal places and negative numbers showing in parentheses to selected cells.
Ctrl + Shift + %	Apply the 'percentage' format with no decimal places to selected cells.
Ctrl + Shift + ^	Apply the 'exponential number' format with two decimal places to selected cells.
Ctrl + Shift + #	Apply the 'date' format with the day, month, and year to selected cells.
Ctrl + Shift + @	Apply the 'time' format with the hour, minute, and AM or PM to selected cells.
Ctrl + Shift +!	Apply the 'number' format with two decimal places, thousands seperator, and minus sign for negative numbers to selected cells.
Ctrl + B	Apply/remove bold format to selected cells.
Ctrl + I	Apply/remove italic format to selected cells.
Ctrl + U	Apply/remove underline to selected cells.
Ctrl + 5	Apply or remove 'strikethrough' to selected cells.
Ctrl + 8	Displays or hides the outline of symbols.
Ctrl + 9	Hide row.
Ctrl + Shift + 9	Unhide row.
Ctrl + Shift + (	Unhide any hidden rows within the selection.
Ctrl + 0	Hide the selected columns.
Ctrl + Shift + )	Unhide any columns within the selection.
Ctrl + Shift + &	Apply the 'border outline' to selcted cells.
Ctrl + Shift + _	Remove the 'border outline' from selected cells.
Alt + Shift + Right Arrow	Groups selected rows or columns.
Alt + Shift + Left Arrow	Ungroups selected rows or columns.

 Macros


Alt + F8	Displays macro dialog box.
Alt + F11	Displays the visual basic editor.
Ctrl + F11	Inserts an Excel 4.0 macro sheet.

Nov. 25 Group and Ungroup Cells in Excel (Easily Hide and Unhide Data)

Absolute and Relative Cell References & INDIRECT() Function

Sep. 20 Bond Pricing and Valuation

Calculate the Future Value of a Retirement or Savings Plan

Calculate the Net Present Value of Future Cash Flows

Build a Loan/Mortgage Payment Calculator

Calculate Interest and Principal Payments on a Loan

Sep. 10 FIND() LEN() Functions - Extract Text from Cells - Intermediate

FIND() LEN() Functions - Extract Text from Cells - (2 Parts) - ADVANCED

VLOOKUP() Between Separate Worksheets and Workbooks