Excel video training

Excel Shortcuts Comments Navigate Worksheets Arrow Keys.

Excel Shortcuts List

Select a ll cells in data-containing area. Press twice to select everything. With Excel 'redo' undo an undo and 'repeat' repeat last action became a bit confus. Repeat last action. Insert Paste - Paste cell and push content downward or rightward. Works great for entire rows and columns. H ome select F ont F ace; type font name supported by auto-complete, or use Arrow Down to select.

Assign current font color to selection via H ome F ont C olor. While escaping the font-color drop-down, the focus stays on the icon; simply press Enter to assign the current color. Assign current fill color to selected cell color via H ome H iglight Cell. While escaping the highlight drop-down, the focus stays on the icon; simply press Enter to assign the current color. M erge A cross merge all columns, but not rows in selection.

Display the relationships between formulas and cells

There are only two direct shortcuts which apply or remove the complete outline. It seems the the easiest to enter the border menu, and then apply the shortcuts in the border menu. H ome - B order - M enu; technically it says 'more'.

Table of Contents:

Select all Formulas H ome - F in d - Form u las. Enter a formula as an array formula. Some keyboards seem to distinguish between left and right Shift key. This will automatically extend all column widths which reverses when presed again. AutoTrace will not show trace arrows for selections containing more than 20 cells. Show precedent trace arrows for the active cell automatically as you navigate among cells by enabling AutoTrace Precedents.

Show dependent trace arrows for the active cell automatically as you navigate among cells by enabling AutoTrace Dependents. This documentation refers to Macabacus version 8. Some features and descriptions of these features may not apply to older versions of Macabacus. Update your Macabacus software to take advantage of the latest features.

Pro Precedents Pro Precedents allows you to effortlessly navigate an audited formula's inputs. Drill down — You can also drill down on precedents using intuitive, tree-based navigation. If a tree node has precedents, it will be marked with a symbol. Press the right arrow key to expand the tree node and trace precedents one level deeper.

Use the left arrow key to move back up one level in the precedents tree. You can open the Pro Precedents dialog, navigate multiple levels of precedent cells, and close the dialog without ever using your mouse. Macabacus takes you directly to Point mode when possible, allowing you to immediately use the keyboard arrows to navigate and modify the precedent range corresponding to the selected node.

Ctrl Shift :. Fill down from cell above. Ctrl D. Fill right from cell left. Ctrl R. Copy formula from cell above. Ctrl '. Copy value from cell above. Ctrl Shift ". Add hyperlink. Ctrl K. Display AutoComplete list. Flash fill. Ctrl E. Format almost anything.

Ctrl 1. Display Format Cells with Font tab selected. Ctrl Shift F. Apply or remove bold formatting. Ctrl B.

Apply or remove italic formatting. Ctrl I. Apply or remove underscoring. Ctrl U. Apply or remove strikethrough formatting. Ctrl 5. Add or remove the shadow font style. Add or remove the outline font style. Align center. Align left. Align right. Alt H 6. Remove indent. Alt H 5. Increase font size one step. Alt H FG. Decrease font size one step. Alt H FK. Apply general format. Apply currency format. Apply percentage format. Apply scientific format. Apply date format. Apply time format. Apply number format. Ctrl Shift! Add border outline. Add or remove border right.

Alt R. Add or remove border left. Alt L. Add or remove border top. Alt T. Add or remove border bottom. Alt B. Add or remove border upward diagonal. Alt D. Add or remove border horizontal interior. Alt H. Add or remove border vertical interior. Alt V. Remove borders. Toggle absolute and relative references. Open the Insert Function Dialog Box. Shift F3.

+ Excel Shortcuts for PC and Mac that you must know - Wall Street Prep

Autosum selected cells. Toggle formulas on and off. Insert function arguments. Ctrl Shift A. Enter array formula. Ctrl Shift Enter. Calculate worksheets. Fn F9. Calculate active worksheet. Shift F9. Force calculate all worksheets. Ctrl Alt F9. Evaluate part of a formula. Expand or collapse the formula bar. Ctrl Shift U. Display function arguments dialog box. Define name. Ctrl F3. Define name using row and column labels. Ctrl Shift F3. Paste name into formula. Accept function with autocomplete.


  • appareil photo introuvable mac iphone?
  • Excel shortcuts for Windows and Mac | Exceljet!
  • Was this information helpful?.
  • creamy mac and cheese casserole;
  • Continue with the financial modelling course extract on Excel keyboard shortcuts!
  • Shortcuts for Microsoft Excel (Windows).

Display Insert Dialog box. Insert rows. Insert columns. Display Delete dialog box. Ctrl -. Delete rows. Delete columns. Delete cells. Delete contents of selected cells. Hide columns. Ctrl 0. Hide rows. Ctrl 9. Unhide rows. Ctrl Shift 9. Unhide columns. Ctrl Shift 0.

Group rows or columns. Ungroup rows or columns. Open Group Dialog Box. Open Ungroup Dialog Box. Hide or show outline symbols. Ctrl 8. Zoom in. Zoom out. Ctrl Alt -. Select entire pivot table. Toggle pivot table field checkbox. Group pivot table items. Ungroup pivot table items. Hide pivot table item. Create pivot chart on same worksheet. Create pivot chart on new worksheet. Open pivot table wizard.

Alt D P. Insert new worksheet. Shift F Go to next worksheet.