Joke Collection Website - Joke collection - How to change the number 1-7 in the excel table directly to 6- 12 without changing the contents in the table?
How to change the number 1-7 in the excel table directly to 6- 12 without changing the contents in the table?
Similar to the idea of enjoylonely.
First, separate the numbers from the words, as shown in the figure.
Then copy the cell, as shown in the figure below.
Next, select the copied cell and copy it.
Still in the selected area, right click → Paste Special → Paste Value.
Then fill in the number columns in turn.
Put the numbers and words back together in the original cell.
Drag down to copy the fill.
Then copy this area → Right click → Paste Special → Paste the value. To successfully complete something
- Previous article:After reading "The Skirt"
- Next article:Excuse me, I'm going to volunteer to play another wave of Migu Music.
- Related articles
- The sixth grade Chinese Book 1 Unit 1 Composition 10
- The synopsis of the story of a coincidence
- Mom, I like your excellent composition.
- Who has a short classic joke?
- Remembering my father
- When you first start doing something, you must know this
- Kfc crazy Thursday English
- How to be honest as a party activist?
- If an official doesn't make decisions for the people, why not go home and eat sweet potatoes?
- 65-year-old mother-in-law insists on 24-year breakup fee