WPS Table Hide Cells and unhide methods

Source: Internet
Author: User

Today, we're going to learn how to hide tables in a wps table. When it comes to hiding a table, it refers to the hidden cell data, which can be a single cell data being hidden, or it can be a whole row or a whole column of data being hidden. Let's take a look at the WPS. Two ways to hide cells in a table. Of course, in this tutorial, the small set will also teach you to remove hidden cells by setting the method to unhide them.

The first is the WPS hidden cell, which is divided into two different ways.

The first step: if we just want to hide the 2, we need to select all the tables and click the format-conditional format in the toolbar.


Step two: Then in the conditional formatting, we set the following: the cell value is equal to 2, and then click Format


Step three: First in the font category, the text color is set to white.


Step Fourth: Then switch to the "border" category, click the "Outside" icon, and then set the color to red, then determine.

In this case, 2 of the contents of the table are hidden, and the red border reminds us that the content is hidden.


Method Two: Is directly hides the entire column or the row, we directly select needs to hide the column or the row, the right key menu chooses "hides";


The whole E-column was gone;


So what do we do if we want to unhide the cells? Here's a note, for example, that we're hiding the e column, so in alphabetical order, we're going to select the two columns or rows of hidden columns or rows,


Here, we just need to select columns D and F, and then right-click the menu and choose Unhide.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.