What is the shortcut key for undoing in excel?

#What is the shortcut key for withdrawing in excel?

The excel withdrawal shortcut key is ctrl z. Microsoft Excel is a spreadsheet software written by Microsoft for computers using Windows and Apple Macintosh operating systems. The intuitive interface, excellent calculation functions and charting tools, coupled with successful marketing, make Excel the most popular personal computer data processing software.

Related Excel shortcut keys:

1, Ctrl Shift L

Filter shortcut keys, select the data table, you can enter the filtering state with one click, and then Press once to cancel filtering.

2. Enter

After copying, there is no need to click paste or press Ctrl V, just press the Enter key.

3. Alt Shift arrow key

combine shortcut keys to select the columns to be combined. Alt Shift right arrow can be combined with one click. Alt Shift Left Arrow Ungroup.

4. Ctrl Y

Restore shortcut key. Everyone knows that the undo operation is Ctrl Z. How many of you have used the restore shortcut key? For example, if you delete an area, press Ctrl z to undo the deletion. If you still decide to delete, press Ctrl y to restore the deletion operation

5, Alt D P

to open the PivotTable Wizard shortcut key, generally use Multi-range merge for PivotTable data. When pressing keys, press Alt D first, then quickly press the P key.

6, Ctrl 9 / 0

Ctrl 9 is the shortcut key for hiding rows, and Ctrl 0 is the shortcut key for hiding columns.

7. Tab

Enter the function shortcut key. Select a function letter such as =VL, and then press the Tab key to enter Vlookup and the left bracket

8. Ctrl A

After entering the function, press Ctrl A to pop up the function wizard, and you can view the detailed parameter setting method of the function.

9. Ctrl Shift End

Continuous areas can be selected with Ctrl A with one click, but when encountering areas with blank lines, you can use Ctrl shift end to select

10 , Shift Home

Select the shortcut key to the right to select the range from the current cell to column A. Unlike the Ctrl shift left arrow, shift Home can select the area up to column A regardless of whether there are empty rows, and the Ctrl Shift right arrow can only select non-empty areas.

11. Ctrl N, create a new Excel file with one click

In the past, I clicked "File-New-Blank Workbook" with the mouse. It is much more convenient to master the shortcut keys.

12. Ctrl 1, quickly open the cell formatting box

13. Ctrl P, open the printing interface with one click

14. Ctrl A, quickly select the current data No matter how big the table is, you can select it with one click~

15, Ctrl F1, quickly hide the ribbon

16, Ctrl 9 or 0, hide the rows with one click /Column

Ctrl 9 is a hidden row, Ctrl 0 is a hidden column

17, Ctrl - (minus sign), delete rows with one click

When deleting multiple times in a row , the speed is very fast, in addition, inserting a line is Ctrl Shift plus sign

18, Ctrl Alt A, one-click screenshot (when QQ is open)

When QQ is open, press Ctrl Alt A to start taking a screenshot. After taking the screenshot, press Ctrl Alt S to save the screenshot.

19. PgDn - page down; PgUp - page up

Use these two keys to flip the Excel table regularly, which is much more fun than dragging with the mouse~

20, Ctrl PgDn, quickly switch worksheets

For more Excel-related technical articles, please visit the

Excel Basic Tutorial

column to learn!

The above is the detailed content of What is the shortcut key for undoing in excel?. For more information, please follow other related articles on the PHP Chinese website!