EXCEL Practical Skills Series

  1. Copy the cell into a picture:
    1 Select an area
    2 Press and hold SHIFT, click Edit/Copy Image
    3 Select in the pop-up dialog box according to your own requirements
    4 OK
  2. How to use the camera
    You can right-click on the menu bar, select Customize, then in Command-Tools-Camera, drag the camera to the toolbar, you can use it to shoot what you want to shoot.
  3. Change the number in “yuan” to “ten thousand yuan”
    Just enter 10000 in a cell, copy it, select the conversion range, right-click “Paste Special” – Value (check “Division”)!
  4. Enter the same data in multiple cells
    To enter the same data in multiple cells, first select the cells to be filled in, then use the keyboard to input, and finally use Ctrl+Enter.

Five, the method of hiding the contents of the cell

  1. Format the cell as “;;;” (three semicolons)
  2. Format Cells -> Protect, and check Hidden.
  3. Protect worksheets
    In this way, the content of the cell is not visible either in the cell or in the edit box.

Six, clever use of Excel status bar
By right-clicking on the status bar, you can select Mean, Count, Count Values ​​(only cells containing values), Max, Min or Sum. When you select a cell in the worksheet, a corresponding prompt will appear in the status bar.

  1. Quick Paste
    After copying the content of the selected cell, select the target cell, and then press Enter to achieve fast paste!

Eight, fast zoom display ratio
If the mouse has a scroll wheel, press and hold Ctrl + scroll wheel up in Excel, the display scale will be enlarged, and scroll wheel down will reduce the scale.
[ To quickly increase or decrease the screen magnification percentage:

  1. Select a cell.
  2. Press Ctrl, and roll the mouse wheel forward (to increase the magnification) or backward (to decrease it). ]

Nine, two ways to enter the formula

  1. Regular input: “=” + content
  2. Do not use “=”, add “+” or “-” before the formula, for example -27 + 14 ;+B2 + B3
    (There is one other way that you can enter formulas into Excel: through the use of an implied equal sign. You do this by prefacing the formula with a plus sign or a minus sign )

Ten, the use of clipboard

  1. Press Edit – OFFICE Clipboard ( From the edit menu, select office Clipboard )
  2. Press Ctrl + C + C to open the clipboard so that you can manage and use previously copied information ( use the keyboard shortcut Ctrl + C + C to open the Task Pane dialog box, which contains the copied ranges ( up to 24 ) that have been saved to memory. )
  3. Hiding Subtotal Level Buttons
    To hide the Subtotal level buttons: Press Ctrl + 8. To redisplay the Subtotal level buttons: Press Ctrl + 8 again. )
  4. To quickly remove subtotals: )

method one

  1. Select any cell in the subtotal area, then select Data – Sort ( Select any cell in the List and click Sort Ascending or Sort Descending. )
  2. Click OK ( Click OK in the dialog message box. )

Method Two

  1. Select Data-Subtotals ( From the Data menu, select Subtotals ).
  2. Click Remove All.
  3. Quickly select discontinuous cells
    Press the key combination “Shift + F8” to activate the “Add Selected” mode. At this time, the word “Add” will be displayed in the status bar below the workbook, and then click the discontinuous cells or cell ranges respectively. Select without holding down the Ctrl key.
  4. The peculiar F4 key
    There is a shortcut key in Excel that is extremely prominent, and that is the F4 key. As a “repeat” key, the F4 key can repeat the previous operation, saving the time of menu selection.
  5. Print the chart (ignoring other data)
    Select the chart to be printed, then select “File” – Page Setup – Chart, and select “Print Preview”.

Leave a Reply

Your email address will not be published. Required fields are marked *