Pick up keys in excel, what are the shortcuts for options in Excel

1. There is no direct shortcut key for "Tools" and "Options" in Excle. However, we can click "Alt+T" to open the "Tools" menu, and then click "O" to open "Options".

2. Offide software word or excel or other software, there is a letter after the Chinese character in the menu bar. Clicking the alt key and this letter on the keyboard will open different menus instead of the mouse (e.g. alt+t in the image above to open the tool menu). Click the next level letter to open the next level dialog (e.g., click p to bring up the worksheet protection dialog).

3. In the above figure, there is an F7 after "Tools" and "Spell Check", and F7 is the shortcut key to open the spell check. Others, such as the copy shortcut "Ctrl+C" and the paste shortcut "Ctrl+V", are displayed on the menu.

What options

options?

zlt+ t o

I don't know directly

1. The shortcut key to insert the whole line is ctrl+"+key.

2. The shortcut key to delete the whole line is ctrl+"-key.

You can also insert a row first, and then press F4 to repeat the operation, and if you need to insert a few lines, press F4 a few times.

Alt+I+R or Ctrl and the numpad "+" and then R

The skill of quickly inserting multiple lines in Excel** is very convenient and fast, and the work efficiency is greatly increased.

ctrl＋ "－"Quickly delete ctrl+shift+"＝"Quick plug-in.

There are three ways to quickly get an excel file back to top:

1. Press the key combination Ctrl+Home or Ctrl+Up Arrow.

2. Use the right mouse button to click on the right scroll bar - "Top".

3. Enter A1 in the name box in the upper left corner.

In Excel, the shortcut key for quick back to top is Ctrl+Home.

Excel shortcut key introduction:

1.Move and scroll in the worksheet to move cell arrow keys up, down, left or right;

2.Move to the edge of the current data region: Ctrl+ Arrow Keys;

3.Move to the top of the line: home ;

4.Move to the beginning of the worksheet: Ctrl+Home;

5.Move to the last cell of the worksheet. ：ctrl+end ；

6.Move down a screen: page down ;

7.Move up a screen: page up ;

8.Move one screen to the right: alt+page down ;

9.Move one screen to the left: alt+page up;

11.Move to the previous worksheet in the workbook: Ctrl+Page Up;

13.Move to the previous workbook or window: Ctrl+Shift+F6;

16.Scroll and show the active cell: CTRL+BACKSPACE;

17.Displays the Positioning dialog box: f5;

18.Displays the Find dialog box: shift+f5;

20.Move between non-locked cells in the protection worksheet: tab.

The shortcut key to fill down is: Ctrl+D; The shortcut key to fill in to the right is: Ctrl+R.

Quick Fill Operation:

1. Open Excel** and enter data in column A cells.

2. Select the cells that need to be filled down, for example, if you select cells A5 to A10 in the following figure, you need to fill the data of A5 down to A10.

3. After selection, press "CTRL+D" on the keyboard.

4. You can quickly fill the data of A5 down into the selected cell.

5. Then select cells A1 to D1.

6. Press the "Ctrl+R" button on the keyboard.

7. You can quickly fill the data in the A1 cell to the right into the selected cell.

The way to quickly fill down or right in Excel.

In Excel, in addition to using fill handles to quickly fill cell contents in a certain area, you can also use shortcut keys. For example, if we have a value or formula in cell A5, we want to fill it in the A6:A20 area below.

To do this, select the region A5:A20 and press the shortcut Ctrl+D. If you want to fill the numeric values or formulas in the A5 cell to the right side, such as B5:

In the z5 area, you can select A5:Z5 and press the shortcut Ctrl+R. It is equivalent to double-clicking or dragging a fill handle.

Actually, this function is the default function of Excel, if you are proficient in the operation of the keyboard, this is not a problem at all: first you point to any cell, such as A1, when typing, press the Tab key, it will automatically jump to the next cell, the default is to move a grid horizontally to the right. Enter this line in turn, when the line ends, hit enter, the cursor will automatically return to the cell of the next row of the first cell, such as a2, but if you use the mouse in this process, the cell that the mouse points to will be reset to the starting cell.

So, this requires you to use the keyboard as much as possible to complete the typing process.

Alt+Enter is a forced line break in the cell, and home is back to the A1 box in the upper left corner.

There are four arrows in the health plate.,Just press there.。

No need for quick build! Just press enter (cursor down) + home and you're good to go.

Select the superscript number first, and then right-click to set the cell, and there is a superscript hook in it.

Word, the superscript is: ctrl + shift + = and the subscript is: ctrl + =

In Excel, you can define subscripts only with styles. In"Format"menu"Style", because the upper and lower superscripts in Excel can be moved.