How does WPS quickly select cells in a specified area?

First method:

Ctrl+G brings up the positioning dialog box, enter A1:E5000 in the Reference Location, and click OK.

The second method:

Enter a1:e5000 in the name box in the upper left corner of the program, and press enter.

The third method:

Select any cell in the cell range and press CTRL+SHIFT+* to select the entire range of the cell.

Fourth method:

Press Ctrl+End to jump to the far right of the area.

Cells in the lower corner, selected with the mouse; Then pull the scroll bar back to the first row, hold down shift, and click A1 with the mouse.

Open WPS from your desktop or from the Start menu

Then enter the rows and columns of the cells in the specified area in the name box of WPS, and you can select them.

Take a look at the legend below.

In Excel2013, hold Ctrl+G to bring it up, and then enter A4:B100 to locate it. ”

In Excel, instead of selecting the region in this way, you can directly enter A4:B100 Enter in the name box in the upper left corner, and you can select A4:B100.

This method of selecting a range of cells also applies to WPS.

The attached diagram circles the location of the name box.

Open WPS2019**.

Please click Enter a description.

If you need to box select ** for a specified region, first select the first cell of the specified region.

Please click Enter a description.

Then press the shift key and click the last cell of the specified region to select the content of the specified region**.

Please click Enter a description.

If all ** is selected, the first row is selected first.

Please click Enter a description.

Then press the shift key to select the last row to complete the selection.

Please click Enter a description.

You can also click on any cell in ** and press CTRL+A to select all**.

Please click Enter a description.

1. Enter all the content contained in the relevant drop-down options, which must be comprehensive, otherwise it will be very troublesome.

2. Find validity. Select the area where you need to set the drop-down option button, select the size of the area, and determine the scope of your future operation, and also be comprehensive. Then select the data one at a time - Validity - Validity.

3. Find the sequence. In Effectivity Condition, select the sequence from the Allowed drop-down options.

<>5. Box select the relevant data entered in the first step.

6. Effect display. Mouse click on the second step of the selected area of any of the bright clear cells, will find, there is a triangle behind, click, you can pop up the next Tong front pull selection box key chain. (After it is done, for the sake of beauty, the column of the input content is generally hidden).

If there are hidden rows and columns, how can I quickly copy the currently displayed part without selecting the hidden ones? Excel has this function, how to find it in WPS? Let me tell you the steps of Fast Retailing WPS to select only the displayed cells.

WPS only allows the selected cells to be displayed in the procedure Open WPS and select the area to be copied.

WPS only allows the selected cells to be displayed in Figure 1Press the Ctrl + G shortcut.

Select the visible cell in the positioning.

WPS only allows the selected cells to be displayed in Figure 2Then copy the area and paste.

WPS** Method of setting a double selection box 1, right-click to select a cell - set the cell format;

Figure 1 shows how to set the double selection box for WPS**2. Select Border-Style-Double Horizontal, and click in the border bar.

Figure 2 shows how to set up a double selection box for WPS

WPS** Spine Changchai method for setting up double selection box Figure 3You may also like: 1WPS**Sakura how to use the hidden function.

2.WPS how to select only the displayed cells.

3.WPS how to choose it.

4.WPS** How to set up a method to implement cross-sheet data referencing.

5.WPS**What should I do if the specified region cannot be used.

6.WPS** How to set up a double selection box.

7.How to set the input specified content in WPS**.

1. First, we open our computer, and then we open a WPS file on our computer.

2. After that, we click to select the cells we want to target.

3. After that, we press the Ctrl+G key on the keyboard, which is a shortcut key to open positioning.

4. After that, we set it up according to our needs, and finally we click on positioning.

Enter b97 in the address bar of the cell, press the confirm key, and it will be automatically located in the b97 cell.

Hello, glad to answer for you!

Enter "D796" in the Name Box as shown in the following figure, and press Enter to locate the cell.

Win a Mi Box.

Enter d796 in the Name box and press Enter.

The specific steps are as follows:

The materials that need to be prepared are: computer, WPS**.

1. First open the required WPS** and enter the page.

2. Then click on the first cell.

3. Then press "Ctrl+Shift+Down Arrow" on your keyboard.

4. Then you can select all the cells with data below.

Raw material required: WPS**.

Method for multi-selecting cells in WPS:

The first method: Hold down the Ctrl key and click the mouse to select multiple cells without contiguous methodThe second method: Hold down the shift key and click the mouse to select consecutive cells.

Hold down the Ctrl key and click the mouse to multi-select cells without consecutiveness.

1.First, select the cell or range of cells you want to make a drop-down menu--- data --- validity --- allow --- selection"Sequence"---**--- Enter the options you want to populate--- such as: Male, Female (separated by commas) -- OK.

3.Press the button circled in red.

4.Select the range of cells shown in Figure 1 (this area is the options in the drop-down list).

When you're done, press the button shown in Figure 2 --- finally press the OK button.

In this way, the drop-down menu grid is made, and the effect is as shown below.

Start the software and create a new file entry.

First, start the WPS software, create a new file, and start making. I'll just open the last ** to illustrate.

Please click Enter a description.

Box selection to select multiple cells.

If you want to select a cell, you only need to click once, while you can select multiple cells with the mouse to turn green and be selected.

Please click Enter a description.

With the shift key to select.

If we want to select a range of cells, we can first click on the first cell in the upper left corner, and then hold down the shift key and click on the rightmost one to select it.

Please click Enter a description.

Add with ctrl.

If we want to select discontinuous cells, we can click once, then hold down the Ctrl key without letting go, click the next one, and then we can select multiple discontinuous cells.

Please click Enter a description.

Use the box above to enter.

We see a box in the upper left corner of the file that shows the ordinal number we have selected, and we can use this display area to show which cell we have selected, and here it will be displayed.

Please click Enter a description.

Enter a numeric value. Enter the starting number position in a field: the last cell position, press enter.

Multiple range input starting number position: last cell position, second range starting number position: last cell position.

Please click Enter a description.

Click Enter to see the effect.

After typing and clicking enter, multiple sections are selected, and multiple areas are separated by commas.

Please click Enter a description.

Choose the convenient method according to your needs.

We can use it with the CTRL and SHIFT keys to quickly select multiple parts.

Please click Enter a description.

1.First, select the cell or cell area where you want to make a drop-down menu--- data --- validity--- allow --- selection"Sequence"--**--- Enter the options you want to populate--- such as typing:

3.Press the button circled in red.

4.Select the range of cells shown in Figure 1 (this area is the selection of the Beat drop-down list).

When you're done, press the button shown in Figure 2 --- finally press the OK button.

In this way, the drop-down menu grid is made, and the effect is as shown below.