How to scroll down the unit price of the computer form?

Answer 1

If you want to do something similar to drop-down filling in the unit price and calculating the amount in the Excel table, you can do it as follows:
1. Enter any letter first, then enter quantity * unit price (assuming quantity and unit price are the corresponding cell data), and do the same for the next cell;
2. For the third cell, he pressed the button 'Ctrl'+' E 'to fill the remaining cells.
3. He selected the cells, pressed the button 'Ctrl'+' H', replaced the letters with '=', and then clicked 'replace all'.

If you want to set a drop-down list of unit prices in a cell, do the following:
1. Choose the cell that you want to set the drop-down menu, click [Data], and then click [Data Verification]-[Data Verification] in the [Data Tools] column, and a dialog box will pop up.
2. In the "Data Verification" dialog box, click "Set" and "Allow" to select "Sequence". In the "Source", you can manually input unit price data (such as 1, 2, 3, etc., each data is separated by commas in the English input method), or you can quote the unit price content list that has been entered in advance (click the red arrow at the back to directly quote).
3. The drop-down menu was completed. He clicked on the cell, and a triangular button appeared at the bottom right corner. He could click to expand the drop-down menu and select the unit price content.
Read more exciting novels for free