Shift F4. Create embedded chart. Alt F1. Create chart in new worksheet. Fn F Insert table. Ctrl T. Toggle Autofilter.
Excel for Mac Training and Tutorials
Ctrl Shift L. Activate filter. Select table row. Shift Space. Select table column. Ctrl Space. Select table. Ctrl A. Clear slicer filter. Alt C. Toggle table total row. Ctrl Shift T.
Drag and cut. Drag and copy. Ctrl drag. Drag and insert. Shift drag. Drag and insert copy. Ctrl Shift drag. Drag to worksheet.
Alt drag. Drag to duplicate worksheet. Move one cell right. Move one cell left. Move one cell up.
Move one cell down. Move one screen right. Alt PgDn. Move one screen left. Alt PgUp. Move one screen up. Move one screen down. Move to right edge of data region.
1. Google Docs Spreadsheet
Move to left edge of data region. Move to top edge of data region. Move to bottom edge of data region. Move to beginning of row. Move to last cell in worksheet.
Free Online Excel Training: Perfect for Beginners - Learn Excel Today!
Ctrl End. Move to first cell in worksheet.
Ctrl Home. Turn End mode on. Go back to hyperlink. Ctrl G Enter. Select entire row. Select entire column. Select entire worksheet. Add adjacent cells to selection. Shift Click. Add non-adjacent cells to selection. Ctrl Click. Same selection in next column. Same selection in previous column. Move right between non-adjacent selections.
Microsoft Excel for Mac- Office 365 on Mac OS
Move left between non-adjacent selections. Toggle add to selection mode. Shift F8.
Cancel selection. Select active cell only. Shift Backspace. Show the active cell on worksheet. Ctrl Backspace. Move active cell clockwise in selection. Move active cell down in selection. Move active cell up in selection. Shift Enter. Move active cell right in a selection. Move active cell left in a selection. Shift Tab. Extend selection by one cell right. Extend selection by one cell left. Extend selection by one cell up.
Extend selection by one cell down. Extend the selection to the last cell right. Extend the selection to the last cell left. Extend the selection to the last cell up. Extend the selection to the last cell down. Extend selection up one screen. Shift PgUp. Extend selection down one screen. Shift PgDn.
Extend selection right one screen.