How to set the data in the range of data in excel

The specific steps are as follows:

step 1

In the open Excel**, use the shortcut key Ctrl+A to select the whole **, click the "Start" tab in the menu bar, and click the "Format" - "Format Cells" option under the "Cells" group. (You can also right-click and click "Format Cells" in the shortcut menu).

step 2

In the pop-up Format Cell dialog box, select the Protection tab, uncheck the Lock option, and then click OK.

step 3

Select the cells we want to set (i.e., the cells that are not modified for others), open the "Format Cells Dialog Box", check "Lock" and "Hide" under the "Protect" option bar, and then click OK.

step 4

Click the Review tab in the menu bar, and click Protect Worksheet in the Changes group. In the pop-up "Protect Worksheet" dialog box, set the password, check "Select unlocked cells", and then click OK.

step 5

After the above operation is completed, the "Confirm Password" dialog box will automatically pop up, enter the password again, and click OK. Complete the protection of the worksheet.

step 6

If you want to return to any status, click "Revoke Worksheet Protection" under the "Review" tab in the menu bar, enter the password in the pop-up dialog box and click OK.

Excel sets the method of filling the data in the range.

In the first cell, enter the formula=randbetween(min, max) If it is a non-integer, enter the formula=randbetween(min, max -1) + rand().

Drag it down.

Example: Quickly fill in an integer from 1 to 20 in a1:a20 and any number from 1 to 20 in b1:b20.

1.Enter the formula in cell A1: =randbetween(1,20)Enter the formula in cell B1:=randbetween(1,19)+rand().

2.Select a1:b1, click in the lower right corner, and drag the value a20:b20

Hello <>

To quickly fill in the numbers in the range in Excel, there are two ways to choose. The first way is to use the fill function, first enter the number you want in the first cell, then move the mouse to the small black square in the lower right corner of the cell, the cursor will change to a black cross, and then click and drag the mouse, you can quickly fill the number in the range. The second method is to use the autofill function, first enter the required number in the first single code cell box, and then select which cell is missing and the cell on the right side that needs to be filled with numbers, click the autofill button, you can quickly fill in the number in the range.

Extended supplement: In addition to filling numbers, Excel can also quickly fill in content such as date, time, text, etc. For date and time, just enter a specific date or time in the first cell, and then use one of the two methods above to quickly fill.

For text, you can enter the desired text in the first cell, and then select the cell and which side of it needs to be filled with text on the right, and use one of the above two methods to quickly fill it. In addition, Excel also provides more advanced auto-fill functions, such as filling in number sequences, copying formulas, etc., and you can choose different filling methods according to specific needs. <>

How does excel populate? It's simple, let me teach you!

1.This can be done with conditional formatting. Here's how to do it (let's say 80 is light blue and 50 is orange):

2.Select the area of the data, click the Start tab, and click New Rule in Conditional Formatting.

3.Click New Rule;

4.Click "Use formula to top cells to be formatted", enter =$b 2 80 in "Format values that match this formula", and click "Format" below.

5.Click Fill, select light blue, and click OK;

6.After clicking Apply, the background color of 80 data will change to light blue;

7.In the same way, set the data background color of 50 to orange;

8.Click OK to set the data color change that is not in the range of 50 to 80.

Enter in the first row and enter in the second row, select both cells at the same time, drag the fill handle to drop down; Then fill 201 to 231 in the same way.

Enter the formula ="qw234wwwr205010" & row()+107 & ".psd"

row() is the meaning of the current line, write this formula on the first line you need to fill in, row() + add this number modified to the value you need to subtract the current line, and then fill it down.

For example, in line 10, the formula is ="qw234wwwr205010" & row()+91 & ".psd"

On line 1000, the formula is ="qw234wwwr205010" & row()-977 & ".psd"