


Introduction | Lan Se recently discovered that there are many operations in Excel that can be completed with one click, but some students are still using stupid methods. So I have the urge to summarize it again! ! |
1. Press the ctrl N key combination to create a new excel file with one click.
Are you still in File - New - Blank Workbook
2. Press Ctrl 1 (number 1) to quickly open the cell formatting box.
Are you still using right-click - Format Cells
3. Press CTRL A to quickly select the current continuous data area.
No matter how large the table is, you can select it in one second. Are you still dragging with the mouse?
4. Press CTRL 9 or 0 key combination to hide rows or columns with one click
Many students are looking for this shortcut key. Right-click operation is too troublesome
5. Press ctrl - (minus sign) to delete a line with one click (insert line: ctrl shift plus sign: )
This trick is very fast when deleting or inserting rows multiple times in a row!
Are you still in the right-click menu - Delete row
6. Press Ctrl p to open the "Print" interface with one click.
Are you still in File-Print....
7. Press Ctrl F1 to hide the ribbon with one click.
Are you still right-clicking - Collapse Ribbon
8. Press Ctrl Pgdn to quickly switch worksheets (Ctrl pgdn goes backward, Ctrl Pgup goes forward)
Are you still tagging one table after another?
9. Press Pgdn to turn pages with one click.
When scrolling down, keep turning the mouse wheel. Aren’t your fingers tired? Click PgDn to turn pages. Press Alt PgDn to page right. This is very convenient when the table has many columns.
10. Press ctrl alt A to take a screenshot with one click. (When QQ is opened)
When you need to save a table as an image format, are you still looking for screenshot software? In fact, when QQ is open, press Ctrl alt A to start taking screenshots. After intercepting, press ctrl alt S and a file saving window will pop up. Just save the image to the specified location.
Lanse said: Every time I share a shortcut key, many students will ask me why it cannot be used. There are 3 main reasons:
Conflicts with input method shortcut keys
The FN key is enabled. Try pressing FN in addition to the original key combination
You are using WPS form, some shortcut keys are not supported
The above is the detailed content of Know these 10 Excel shortcut keys and your work efficiency will instantly soar. For more information, please follow other related articles on the PHP Chinese website!

linux设备节点是应用程序和设备驱动程序沟通的一个桥梁;设备节点被创建在“/dev”,是连接内核与用户层的枢纽,相当于硬盘的inode一样的东西,记录了硬件设备的位置和信息。设备节点使用户可以与内核进行硬件的沟通,读写设备以及其他的操作。

区别:1、open是UNIX系统调用函数,而fopen是ANSIC标准中的C语言库函数;2、open的移植性没fopen好;3、fopen只能操纵普通正规文件,而open可以操作普通文件、网络套接字等;4、open无缓冲,fopen有缓冲。

端口映射又称端口转发,是指将外部主机的IP地址的端口映射到Intranet中的一台计算机,当用户访问外网IP的这个端口时,服务器自动将请求映射到对应局域网内部的机器上;可以通过使用动态或固定的公共网络IP路由ADSL宽带路由器来实现。

在linux中,eof是自定义终止符,是“END Of File”的缩写;因为是自定义的终止符,所以eof就不是固定的,可以随意的设置别名,linux中按“ctrl+d”就代表eof,eof一般会配合cat命令用于多行文本输出,指文件末尾。

在linux中,可以利用“rpm -qa pcre”命令判断pcre是否安装;rpm命令专门用于管理各项套件,使用该命令后,若结果中出现pcre的版本信息,则表示pcre已经安装,若没有出现版本信息,则表示没有安装pcre。

linux查询mac地址的方法:1、打开系统,在桌面中点击鼠标右键,选择“打开终端”;2、在终端中,执行“ifconfig”命令,查看输出结果,在输出信息第四行中紧跟“ether”单词后的字符串就是mac地址。

在linux中,rpc是远程过程调用的意思,是Reomote Procedure Call的缩写,特指一种隐藏了过程调用时实际通信细节的IPC方法;linux中通过RPC可以充分利用非共享内存的多处理器环境,提高系统资源的利用率。

手机远程linux工具有:1、JuiceSSH,是一款功能强大的安卓SSH客户端应用,可直接对linux服务进行管理;2、Termius,可以利用手机来连接Linux服务器;3、Termux,一个强大的远程终端工具;4、向日葵远程控制等等。


Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

ZendStudio 13.5.1 Mac
Powerful PHP integrated development environment

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.

Notepad++7.3.1
Easy-to-use and free code editor

VSCode Windows 64-bit Download
A free and powerful IDE editor launched by Microsoft

SAP NetWeaver Server Adapter for Eclipse
Integrate Eclipse with SAP NetWeaver application server.