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.
Download 200+ Excel Shortcuts
Alt Shift PgDn. Extend selection left one screen. Alt Shift PgUp. Extend selection to start of row. Shift Home. Extend selection to first cell in worksheet. Ctrl Shift Home. Extend selection to last cell in worksheet. Ctrl Shift End. Toggle extend selection mode. Fn F8. Display 'Go To' dialog box. Ctrl G. Select cells with comments. Ctrl Shift O. Select current region around active cell. Select current region.
Select current array. Select row differences. Select column differences. Ctrl Shift. Select direct precedents. Ctrl [. Select all precedents. Select direct dependents. Ctrl ]. Select all dependents. Select visible cells only. Alt ;. Edit the active cell.
Microsoft Excel - Keyboard shortcuts for Mac Excel
Insert or edit comment. Shift F2. Cancel entry. Select one character right. Select one character left. Move one word right. Move one word left. Select one word right. Select one word left. Select to beginning of cell. Select to end of cell. Shift End.
- cs download for mac free.
- wd quick view mac mountain lion.
- how does time machine work on my mac;
- desktop icons not showing up mac.
- mac publisher software free download.
- convert ms word to pdf mac.
- scroll lock mac excel 2011;
Delete to end of line. Ctrl Delete. Delete character to the left of cursor. Delete character to the right of cursor. Fn Delete. Start a new line in the same cell. Alt Enter. Enter and move down. Enter and move up. Enter and move right. Enter and move left. Complete entry and stay in same cell.
Enter same data in multiple cells. Insert current date. Ctrl ;. Insert current time. 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.
222 Excel shortcuts for Windows and Mac
Toggle absolute and relative references. Open the Insert Function Dialog Box. Shift F3. 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. 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. Delete text to the end of the line Note: Some smaller keyboards do not have this key. Move one character up, down, left, or right. Move to the beginning of the line. Insert a comment. Open and edit a cell comment. Fill down. Fill to the right. Define a name. Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contents. Complete a cell entry. Enter a formula as an array formula. Cancel an entry in the cell or formula bar.
Display the Formula Builder after you type a valid function name in a formula. Insert a hyperlink. Edit the active cell and position the insertion point at the end of the line. Open the Formula Builder. Calculate the active sheet. Display a contextual menu. Start a formula. Toggle the formula reference style between absolute, relative, and mixed. Insert the AutoSum formula. Enter the date. Enter the time. Copy the value from the cell above the active cell into the cell or the formula bar.
Alternate between displaying cell values and displaying cell formulas. Copy a formula from the cell above the active cell into the cell or the formula bar. Display the AutoComplete list. Create a table.
#2 – Ctrl+Enter to Fill All Selected Cells with the Same Data or Formula
Insert a line break in a cell. Insert special characters like symbols, including emoji. Increase font size. Decrease font size. Align center. Align left. Apply the general number format. Apply the currency format with two decimal places negative numbers appear in red with parentheses.
Apply the percentage format with no decimal places. Apply the exponential number format with two decimal places. Apply the date format with the day, month, and year. Apply the time format with the hour and minute, and indicate AM or PM. Apply the number format with two decimal places, thousands separator, and minus sign - for negative values.
Apply the outline border around the selected cells. Add an outline border to the right of the selection. Add an outline border to the left of the selection. Add an outline border to the top of the selection. Add an outline border to the bottom of the selection. Remove outline borders. Apply or remove bold formatting. Apply or remove italic formatting. Apply or remove underscoring. Apply or remove strikethrough formatting. Hide a column. Unhide a column. Hide a row. Unhide a row. Edit the active cell. Cancel an entry in the cell or the formula bar.
Paste text into the active cell. Give selected cells the current cell's entry. Extend the selection by one cell. Extend the selection to the last nonblank cell in the same column or row as the active cell. Extend the selection to the beginning of the row.
Extend the selection to the beginning of the sheet. Extend the selection to the last cell used on the sheet lower-right corner. Select the entire column. Select the entire row. Select the entire sheet. Select only visible cells. Select only the active cell when multiple cells are selected. Extend the selection down one screen. Extend the selection up one screen. Alternate between hiding objects, displaying objects, and displaying placeholders for objects.
Turn on the capability to extend a selection by using the arrow keys. Add another range of cells to the selection. Select the current array, which is the array that the active cell belongs to. Select cells in a row that don't match the value in the active cell in that row. You must select the row starting with the active cell.
Select only cells that are directly referred to by formulas in the selection. Select all cells that are directly or indirectly referred to by formulas in the selection. Select only cells with formulas that refer directly to the active cell. Select all cells with formulas that refer directly or indirectly to the active cell. Delete the selection. Undo the last action. Move from left to right within the selection, or move down one cell if only one column is selected.
Move from right to left within the selection, or move up one cell if only one column is selected. Move clockwise to the next corner of the selection. Group selected cells. Ungroup selected cells. After pressing Return, move selection , select the direction you want to move in. Insert a new chart sheet. Cycle through chart object selection.
Display the Filter list or PivotTable page field pop-up menu for the selected cell. Display or hide outline symbols. Hide selected rows.