search
HomeTopicswordSharing practical Word skills: 'Batch filling' of tables is so efficient!

In the previous article "Use "Find and Replace" to quickly adjust the document format! 》In this article, we learned about two ways to quickly adjust the document format using "Find and Replace". Today we will continue to share practical Word skills, talk about table filling, and let you experience the efficiency and wisdom of "batch filling" of Word tables!

Sharing practical Word skills: 'Batch filling' of tables is so efficient!

We all know that batch filling of data in Excel spreadsheets is very convenient. You can quickly fill in text and data in batches through the manual fill handle. This is not possible in Word tables.

Although Word cannot directly use the fill handle to quickly fill data, it also provides us with the fill function, allowing us to also achieve batch filling in Word tables.

1. Batch filling of serial numbers

At work, we often have to fill in various serial numbers in Word tables. The small serial number has stumped many heroes. Here, the editor will share with you two methods for filling serial numbers in batches to solve the problem of filling serial numbers in batches.

Method 1: Simple serial number filling

If you want to fill the cells in the table with serial numbers 1, 2, 3..., you can Do this:

Select the cells that need to be numbered and click the [Start]-[Paragraph]-[Numbering] button.

Sharing practical Word skills: 'Batch filling' of tables is so efficient!

Method 2: Filling in complex serial numbers

If you want to achieve 10011, 10012, 10013 for the cells in the table... ....To fill in the serial numbers of this type of complex values, you can do this:

Select the cell that needs to be numbered, click the drop-down triangle button next to [Start]-[Paragraph]-[Number], and in the pop-up Select the "Define New Numbering Format" command from the drop-down menu, and then in the "Define New Numbering Format" dialog box that opens, modify the "Numbering Format" to 10011, then delete the "." decimal point, and click the "OK" button. That is, the serial number is filled.

Sharing practical Word skills: 'Batch filling' of tables is so efficient!

# Tips: When modifying the numbering format, be careful not to delete the selected "1".

2. Data batch filling

When we calculate the total score for the first student in the total score column in the table Finally, how to quickly calculate the total scores of other students below? At this time, we can use the [F9] key to fill in data in batches to quickly calculate the scores of other students.

The operation method is:

(1) First click the [Layout]-[Data]-[Formula] button and use the summation formula in the opened dialog box Calculate the total score of the first student.

(2) Then select the total score data of the first student, right-click to perform the copy operation, then select all the cells that need to be filled below, and perform the paste operation.

(3) At this time, you can see that all total scores are the same. Press the [F9] key to update the data, which means batch filling of data is achieved.

Sharing practical Word skills: 'Batch filling' of tables is so efficient!

Recommended tutorial: "Word Tutorial"

The above is the detailed content of Sharing practical Word skills: 'Batch filling' of tables is so efficient!. For more information, please follow other related articles on the PHP Chinese website!

Statement
This article is reproduced at:部落窝教育. If there is any infringement, please contact admin@php.cn delete
实用Word技巧分享:表格自定义样式,美化表格!实用Word技巧分享:表格自定义样式,美化表格!Jul 20, 2022 am 10:25 AM

在之前的文章《实用Word技巧分享:详解怎么更改图片颜色和形状》中,我们了解了更改图片颜色和图片形状的方法。而今天我们来聊一聊word表格,讲解美化表格--自定义表格样式的方法,快来看看吧!

Word与Excel联动:表格借用Word进行分栏打印!Word与Excel联动:表格借用Word进行分栏打印!May 07, 2022 am 10:28 AM

在之前的文章《实用Word技巧分享:聊聊你没用过的“行号”功能》中,我们了解了Word中你肯定没用过的"行号”功能。今天继续实用Word技巧分享,看看Excel表格怎么借用Word进行分栏打印,快来收藏使用吧!

实用Word技巧分享:使页面自动滚动实用Word技巧分享:使页面自动滚动May 02, 2022 am 10:00 AM

在之前的文章《实用Word技巧分享:隐藏图片,提升文档浏览和编辑效率!》中,我们学习了隐藏图片的技巧,可提升文档浏览和编辑效率。下面本篇文章再给大家分享一个实用Word技巧,看看怎么让页面自动滚动,快来收藏使用吧!

实用Word技巧分享:脚注和尾注的设置、转换和删除实用Word技巧分享:脚注和尾注的设置、转换和删除Jul 21, 2022 am 10:29 AM

在之前的文章《实用Word技巧分享:表格自定义样式,美化表格!》中,我们了解了自定义表格样式的方法。而今天我们来聊一聊word脚注和尾注,介绍一下脚注和尾注的设置使用方法,快来看看吧!

实用Word技巧分享:设置字符间距、行距和段落间距实用Word技巧分享:设置字符间距、行距和段落间距Apr 26, 2022 am 10:25 AM

在之前的文章《实用Word技巧分享:设置页码的终极方法!》中,我们学习了Word页码的设置方法。而今天我们来一起聊聊Word文本间距设置的几个技巧,快来收藏使用吧!

实用Word技巧分享:【F4】键快速统一图片大小实用Word技巧分享:【F4】键快速统一图片大小Jun 07, 2022 am 10:27 AM

在之前的文章《实用Word技巧分享:怎么跨文档快速复制样式》中,我们了解了在文档间快速复制样式的方法。今天我们聊聊Word快捷键,聊聊【F4】键快速统一图片大小,快来看看吧!

word打一个字后面就少一个字怎么回事word打一个字后面就少一个字怎么回事Jun 15, 2019 pm 03:07 PM

原因:输入模式有问题,进入了插入模式。解决方法:在键盘中,找到“Insert”键,敲击一下关闭插入模式,恢复正常输入模式即可。

实用Word技巧分享:如何快速输入货币、版权符号!实用Word技巧分享:如何快速输入货币、版权符号!May 20, 2022 am 09:42 AM

在之前的文章《实用Word技巧分享:轻松输入省略号的几种方法》中,我们了解了轻松输入省略号的3种方法。今天继续实用Word技巧分享,聊聊输入货币、版权符号的最快技巧,赶紧学起来!

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

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)
3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Best Graphic Settings
3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. How to Fix Audio if You Can't Hear Anyone
3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

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.

SAP NetWeaver Server Adapter for Eclipse

SAP NetWeaver Server Adapter for Eclipse

Integrate Eclipse with SAP NetWeaver application server.

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

DVWA

DVWA

Damn Vulnerable Web App (DVWA) is a PHP/MySQL web application that is very vulnerable. Its main goals are to be an aid for security professionals to test their skills and tools in a legal environment, to help web developers better understand the process of securing web applications, and to help teachers/students teach/learn in a classroom environment Web application security. The goal of DVWA is to practice some of the most common web vulnerabilities through a simple and straightforward interface, with varying degrees of difficulty. Please note that this software

Dreamweaver Mac version

Dreamweaver Mac version

Visual web development tools