search
HomeSoftware TutorialOffice SoftwareWhat are the commonly used shortcut keys for WPS tables?

php Editor Xigua introduces you to commonly used WPS table shortcut keys, which can greatly improve work efficiency. Ctrl C copy, Ctrl V paste, Ctrl X cut, Ctrl Z undo, Ctrl S save, Ctrl A select all, Ctrl F find, Ctrl H replace, Ctrl B bold, Ctrl I italic, Ctrl U underline, Ctrl 1 unit Grid format, Ctrl Shift L filter function, Ctrl Shift V paste option, Ctrl PageUp and Ctrl PageDown switch worksheets, etc. Mastering these shortcut keys will help you get twice the result with half the effort!

At work, everyone will use the table function in WPS software. There are many practical functions in the form. In order to improve work efficiency, we often use some shortcut keys. How much do you know about the shortcut keys of WPS tables? Let’s summarize the commonly used WPS table shortcut keys. The shortcut keys in the WPS table can help us quickly complete various operations, such as Ctrl C to copy, Ctrl V to paste, Ctrl Z to undo, etc. At the same time, there are also some shortcut keys for specific functions, such as Ctrl Home to jump to the first cell of the table, Ctrl End to jump to the last cell of the table, etc. In addition, there are some shortcut keys that can help us quickly format settings in the table and

What are the commonly used shortcut keys for WPS tables?

Edit cell shortcut keys

Move the cursor Move to the end of the cell content: F2

Type the same data into multiple cells: Ctrl Enter

Line break operation within the cell: Alt Enter

Enter Edit, re-edit the cell content: Back Space (backspace key)

Type the current date: Ctrl;

Type the current time: Ctrl Shift;

Position the cell shortcut Key

Move to the edge of the current data area: Ctrl Arrow key

Locate the beginning of the row in the pane where the active cell is located: Home

Move to the beginning of the worksheet :Ctrl+Home

Move to the last cell position of the worksheet, which is located in the bottom row of the rightmost column occupied by the data :Ctrl+End

Change the selection area shortcut key

Change the currently selected cell and cancel the original selection: Direction keys

Expand the current selection area to adjacent rows and columns: Shift direction

Expand the selected area to the active cell The last non-empty cell in the same column or row: Ctrl Shift Arrow keys

Expand the selected area to the beginning of the row: Shift Home

Expand the selected area to the worksheet Start: Ctrl Shift Home

Extend the selection to the last used cell on the worksheet (lower right corner): Ctrl Shift End

Select the entire worksheet: Ctrl A

Select an area: Mouse selection

Select multiple areas: Ctrl Mouse selection

Select the area from the active cell to the clicked cell: Shift mouse point Select

to move from left to right in the selected area. If cells in a single column are selected, move Tab

downwards from right to left in the selection. If cells in a single column are selected, move up Shift Tab

to move from top to bottom in the selection. If cells in a single column are selected, move downward. Enter

moves from bottom to top in the selected area. If a cell in a single column is selected, move up Shift Enter

Select the cell on the previous screen of the active cell: PageUp

Select the cell on the next screen of the active cell :PageDown

Select the area from the active cell to the corresponding cell on the previous screen: Shift PageUp

Select the area from the active cell to the corresponding cell on the next screen: Shift PageDown

Keys for entering, editing, formatting, and calculating data

Complete cell entry and select the next cell: Enter

Wrap lines in cells: Alt Enter

Fill the selected cell range with the current input: Ctrl Enter

Complete cell input and select the previous cell upward: Shift Enter

Complete cell input and select the next cell to the right: Tab

Complete cell input and select the previous cell to the left: Shift Tab

Cancel cell Cell input: Esc

Move one character up, down, left or right: Arrow keys

Move to the beginning of the line: Home

Create a name from the row and column markers: Ctrl Shift F3

Fill down: Ctrl D

Fill right: Ctrl R

Enter date: Ctrl; (semicolon)

Enter time: Ctrl Shift: (colon)

Display the drop-down list of values ​​in the current column of the list: Alt Down Arrow

Display the drop-down list of values ​​in the current column of the list: Alt Down Arrow

Undo the last operation: Ctrl Z

The above is the detailed content of What are the commonly used shortcut keys for WPS tables?. For more information, please follow other related articles on the PHP Chinese website!

Statement
This article is reproduced at:huke88. If there is any infringement, please contact admin@php.cn delete
windows7电脑分屏快捷键是什么windows7电脑分屏快捷键是什么Jul 09, 2023 pm 10:57 PM

许多客户想知道windows7电脑分屏快捷键是什么,用户们可以按下快捷键Win+P打开投射窗口,随后就能选择分屏的类型哦,能够选择复制还可以选择拓展,依照要求去选择,选择后就能设置屏幕的分辨率等等,所以我们的windows7电脑分屏快捷键便是Win+P哦。windows7电脑分屏快捷键介绍1、应用键盘上的组合快捷键“Win+P”,弹出投射窗口2、能够选择第二个屏幕是拓展还是复制,复制就是两个屏幕显示相同的内容,拓展是将第二个显示器做为第一个显示的增加3、这时候只要选择“复制”即可,设置好之后在桌

win11关机快捷键是什么win11关机快捷键是什么Dec 23, 2023 am 08:28 AM

如果我们想要快速关机,不想要使用传统的电源按钮来关机,就可以使用win11关机快捷键,但很少有人知道win11关机快捷键是什么,其实很多种方法都能关机。win11关机快捷键是什么:一、alt+f41、首先,来到“桌面”,然后按下快捷键“alt+f4”2、按下后就会进入图示界面,点击“确定”就能直接关机了。二、win+x1、如果不想回到桌面上,那么直接按下“win+x”快捷键。2、然后将鼠标放在“关机或注销”就可以“关机”了。

笔记本的任务管理器快捷功能笔记本的任务管理器快捷功能Dec 25, 2023 pm 07:58 PM

很多小伙伴在使用笔记本电脑的时候遇见某个软件卡住。电脑动不了的情况,这个时候就需要调出任务管理器来结束这个进程,那么该如何呼出任务管理器呢?最简单的莫过于Ctrl+Shift+Esc直接呼出,还有其他的方法,下面一起来看看吧。任务管理器笔记本快捷键的使用方式任务管理器的快捷键有两种方式:1.组合键Ctrl+Shift+ESC同时按住这三个键就能直接调出任务管理器。适用于XP/win7/Win8/Win10。2.组合键Ctrl+Alt+Delete在xp系统中同时按住这三个键也能调出任务管理器,在

Linux系统中的常用命令和快捷方式Linux系统中的常用命令和快捷方式Jun 18, 2023 am 08:46 AM

随着Linux操作系统的广泛应用,越来越多的人开始需要学习和了解Linux系统中的基本命令和快捷方式。在本文中,我们将介绍一些常用的Linux命令和快捷方式,帮助初学者了解Linux系统,提高工作效率。常用命令1.1ls命令ls命令是Linux中最常用的命令之一。它主要用于列出当前目录下的文件和子目录。常用的选项有:-l:以长格式显示文件信息,包括文件类型

alt+a是什么快捷键alt+a是什么快捷键Mar 09, 2023 pm 04:11 PM

alt+a是微信电脑版的截图快捷键,其查看该快捷键的方法是:1、打开电脑版微信;2、进入软件设置页面,点击“快捷按键”;3、找到“截取屏幕”选项即可查看或修改截图快捷键。

alt+a是什么的快捷键alt+a是什么的快捷键Jun 30, 2023 pm 12:00 PM

alt+a是用于访问和触发不同的功能和选项的快捷键,不同情景下的常见功能:1、在浏览器中的使用,用于访问和使用浏览器的菜单栏选项;2、在Windows操作系统中的使用,通常出现在对话框或窗口的按钮上,用于触发该按钮所代表的命令或操作;3、在文本编辑和处理软件中的使用,经常用作文本操作的快捷键;4、在应用程序中的使用,通常会被用于访问菜单栏选项、执行常用命令或启动特定的操作。

Win10锁屏快捷键有哪些Win10锁屏快捷键有哪些Dec 23, 2023 pm 01:07 PM

在使用win10系统的时候,我们如果有事离开还不想关机的话,就只有让电脑进入待机状态睡眠并锁屏了,那么这个锁屏的快捷键是什么呢,快来看看详细的教程吧~win10待机快捷键锁屏是什么:1、键盘上的+键。2、在键盘上同时按下这两个按键,就能够直接让电脑进入锁屏界面待机。3、重新进行使用,需要登录你的账户密码。相关教程:win10待机密码怎么设置>>>win10待机怎么设置不断网>>>

热键是什么键热键是什么键Feb 22, 2023 pm 12:01 PM

热键就是快捷键,是指通过某些特定的按键、按键顺序或按键组合来完成一个操作,就是键盘上某几个特殊键组合起来完成一项特定任务;利用热键可以代替鼠标做一些工作,可以利用键盘快捷键打开、关闭和导航“开始”菜单、桌面、菜单、对话框以及网页。

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 Tools

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),

MantisBT

MantisBT

Mantis is an easy-to-deploy web-based defect tracking tool designed to aid in product defect tracking. It requires PHP, MySQL and a web server. Check out our demo and hosting services.

SAP NetWeaver Server Adapter for Eclipse

SAP NetWeaver Server Adapter for Eclipse

Integrate Eclipse with SAP NetWeaver application server.

Atom editor mac version download

Atom editor mac version download

The most popular open source editor

MinGW - Minimalist GNU for Windows

MinGW - Minimalist GNU for Windows

This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.