What are the shortcut keys in EXCEL?

What are the shortcut keys for EXCEL

Excel keyboard shortcut list (1)

Resizing toolbars and task panes

1. Press Alt to select the menu bar.

2. Press Ctrl Tab repeatedly to select the desired toolbar or task pane.

3. Please do one of the following:

Adjust the size of the toolbar

1. In the toolbar, press Ctrl + Spacebar to display the "Toolbar Options" menu.

2. Select the "Size" command and press Enter.

3. Use the arrow keys to resize the toolbar.

Mobile Toolbar

4. In the toolbar, press Ctrl + Spacebar to display the "Toolbar Options" menu.

5. Select the "Move" command and press Enter.

6. Use the arrow keys to adjust the position of the toolbar. Press the Ctrl arrow keys to move one pixel at a time. To undock the toolbar, press the Down arrow key repeatedly. To anchor the toolbar vertically to the left or right, press the Left or Right arrow keys when the toolbar is always on the left or right, respectively.

Adjust the size of the task pane

7. In the task pane, press Ctrl+Spacebar to display a menu of other commands.

8. Use the down arrow key to select the "Size" command, and then press Enter.

9. Use the arrow keys to resize the task pane. Use the Ctrl arrow keys to adjust one pixel at a time.

Mobile Task Pane

10. In the task pane, press Ctrl+Spacebar to display a menu of other commands.

11. Use the down arrow key to select the "Move" command, and then press Enter.

12. Use the arrow keys to adjust the position of the task pane. Use the Ctrl arrow keys to move one pixel at a time.

4. When you're done moving or resizing, press Esc.

Use dialog box

Tab

Move to the next option or option group.

Shift Tab

Move to the previous option or option group.

What are the shortcut keys for excel tables

Excel common shortcut keys

Tab moves the cursor right Shift Tab moves the cursor left Enter moves the cursor down Shift Enter moves the cursor up

Press the F4 shortcut key to switch the relative value to the absolute value, “= A1” → “=$A$1” → “=A$1” → “=$A1”

Alt F4 Close Excel

F2 Enter the current cell editing state

SHIFT F2 Insert cell comment

ALT =, equivalent to entering the SUM function

ALT Enter can force a line break in cell editing state

Alt E V Paste value (strongly recommended)

SHIFT F11 Insert new worksheet

SHIFT Arrow Key Expands the selected area by one cell width

ALT ↓ Select to enter the entered data (plain text) without setting data validity

Ctrl Home shortcut key to force back to the previous cell

Ctrl PgDn shortcut key to next worksheet

Ctrl PgUP shortcut key to go to the previous worksheet.

Ctrl 9 Hide row

Ctrl 0 hide column

Ctrl Shift 9 Unhide row

Ctrl Shift 0 Unhide column

Ctrl End to the end of the area

Ctrl ←↑→↓ to the last ←↑→↓ cell of the continuous range

Ctrl N Add new workbook

Ctrl O Open workbook

Ctrl S Save current workbook

Ctrl P Print current worksheet

Ctrl F Query

Ctrl G Positioning

Ctrl H Replace

Ctrl B boldface

Ctrl U Underline

Ctrl I italics

Ctrl Z Undo the previous step

Ctrl 'Copy the contents of the previous cell

Ctrl D Copy the contents of the previous cell

Ctrl A Select all current worksheet

Ctrl * Select all current working area

Ctrl; Insert current date

Ctrl: Insert current time

Ctrl F4 Close the current workbook

Ctrl W Close the current window (also applicable to IE window)

CTRL TAB EXCEL Switch between active windows

CTRL R Copy the cell on the left

CTRL ＂ ＂ (plus sign on numeric keypad) insert into cell/row/column

CTRL "-" (minus sign on numeric keyboard) Delete cell/row/column

CTRL `(above the TAB key) switches between formulas and values.

CTRL 1, cell formatting.

CTRL 2. Bold or not bold the font.

CTRL 3, set the font to italic.

CTRL D Fill Down

CTRL R Fill right

CTRL H Find and Replace

CTRL `(left of 1): formula review

CTRL (numeric keyboard): Insert row and column cells

CTRL -: Delete row and column cells

CTRL F11: Insert macro table

The above is the detailed content of What are the shortcut keys in EXCEL?. For more information, please follow other related articles on the PHP Chinese website!