search
HomeSoftware TutorialOffice SoftwareThe operation process of setting the top title row of wps2019 table

php Xiaobian Yuzai will introduce to you the operation process of setting the top title row of the WPS 2019 table. After opening the WPS table, first select the table area to be set, then click the "Data" option in the menu bar, then select the "Freeze Panes" function, and click "Upper Row" to set the top title row. After this setting, the top title row will always be displayed at the top of the table, making it easier to view and edit data and improve work efficiency.

1. Open wps2019, create a new blank document, select the [Insert] button on the menu bar, and then click [Table] to insert an 8*4 table (as shown below).

The operation process of setting the top title row of wps2019 table

2. Enter some text in the first row of the table and set the font and font size.

The operation process of setting the top title row of wps2019 tableThe operation process of setting the top title row of wps2019 table

#3. Then enter the table content and process the table beautifully. At this time, the table displays the content of 2 pages. The first page has a title, and the second page has a title. The page displays the data directly.

The operation process of setting the top title row of wps2019 table

4. First, select the first row of the first page, right-click, and select [Table Properties] from the pop-up options (as shown below).

The operation process of setting the top title row of wps2019 table

5. In the pop-up dialog box, select [Row], then check the option [Repeat as a title at the top of each page], and click [OK].

The operation process of setting the top title row of wps2019 table

6. At this time, the title is displayed on the second page of the document.

The operation process of setting the top title row of wps2019 table

2. Set the top title in the table

1. Create a new blank table and enter some content.

The operation process of setting the top title row of wps2019 table

2. Click the [Print Preview] icon in the upper left corner of the menu bar to preview first. The second page will be displayed directly as data without displaying the title bar.

The operation process of setting the top title row of wps2019 tableThe operation process of setting the top title row of wps2019 table

3. First close the preview interface, return to the form, click [Page Layout] on the menu bar, and select [Print Title] (as shown below).

The operation process of setting the top title row of wps2019 table

4. In the pop-up dialog box, select [Worksheet], then select Print Title, the icon on the right side of the top title row.

The operation process of setting the top title row of wps2019 table

5. Enter [$1:$1] in the input box, and then click the icon on the right.

The operation process of setting the top title row of wps2019 table

6. Return to the page setup dialog box, click the OK button

The operation process of setting the top title row of wps2019 table

7. Continue to click the [Print Preview] icon, now the second page The title will be displayed.

The operation process of setting the top title row of wps2019 table

The above is the detailed content of The operation process of setting the top title row of wps2019 table. For more information, please follow other related articles on the PHP Chinese website!

Statement
This article is reproduced at:zol. If there is any infringement, please contact admin@php.cn delete
Excel WEEKNUM function – convert week number to date and vice versaExcel WEEKNUM function – convert week number to date and vice versaMay 09, 2025 am 11:11 AM

Excel's WEEKNUM function: Your guide to week number calculations While Excel offers numerous functions for dates, the WEEKNUM function stands alone for week number calculations. This tutorial explores its syntax, arguments, and practical applications

Excel MONTH function - month name from date, last day of month, etc.Excel MONTH function - month name from date, last day of month, etc.May 09, 2025 am 10:59 AM

This tutorial delves into the intricacies of Excel's MONTH and EOMONTH functions. Through numerous formula examples, you'll learn to extract month information from dates, determine the first and last days of any month, convert between month names an

WEEKDAY formula in Excel to get day of week, weekends and workdaysWEEKDAY formula in Excel to get day of week, weekends and workdaysMay 09, 2025 am 10:25 AM

If you are looking for an Excel function to get day of week from date, you've landed on the right page. This tutorial will teach you how to use the WEEKDAY formula in Excel to convert a date to a weekday name, filter, highlight and count

Convert date to text in Excel - TEXT function and no-formula waysConvert date to text in Excel - TEXT function and no-formula waysMay 09, 2025 am 10:11 AM

This article explores several methods for converting Excel dates into text strings, offering both formula-based and non-formula solutions. Traditionally, we start with a formula solution and then explore a couple of non-formula alternatives. Using

Excel: convert text to date and number to dateExcel: convert text to date and number to dateMay 09, 2025 am 09:36 AM

This tutorial demonstrates various Excel techniques for converting text and numbers into dates, including both formula-based and non-formula methods. You'll learn to efficiently transform text strings into usable date formats. Often, dates imported

How to add and subtract dates in ExcelHow to add and subtract dates in ExcelMay 08, 2025 am 11:36 AM

In this tutorial, you will find a variety of useful formulas to add and subtract dates in Excel, such as subtracting two dates, adding days, weeks, months and years to a date, and more. If you have been following our tutorials to working

Excel WORKDAY and NETWORKDAYS functions to calculate working daysExcel WORKDAY and NETWORKDAYS functions to calculate working daysMay 08, 2025 am 10:49 AM

This tutorial demonstrates how to use Excel's WORKDAY, WORKDAY.INTL, NETWORKDAYS, and NETWORKDAYS.INTL functions to efficiently calculate weekdays, considering custom weekend settings and holidays. Microsoft Excel offers specialized functions for wor

Excel DATEDIF function to get difference between two datesExcel DATEDIF function to get difference between two datesMay 08, 2025 am 10:45 AM

This tutorial provides a concise explanation of Excel's DATEDIF function and offers formula examples for calculating date differences in days, weeks, months, or years. We've previously covered date and time manipulation in Excel, including formattin

See all articles

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

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Safe Exam Browser

Safe Exam Browser

Safe Exam Browser is a secure browser environment for taking online exams securely. This software turns any computer into a secure workstation. It controls access to any utility and prevents students from using unauthorized resources.

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

mPDF

mPDF

mPDF is a PHP library that can generate PDF files from UTF-8 encoded HTML. The original author, Ian Back, wrote mPDF to output PDF files "on the fly" from his website and handle different languages. It is slower than original scripts like HTML2FPDF and produces larger files when using Unicode fonts, but supports CSS styles etc. and has a lot of enhancements. Supports almost all languages, including RTL (Arabic and Hebrew) and CJK (Chinese, Japanese and Korean). Supports nested block-level elements (such as P, DIV),

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

WebStorm Mac version

WebStorm Mac version

Useful JavaScript development tools