Keyboard shortcutkeys for IntelliJ

Excel

Activate a selected button	Enter
Add a non-adjacent cell	Shift F8
Add borders	Alt H
Apply an outline border to the selected cells	Ctrl Shift &
Apply or remove strikethrough formatting	Ctrl 5
Apply the Currency format with two decimal places	Ctrl Shift $
Apply the Date format with the day, month, and year	Ctrl Shift #
Apply the General number format	Ctrl Shift ~
Apply the Number format with two decimal places	Ctrl Shift !
Apply the Percentage format with no decimal places	Ctrl Shift %
Apply the Scientific number format with two decimal places	Ctrl Shift ^
Apply the Time format	Ctrl Shift @
Bold text or remove bold formatting	Ctrl B
Bold	Ctrl B
Calculate all worksheets in all open workbooks	Ctrl Alt F9
Calculate all worksheets in all open workbooks	F9
Calculate the active worksheet	Shift F9
Cancel an entry in the cell	Esc
Center align cell contents	Alt H
Check dependent formulas, and then calculate all cells in all open workbooks	Ctrl Alt Shift F9
Check spelling in the active worksheet or selected range	F7
Choose a fill color	Alt H
Close a dialog or cancel a process, such as a paste operation	Ctrl Esc
Close a workbook	Ctrl W
Close the task pane	Ctrl Spacebar
Complete a cell entry and select the cell above	Shift Enter
Complete an entry in the formula bar and select the cell below	Enter
Copy a formula from the cell above the active cell into the cell or the Formula Bar	Ctrl '
Copy selected data	Ctrl C
Copy the selected cells	Ctrl C
Copy the value from the cell above the active cell into the cell	Ctrl Shift "
Copy	Ctrl C
Create a chart of the data in the current range in a separate Chart sheet	F11
Create an embedded chart of the data in the current range	Alt F1
Create, run, edit	Alt F8
Cut	Ctrl X
Cycle through all combinations of absolute and relative references in a formula	F4
Cycle through floating shapes	Ctrl Alt 5
Define a name to use in references	Alt M
Delete column	Alt H
Delete the table	Ctrl D
Display or hide the outline symbols	Ctrl 8
Display the Create Table dialog	Ctrl L
Display the Function Arguments dialog	Ctrl A
Display the menu or message for an Error Checking button	Alt Shift F10
Display the Quick Analysis options for selected cells that contain data	Ctrl Q
Edit the active cell and put the insertion point at the end of its contents	F2
Enter the current date	Ctrl ;
Enter the current time	Ctrl Shift :
Exit the floating shape navigation	Esc
Expand or collapse the formula bar	Ctrl Shift U
Expand or collapse the ribbon	Ctrl F1
Extend the selection of cells by one cell	Shift Arrow Keys
Extend the selection of cells to the beginning of the worksheet	Ctrl Shift Home
Extend the selection of cells to the last nonblank cell	Ctrl Shift Arrow Keys
Extend the selection of cells to the last used cell on the worksheet	Ctrl Shift End
Fill the selected cell range with the current entry	Ctrl Enter
Format fonts in the Format Cells dialog	Ctrl Shift F
Go to Data tab	Alt A
Go to Formula tab	Alt M
Go to Insert tab	Alt N
Go to Page Layout tab	Alt P
Go to the Home tab	Alt H
Go to View tab	Alt W
Hide the selected columns	Ctrl 0
Hide the selected rows	Ctrl 9
Insert a function	Shift F3
Insert argument names and parentheses	Ctrl Shift A
Insert/edit a cell note	Shift F2
Insert/Open and reply to a threaded comment	Ctrl Shift F2
Invoke Flash Fill to automatically recognize patterns	Ctrl E
Italicize text or remove italic formatting	Ctrl I
Move down, up, left, or right, respectively	Arrow keys
Move one cell down in a worksheet	↓
Move one cell left in a worksheet	←
Move one cell right in a worksheet	→
	Ctrl Shift F7
Move one cell to the right in a worksheet	Tab Key
Move one cell up in a worksheet	↑
Move one screen down in a worksheet	Page down
Move one screen to the left in a worksheet	Alt Page Up
Move one screen to the right in a worksheet	Alt Page Down
Move one screen up in a worksheet	Page Up
Move the cursor to the end of the text when in the formula bar	Ctrl End
Move the focus to commands on the ribbon	Shift Tab
Move the selected cells	Ctrl X
Move the table	Ctrl M
Move to the beginning of a worksheet	Ctrl Home
Move to the cell in the upper-left corner of the window when Scroll Lock is turned on	Home Scroll Lock
Move to the edge of the current data region in a worksheet	Ctrl Arrow keys
Move to the first cell in the upper left corner of selected table	Ctrl Home
Move to the first cell of selected column	Ctrl ↑
Move to the first cell of selected row	Ctrl ←
Move to the first field in the next record of a data form	Enter
Move to the last cell in the lower right corner of selected table	Ctrl End
Move to the last cell of selected column	Ctrl ↓
Move to the last cell of selected row	Ctrl →
Move to the last cell on a worksheet	Ctrl End
Move to the next sheet in a workbook	Ctrl Page Down
Move to the next table	Ctrl Page Down
Move to the previous cell in a worksheet	Shift Tab
Move to the previous sheet in a workbook	Ctrl Page Up
Move to the previous table	Ctrl Page Up
Move to the submenu when a main menu is open or selected	←
Move to the Tell me or Search field on the Ribbon	Alt Q
Open a context menu	Shift F10
Open a workbook	Ctrl O
Open context menu	Shift F10
Open the AutoFilter Menu dialog	Alt ↓
Open the context menu for the selected cell, column, or row	Right Click
Open the context menu	Ctrl Shift F10
Open the Data tab	Alt A
Open the Delete dialog to delete selected cells	Ctrl -
Open the File page and use Backstage view	Alt F
Open the Format Cells dialog	Ctrl 1
Open the Formulas tab	Alt M
Open the Go To dialog	F5
Open the Home tab	Alt H
Open the Insert dialog to insert blank cells	Ctrl Shift +
Open the Insert hyperlink dialog	Ctrl K
Open the Insert tab	Alt N
Open the list for a selected command	↓
Open the list of validation choices	Alt ↓
Open the menu for a selected button	Alt &arr;
Open the Microsoft Visual Basic For Applications Editor	Alt F11
Open the Page Layout tab	Alt P
Open the Paste Special dialog	Ctrl Alt V
Open the Review tab	Alt R
Open the task pane options menu	Ctrl Spacebar
Open the View tab	Alt W
Open the Workbook Statistics dialog	Ctrl Shift G
Paste a name from the Paste Name dialog	F3
Paste all cell contents and formatting from copied cells	H
Paste all cell contents and formatting	A
Paste all cell contents without borders	X
Paste content at the insertion point, replacing any selection	Ctrl V
Paste only column widths from copied cells	W
Paste only comments and notes attached to the cell	C
Paste only formulas and number formats from copied cells	R
Paste only the copied formatting	T
Paste only the data validation settings from copied cells	N
Paste only the formulas as entered in the formula bar	F
Paste only the values	V
Paste only the values	U
Paste	Ctrl V
Recalculate all formulas in the Power Pivot window	F9
Redo the last action	Ctrl Y
Remove cell contents	Delete
Remove the outline border from the selected cells	Ctrl Shift _
Rename the table	Ctrl R
Repeat the last command or action, if possible	Ctrl Y
Save a workbook	Ctrl S
Save the file	Ctrl S
Scroll horizontally	Ctrl Shift ,
Select all cells from the current location to the first cell of the column	Shift Page Down
Select all cells from the current location to the first cell of the row	Shift Home
Select all cells from the current location to the last cell of the column	Shift Page Down
Select all cells from the current location to the last cell of the row	Shift End
Select all objects on a worksheet when an object is selected	Ctrl Shift Spacebar
Select all text in the formula bar from the cursor position to the end	Ctrl Shift End
Select an entire column in a worksheet	Ctrl Spacebar
Select an entire row in a worksheet	Shift Spacebar
Select the active tab on the ribbon	F10
Select the current and next sheet in a workbook	Ctrl Shift Pagedown
Select the current and previous sheet in a workbook	Ctrl Shift PageUp
Select the current column	Ctrl Spacebar
Select the current region around the active cell	Ctrl Shift *
Select the current region if the worksheet contains data	Ctrl Shift Spacebar
Select the current row	Shift Spacebar
Select the entire table	Ctrl A
Select the entire worksheet	Ctrl Shift Sapcebar
Select the first command on the menu when a menu or submenu is visible	Home
Start a new line in the same cell	Alt Enter
Switch between displaying cell values or formulas in the worksheet	Ctrl '
witch between hiding objects	Ctrl 6
Turn extend mode on and use the arrow keys to extend a selection	F8
Underline text or remove underline	Ctrl U
Undo the last action	Ctrl Z
Undo	Ctrl Z
Use the Fill Down command to copy the contents Ctrl+D	Ctrl D
When a menu or submenu is open, move to the next command	↓