Microsoft Office/Excel
Microsoft Excel is a spreadsheet application developed by Microsoft for Microsoft Windows and Mac OS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.[1]
Resources
File Formats
- Wikipedia: Xls (file format)
- Wikipedia: Xlt (file format)
- .Xlsx: Excel Workbook (latest file format)
- .xltx: Excel Template (latest file format)
Shortcuts
External link: Keyboard shortcuts for Excel
- Ctrl+A: Select entire worksheet
- Ctrl+B: Apply/Remove Bold
- Ctrl+C: Copy
- Ctrl+E: Flash Fill
- Ctrl+F: Find in the open workbook
- Ctrl+G: Open the 'Go To' dialogue box
- Ctrl+H: Open the 'Find and Replace' dialogue box
- Ctrl+I: Apply/Remove Italic
- Ctrl+K: Insert hyperlink
- Ctrl+L: Align Left
- Ctrl+N: Create New workbook
- Ctrl+O: Display Open/Recent list
- Ctrl+P: Print worksheet
- Ctrl+R: Align Right
- Ctrl+S: Save file
- Ctrl+U: Apple/Remove Underline formatting
- Ctrl+V: Paste
- Ctrl+W: Close
- Ctrl+X: Cut
- Ctrl+Y: Redo last action
- Ctrl+Z: Undo last action
- Ctrl+1: Display Format cells dialog box
- Ctrl+ F12: Display Open dialog box
- Ctrl + Spacebar: Highlight current column
- Alt + Spacebar: Highlight current row
- F1: Launch Help
- F2: Edit current cell
- F4: Repeat last action/Lock cell reference
- F7: Spell check
- F11: Insert Quick Chart
- F12: Save As