36 Excel Tips that you can't miss

36 Excel Tips that you can't miss

1, a column of data at the same time divided by 10000

Copy 10000 cells, select the data area-select sticky Paste-except

2. Freeze rows 1th and 1th at the same time

Select the corner position of the first column and the first line intersection B2, window-frozen pane

3, quickly convert the formula to a value

Select Formula Area-Press right to drag right and drag back-select to retain only numeric values.

4. Show all formulas in specified area

find = Replace with "=" (space + +) to display all formulas in the worksheet

5. Edit all worksheets at the same time

Select all worksheets, edit them directly, and update to all worksheets.

6, delete duplicate values

Select data region-data-delete duplicate values

7, display duplicate value

Select data Range-Start-conditional formatting-Display rule-duplicate value

8. Convert text-type numbers to numerical types

Select the text number area, open the green triangle of the upper-left cell, and select Convert to numeric

9. Hide cell contents

Select the area to hide-set cell format-number-custom-enter three semicolons;;;

10. Add password to excel file

FILE-Information-Protect workbook-Encrypt with password