Turn on step reading mode
Tool materials:
Computer, excel software
operational approach
0 1
Open the excel software (the 2007 version is shown here), and there is an "Edit" option box at the far right of the "Start" option at the top left. Let's click the fill option in this box.
02
After clicking, several options appear, and we choose the "series" option.
03
After selection, a dialog box of sequence options will appear, in which we can choose the filling type according to our own needs.
04
If you need to fill lines, select lines in the sequence dialog box, and then select arithmetic or equal ratio or automatic filling according to the required filling format.
05
After it is selected, just enter the first value, then put the mouse in the lower right corner of the box (a plus sign appears) and pull it to the right.
06
Column padding is similar to row padding. Just select the column in the previous sequence selection box.
07
After selecting a column, you only need the first value, and then drop the mouse finger in the lower right corner of the box.
The contents of sogou guide on this page are for reference only. Please operate carefully according to your actual situation. Especially for matters involving your interests or the interests of third parties, please consult professionals.
1 Not helpful.
View full text
Everyone is looking for it.
How to set up automatic filling of excel tables?
Automatically fill excel tables
Excel fills a lot of data in batches.
How excel Automatically Fill in Data
Excel automatically fills in text.
How to set the order of table filling?
Excel fill settings
How to fill in the form automatically?
Relevant suggestions
Excel automatic filling function
Enthusiastic devotion
Workplace/financial management
How to use the auto-fill function in Excel
Prosperous
Games/digital
How to use the automatic filling function of excel
hurricane
Games/digital
How to use the auto-fill function in Excel
Time record
Games/digital
Automatic filling function in excel
calmly
Games/digital
Sock machine, processing socks, improve the socks industry!
advertisement
load cargo
operational approach
Open the excel software (the 2007 version is shown here), and there is an "Edit" option box at the far right of the "Start" option at the top left. Let's click the fill option in this box.
After clicking, several options appear, and we choose the "series" option.
After selection, a dialog box of sequence options will appear, in which we can choose the filling type according to our own needs.
If you need to fill lines, select lines in the sequence dialog box, and then select arithmetic or equal ratio or automatic filling according to the required filling format.
After it is selected, just enter the first value, then put the mouse in the lower right corner of the box (a plus sign appears) and pull it to the right.
Column padding is similar to row padding. Just select the column in the previous sequence selection box.
After selecting a column, you only need the first value, and then drop the mouse finger in the lower right corner of the box.
0 1/07
operational approach
Click on the directory to quickly jump to the corresponding position on the page.
0 1 Open the excel software (the 2007 version is shown here), and there is an "Edit" option box at the far right of the "Start" option at the top left. Let's click the fill option in this box.
After clicking 02, several options appear, so we choose the "series" option.
After selection, a dialog box of sequence options will appear, in which we can choose the filling type according to our own needs.
If you need to fill lines, select lines in the sequence dialog box, and then select arithmetic or equal ratio or automatic filling according to the required filling format.
After selecting 05, just enter the first value, and then put the mouse in the lower right corner of the box (a plus sign appears) and pull it to the right.
The filling of column 06 is similar to the filling of rows. Just select the column in the previous sequence selection box.
After selecting a column, you only need the first value, and then you can drop the mouse finger in the lower right corner of the box.