Shulou(Shulou.com)06/01 Report--

This article will explain in detail what excel skills are commonly used in the office, and the content of the article is of high quality, so the editor will share it with you for reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

In the daily use of office software, Excel is used very often, and its function is very powerful.

If you do not master its tricks, many functions can not be easily achieved, today for you to sort out the practical skills when making Excel forms, so that you will never ask for help when making forms in the future.

1. Excel skills commonly used in the office-- file manipulation  

1. Add an open password for the excel file

File-information-protect workbook-encrypt with password.

2. Add author information to the file

Right-click on the excel file icon-- Properties-- Summary-- enter in the author column

3. Let multiple people share excel files through the local area network

Review-share workbook-select "allow multiple users to edit at the same time." on the open window.

4. Open multiple excel files at the same time

Press the ctrl or shift key to select multiple excel files to open, and right-click "Open" in the menu

Close all open excel files at the same time

Press the shift key and click the upper right corner to close the button.

6. Set the automatic saving time of files.

File-options-Save-set save interval

7. Restore unprotected excel files

Files-- recently used files-- Click "restore unsaved excel files"

8. Create a calendar in the excel file

Document-New-Calendar

9. Set the default font and font size for the newly created excel file

File-options-General-when creating a new workbook: set font size and font

10. Display the A.xlsx file icon as a picture

Change A.xlsx   to   A.Jpg

11. Create a new excel file with one click

Ctrl   +   N

Save the worksheet as an excel file

Right-click on the worksheet tab-- move or copy-- move to New Workbook

2. Common excel skills in the office-- window setting  

1. Open and compare two or more excel files at the same time

View-- rearrange all-- choose the direction of the arrangement

2. Find two worksheets in a workbook at the same time

View-create a new window-rearrange all-choose the direction of arrangement

3. Hide or show the top functional area of excel

Ctrl+F1

4. Hide the excel worksheet interface

Select the worksheet to hide-View-hide

5. Always display the title line at the top

View-freeze pane-freeze first row

6. Split the window into two parts, both of which can be flipped up and down.

Select the location to split-view-split

7. Adjust the display scale of excel worksheet

Press ctrl+ scroll wheel

8. Quickly switch to another excel window

Ctrl   +   tab key

9. Full-screen excel interface

View-full screen display

Third, excel skills commonly used in the office-cell display

1. Hide the 0 value

File--   option-- Advanced--   removes "at zero value." Check

2. Hide all values in the cell

Ctrl+1 opens the cell settings window-- number--   customization-- enter three semicolons in the right box.

3. Hide the edit bar, gray grid lines, column labels, and row numbers

View-- display-- uncheck the   items

4. Common excel skills in the office--   for cell selection

1  , select the current form

Press ctrl+a to select all current data regions

2  , select values / formulas in the table

Press ctrl+g to open the positioning window-positioning conditions-values / formulas

3  , lookup value

Press ctrl+f to open the search window and enter the value you are looking for-find

4. Select the bottom / rightmost non-empty cell

Press ctrl   +   Down / right Arrow

5. Quickly select the area of specified size

Enter the cell address, such as a1:a10000, in the name column on the upper left, and then press enter

5. Common excel skills in the office--   for cell editing

1. Set the direction of cell cursor jump by pressing enter key

File-options-Advanced-Top "move selection after pressing Enter"-set orientation

2. Set the drop-down menu to display the three options of Apene Bjorn C

Data-- data validity-- allow-- sequence-- enter A _ Magi B ~ C

3. Copy the table and keep the row height and column width unchanged.

Full row selection copy-"preserve column width" in the post-paste option

4. When you enter the F column, automatically go to the first column of the next row

Select column ARV F, enter and press enter to jump automatically.

5. Set the three-column header

Insert-shape-line-drag into the font entered in the text box and set the border to none

6. Edit multiple worksheets at the same time

Press ctrl or shift to select multiple worksheets and edit the current worksheet directly.

7. Enter the ID number or a number that starts with 0

Format the cell as text, and then enter

8. Quickly delete blank lines

Select a column in the table-  ctrl+g positioning-positioning condition-null value-delete the entire row

9. Quickly insert blank lines

10. Quickly merge multiple rows of data

Insert comments-select multiple columns of data to copy-paste into the annotation, and then copy and paste from the annotation into the range of cells.

11. Insert a special symbol

Insert-symbol

12. Find duplicate values

Select data column-start-conditional format-highlight cell rules-duplicate values

13. Delete duplicate values

Select region-data-delete duplicates

14. Cell subregions need a password to edit

Review-allows users to edit areas

15. Chinese-English translation with excel

Review-- interpretation

16. Do not copy hidden rows

Select area-ctrl+g location-location condition-visible cell-copy-paste

17. The cell is forced to wrap

Press alt+enter after the newline character is required

6. Common excel skills in the office-- cell format setting  

1. Ten thousand yuan display

Custom format code: 0 ",'0

2. The date is displayed by year, year, month, month, day and day

Custom format code: yyyy-mm-dd

3. Segment display of mobile phone number

Custom format code: 000   0000   0000

4. The number 1 is displayed as January

Custom format code:   0 "month"

7. Excel skills commonly used in offices-- picture processing

1. Delete all pictures in the worksheet

Ctrl+g positioning-positioning conditions-objects-deletion

2. Insert background picture into worksheet

Page layout-background-choose to insert picture

3. Insert a printable background

Insert-header footer-select the picture after the header-select the picture and drag it into

8. Common excel skills in the office-- print setting  

1. Print the title line

Page layout-print title-collapse button after the top title line, select the title line to print.

2. Force multiple pages to be printed on one page

Page layout-print title-page-adjust to 1 page width and 1 page height

3. Set the row height in centimeters

View-page layout, in which the descending height unit is centimeters

4. Insert a page break

Select the location to insert-page layout-page break-insert page break

About the office commonly used excel skills to share here, I hope that the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.