I can t call up how to unhide WPS worksheets

1. Open the prepared electron** to hide the unit price.

2. Select the unit price column and right-click to select the hide option.

3. Then click the position in the picture to select the entire worksheet, right-click and click ** anywhere, and pop up to select Set Format Cell.

4. Under the Select Protection option, remove the check box Lock.

5. Select the worksheet tab below, and right-click to pop up and select Protect Worksheet.

6. Now select the cells adjacent to the hidden column, right-click and find that the unhide option is not available. That is, to achieve our purpose.

Click the tab Format Worksheet to unhide the selected worksheet OK, if it is a hidden row or column: check both the above and below rows of the hidden Format row to unhide.

Select all**, right-click ==> cancel the "Unhide" part: select all the areas between the upper and lower rows (columns) of the hidden rows (or columns) (note that it is the entire row (or column), not part of the area!) ), right-click ==> "Unhide".

It's filtered, it's filtered, it's filtered. Unfilter and select Show All.

WPS2013 version for the worksheet to unhide after hiding: menu bar Start Rows and columns Hide and unhide Select the rows and columns you want to cancel.

There are three reasons for this:

Indeed hidden: Select all**, unhide. Methods such as others.

Frozen**: Look at the bottom bar and shake it left and right.

Because of the reason for filtering: data, filtering, unfiltering.

1. First of all, open the WPS program, you can see at the top of the main interface of the WPS program, and the toolbar above the main interface of the WPS program is hidden.

2. Then, in the upper right corner of the main interface of the WPS program, find a "red square sign" messy, and click to open the dust imitation file.

3. Finally, you can see that the toolbar is displayed at the top of the main interface of "WPS Program", and the problem is solved.

WPS is a common office software.

The excel inside is also a tool that we often use to make **, and when we use that to do **, it is all **line, so what do we do if we want a **no**line? Share with you how to hide WPS**? If you don't want to hide, how do you unhide WPS**?

The first is WPS hidden cells, which are divided into two ways.

Method 1: Please look at the following picture**, the first step: If we only want to hide Zheng Kuan in the hidden state"2"For this group of content, we need to select all**, and then click on the format in the toolbar - Conditional Sail Bright Format.

Step 2: Then in the conditional formatting, we set it as follows: Cell value is equal to 2 , and then click"Format"

Step 3: First in"Fonts"Under Category, set the text color to white.

Step 4: Then switch to"borders"Category, click"Outer border"icon, then set the color to red, and then OK.

Now, the content of **2 is hidden, and the red border reminds us that this content is hidden.

Method 2: Hide the entire column or row directly, we directly select the column or row that needs to be hidden, and select it from the right-click menu"Hidden"

The entire E column is gone.

So what if we want to unhide cells? It should be noted here that for example, if we are hiding column e, then in alphabetical order, we need to select the first and second columns or rows of the hidden column or row, here, we need to select column d and column f, and then right-click the menu and select"Unhide"Can.

When making with WPS, the steps to hide and unhide WPS:

1. First of all, open WPS and select the area you want to operate.

2. Then, click the icon on the right side of "WPS**" in the upper left corner of the interface.

3. Then, click "Format" in the pop-up option box, and then click "Row" in the option box that appears.

4. Then, click "Hide" in the box that appears.

5. In this way, the content in ** is hidden.

6. If you want to unhide, repeat steps 1 3 again.

7. Then, click "Unhide" in the pop-up box.

8. In this way, the hiding is canceled.

Hidden columns, just select the hidden part of the columns, right-click, unhide it, hide the same for the rows, if you forget where to hide, there is a triangle to the bottom right at the intersection of the upper left row and column, click it, and then right-click in any place in the row or column, unhide it.

The steps to solve the toolbar of WPS** how can he not hide are as follows:

1.First of all, open the word layout of your WPS, and there is no toolbar at this time.

2.This has been tweaked so that the toolbar is displayed at the top, which is the ribbon, and the scrambled is not automatically hidden.

3.The operation method of Guqing tour body is that there is a triangle sign in the upper right corner of the WPS page. The position is to the left of the minimize button.

4.This triangle has two states, the toolbar will be displayed when it is facing up, and it will be hidden when the triangle is facing down. This solves the problem of how the toolbar of the reputation escort wps** can not be hidden.

Summary. WPS** unhide does not respond for the following reasons and solutions:1

There are formulas or formatting settings in the cells, and you need to cancel the relevant settings before you can unhide them. Solution: Select Conditional Formatting in the Format menu, find the setting, and cancel it.

2.There are some toolbars, buttons, graphs, etc. in the worksheet that cover the hidden area. Workaround:

Move these toolbars, buttons, graphics, and more to the visible area. 3.There are protected areas in the worksheet that need to be unprotected to be unhidden.

Workaround: Find the "Protect" option in the "Tools" menu and unprotect the sheet. 4.

If filtering or auto-filtering is set in the worksheet, you need to unfilter before you can unhide it. Solution: Find the filter option in the "Data" menu and cancel it.

5.The worksheet is abnormal due to program or system reasons, and the software or computer needs to be restarted. Workaround:

Save the workbook, shut down the software or computer, and restart the software or computer.

There are some toolbars, buttons, graphs, etc. in the worksheet that cover the hidden area. Workaround: Move these toolbars, buttons, graphics, etc. to the visible area.

3.There are protected areas in the worksheet that need to be unprotected to be unhidden. Workaround:

In the Tools menu, find the "Protective Protection" option and unprotect the worksheet. 4.If you set up a filter or automatic filter in the worksheet, you need to cancel the filter before you can cancel the hidden and clear the collection.

Solution: Find the filter option in the "Data" menu and cancel it. 5.

The worksheet is abnormal due to program or system reasons, and the software or computer needs to be restarted. Ways to solve the original book: Save the workbook, shut down the software or computer, restart the software or computer.

The up and down arrows appear on the ** line of WPS, which hides some lines and cannot be canceled.

There are a lot of up and down arrows, and you can't open them at all after clicking.

Kiss, you select a part of the area first, then right-click and click Cancel.

Neither does unhiding.

Paste Special in Actions is automatically hidden.

Did you hide it manually, or did you filter the area hide?

It didn't solve my problem at all.

Dear, don't worry, have you done the screening in **, if you have done the screening option, you need to cancel the screening first.

If you have filtered the option, you can't unhide it without unfiltering.

1.If you turn on the filtering function, click "Start - Filter" in the ribbon to cancel the filter, and the hidden content will appear. 2.

Turn on the freeze pane function, click the ribbon "View - Take the hall brother to remove the freeze" and then go to cancel the hide of the finch brother. , dear, you check these two first.

When making with WPS, the steps to hide and unhide WPS:

1. First of all, open WPS and select the area you want to operate.

2. Then, click the icon on the right side of "WPS**" in the upper left corner of the interface.

3. Then, click "Format" in the pop-up option box, and then click "Row" in the option box that appears.

4. Then, click "Hide" in the box that appears.

5. In this way, the content in ** is hidden.

6. If you want to unhide, repeat steps 1 3 again.

7. Then, click "Unhide" in the pop-up box.

8. In this way, the hiding is canceled.

First, open the WPS program, you can see it above the main interface of the WPS program, and the toolbar above the main interface of the WPS program is hidden.

2. Then, find a "red square sign" in the upper right corner of the main interface of the WPS program, and click to open it.

3. Finally, you can see that the toolbar is displayed at the top of the main interface of "WPS Program", and the problem is solved.

1. First of all, after opening WPS2019 on the computer, you can see that the main interface has a menu bar and no toolbar, click any menu button on the menu bar.

2. At this time, you can see the toolbar that displays the current menu.

3. Then click the "Fix" button in the upper right corner. In this way, you can pin the toolbar to the WPS2019 main interface.

4. Or click the [Show Ribbon] button in the upper right corner, that is, the button in the shape of a small tick in the upper right corner, and the toolbar can also be displayed.

**There is a "V" shaped scissor in the upper right corner, and the ribbon will be displayed after clicking; If an "inverted V" shaped clipper appears, click it to restore the ribbon.

Go to our computer desktop, right-click on the "New" option in the blank space, and then create a ** or word document.

When we click on the new document or document, we can see the icon on the desktop that we just created, here we click the icon to open it.

After we click on the icon, we enter the ** or document window, in this window, we notice that the toolbar at the top is hidden and disappears at this time.

Then, when we see that the toolbar is not available, we find the "Start" option in this window.

Once we have found the start option, we double-click on it with the mouse, and we will find that the toolbar appears.

Similarly, if we want to hide these toolbars, we do the same by double-clicking on the start option, and if we want to show the toolbar, we double-click again.

Thieves annoy WPS, clean up some useless features.

Turn on the WPS <>

Please click Enter a description.

Step 1: Left-click [File].

Please click Enter a description.

Step 2: Left-click on File, and then click Option (L).

Please click Enter a description.

Step 3: Find [View] and click [View] with the left mouse button

Please click Enter a description.

Step 4: Find Hide Ribbon (A) when Double-click Tab, and left-click Hide Ribbon (A) when Double-Click Tab. Cancel out:

Please click Enter a description.

Step 5: Cancel the Hide Ribbon (a) when double-clicking the tab, and then click OK with the left mouse. That's it:

Please click Enter a description.