Copying and pasting information into the cells of the resume form is a difficult operation for individual job seekers to make resumes. Here, I will teach you how to copy and paste information into the cells of the filtered resume form. I hope you will gain something!

The method of copying and pasting data into the filtered resume table cell 1 First, there must be a table;

Second, filter out the items containing a in the class;

3. After selecting the filtered content, press ALT+; , copy and paste to other places;

Or Ctrl+G- positioning condition-visible cell -ok, copy and paste it elsewhere;

Then how to paste the copied contents into the filtered table:

First, a form is needed; I will change the items in the class column that does not contain a in this form to the following table;

Second, insert two columns on the right side of the class, column A and column B; 3. Enter 1 in the first cell under column A to fill in the next sequence;

Fourth, filter out the items that do not contain A in the class, select the cells under column B, and press ALT+; Enter 1 and press Ctrl+Enter, which is equivalent to visible cell filling, and the filtering is cancelled;

5. Sort by column B, and the cells containing 1 in column B are arranged at the top in order; Select the content to be replaced, copy and paste it on the class bar; Finally, sort by column A, delete columns A and B, and then return to the original state. All right.

Matters needing attention in making resume form 1 Don't use underline to connect with handwriting, which may lead to misunderstanding. For example, consider f as e, so when using horizontal lines, pay attention to the distance between the horizontal lines and the words in adjacent lines.

2. Using white paper will reduce the resolution of computer handwriting, so it is best to use white paper; Please use computer typesetting, laser printing and white A-4 paper.

3. Don't use handwriting and italics. Most computers have low resolution for handwriting and italics. If employers use computers to process job application materials, handwriting and skew will have a negative impact on you.

4. Enclose the area code of the telephone number in brackets. For the sake of formality, please put the area code of the telephone number in brackets so that readers can distinguish the telephone numbers.

5. E-mail addresses and websites are arranged separately for easy identification; The juxtaposition of the two should be separated by multiple spaces.

6. Cite keywords to reflect recruitment requirements. Quote the key words of the main skills and experience needed for the job, and let the letter highlight the key points. When recruiting office workers, employers will ask you to be familiar with word processing systems and recruit engineers. You need to know drawing and design software. In short, advertising will have corresponding specific quality and skill requirements for different positions. If you meet the requirements, quote these keywords in your cover letter to describe your strengths. If there is no specific requirement in the advertisement, you should show your advantages in the letter.

7. Don't fold it. Maybe the other party uses a scanner to scan the candidate's resume into the computer, so it's best not to have too many folds in your resume materials to avoid scanning difficulties.

8. When scanning with a stapler, the materials bound with the stapler are not easy to disassemble, so it is better to use less.

9. Avoid using charts. Some computers don't recognize charts, so avoid using charts in cover letters to avoid losing information.

10. Use the vertical bar carefully. The redundant vertical bar is usually recognized by the computer as the letter "L", so use it carefully.

Method of copying and pasting data into filtered resume table cells