Home Common Problem How to create table of contents and hyperlinks in wps form?

How to create table of contents and hyperlinks in wps form?

Jul 07, 2020 am 11:58 AM
wps Table of contents Hyperlink

How to create table of contents and hyperlinks for wps tables: First click on one of the worksheet names, right-click the mouse, and select [Create table directory]; then select [Save to new worksheet] and [OK], and Change the reference location; finally select [Edit Hyperlink] and click [OK].

How to create table of contents and hyperlinks in wps form?

How to create table of contents and hyperlinks in wps table:

1. Click on one of the worksheet names → click Right-click the mouse → select [Create table directory];

How to create table of contents and hyperlinks in wps form?

2. Select [Save to new worksheet] → click [OK] to complete the creation;

How to create table of contents and hyperlinks in wps form?

3. You can see that a hyperlink directory has been created in the new worksheet Sheet1. Click the corresponding table name and a jump will occur. Click Return to return to the directory;

How to create table of contents and hyperlinks in wps form?

4. Note: If you change the name of the worksheet, the reference will become invalid. For example, change "Data Source" to "Data Source Table", and then click "Data" in the hyperlink. Source", a prompt window will pop up, as shown in the figure;

How to create table of contents and hyperlinks in wps form?

5. At this time, we only need to change the reference position;

How to create table of contents and hyperlinks in wps form?

6. Select the hyperlink before renaming the worksheet → right-click the mouse → select [Edit Hyperlink];

How to create table of contents and hyperlinks in wps form?

7. Select the reference Position [Data Source Table] → The displayed text can be modified or not → click [OK].

How to create table of contents and hyperlinks in wps form?

The above is the detailed content of How to create table of contents and hyperlinks in wps form?. For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
1 months ago By 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

WPS and Office do not have Chinese fonts, and Chinese font names are displayed in English. WPS and Office do not have Chinese fonts, and Chinese font names are displayed in English. Jun 19, 2024 am 06:56 AM

My friend's computer, all Chinese fonts such as imitation Song, Kai style, Xing Kai, Microsoft Yahei, etc. cannot be found in WPS and OFFICE. The editor below will tell you how to solve this problem. The fonts in the system are normal, but all fonts in the WPS font options are not available, only cloud fonts. OFFICE only has English fonts, not any Chinese fonts. After installing different versions of WPS, English fonts are available, but there is also no Chinese font. Solution: Control Panel → Categories → Clock, Language, and Region → Change Display Language → (Region and Language) Management → (Language for Non-Unicode Programs) Change System Regional Settings → Chinese (Simplified, China) → Restart. Control Panel, change the view mode in the upper right corner to "Category", Clock, Language and Region, change

How to use wps translation function_How to use wps translation function How to use wps translation function_How to use wps translation function Mar 27, 2024 pm 04:46 PM

1. First, we open wpsoffice on the mobile phone. 2. Then click Apply. 3. Click the image to translate. Method 2 1. First, we open wpsoffice on the mobile phone. 2. Open the document that needs to be translated and click the tool in the lower left corner. 3. Click Review and Translate.

How to center the WPS Word table How to center the WPS Word table Mar 21, 2024 pm 02:21 PM

When using word in WPS, you often need to insert pictures, tables, etc., but if the inserted table is not centered, it will affect the beauty of the entire document. So how to set the centering of the WPS table? Today I will teach you how to make adjustments. The specific steps are as follows. Come and take a look! 1. The table in the picture is not in the middle of the page, which is not very beautiful. I want it to be centered. 2. First, right-click the mouse in the table (as shown in the picture). 3. Then click [Select All Tables] in the right-click menu (as shown by the red arrow in the figure). 4. After clicking, the table will be fully selected (as shown in the figure below). 5. At this time, click to open the [Start] tab of wps text (as shown by the red arrow in the figure). 6 o'clock

Introduction to the method of editing watermark with WPS Introduction to the method of editing watermark with WPS Mar 27, 2024 pm 02:06 PM

1. We use WPS to open a document. There is a watermark in it. It looks messy. How to remove it? Look down. 2. Find the Insert tab in the menu bar, select the header and footer icons under this tab, and click on them with the left mouse button. 3. At this time, the text on the page becomes gray and cannot be edited, but the watermark on the back of the text can be edited at this time. 4. Click on the watermark, you can see that this is a picture watermark, because there are several small squares around the picture, and the picture can be edited at this time. 5. Use the delete key on the keyboard to delete the picture, and you can see that the watermark is gone. 6. Double-click the mouse on the page to exit the header and footer editing mode. The text on the page returns to normal color and can be edited, but at this time the watermark on the page has disappeared. 7.

Why macros still cannot be enabled after wps installs vba Why macros still cannot be enabled after wps installs vba Mar 21, 2024 am 08:30 AM

wpsOffice is an office software suite independently developed by Kingsoft Software Co., Ltd., which can realize multiple functions such as text, forms, presentations, and PDF reading. It has the advantages of low memory usage, fast running speed, multiple cloud functions, powerful plug-in platform support, free massive online storage space and document templates. What the editor will introduce to you today is the "macro" function. In the past few days, friends have always asked me why I still can't enable macros after installing VBA. The "macro" function is still gray and cannot be opened, as shown below. What's going on? The editor will find out the reasons for you. There are three main reasons for this situation: 1. Does your wps support vba? Some versions do not support it. 2. Confirm that you have enabled macros and whether the operation

How to create a QR code using wps How to create a QR code using wps Mar 28, 2024 am 09:41 AM

1. Open the software and enter the wps text operation interface. 2. Find the insert option in this interface. 3. Click the Insert option and find the QR code option in its editing tool area. 4. Click the QR code option to pop up the QR code dialog box. 5. Select the text option on the left and enter our information in the text box. 6. On the right side, you can set the shape of the QR code and the color of the QR code.

How to set WPS value to automatically change color according to conditions_Steps to set WPS table value to automatically change color according to condition How to set WPS value to automatically change color according to conditions_Steps to set WPS table value to automatically change color according to condition Mar 27, 2024 pm 07:30 PM

1. Open the worksheet and find the [Start]-[Conditional Formatting] button. 2. Click Column Selection and select the column to which conditional formatting will be added. 3. Click the [Conditional Formatting] button to bring up the option menu. 4. Select [Highlight conditional rules]-[Between]. 5. Fill in the rules: 20, 24, dark green text with dark fill color. 6. After confirmation, the data in the selected column will be colored with corresponding numbers, text, and cell boxes according to the settings. 7. Conditional rules without conflicts can be added repeatedly, but for conflicting rules WPS will replace the previously established conditional rules with the last added rule. 8. Repeatedly add the cell columns after [Between] rules 20-24 and [Less than] 20. 9. If you need to change the rules, you can just clear the rules and then reset the rules.

Why can't videos on wps be played? Why can't videos on wps be played? Mar 20, 2024 am 11:22 AM

In our daily work and study, we often use videos to report and share with everyone the interesting videos we see, novel videos, or some video materials we shot casually. During the sharing process, the video data cannot be played. Why? The editor below will introduce to friends who are in front of the computer why the video on WPS cannot be played. I hope it can be helpful to everyone. Let's learn it together! 1. First, we open the PPT document in WPS, select the video material that cannot be played, right-click and select the "Delete" button. As shown in the picture; 2. Then click "Insert" in the menu bar, find "Video" in the toolbar, and click "Embed local video", as shown in the picture; 3. Re-import the video, and then click to play