:The magic F4 in WPS forms-Table skills免费ppt模版下载-道格办公

The magic F4 in WPS forms

  • Picture and text skills


There is a magical F4 key in Excel. The wonderful thing about it is that it can repeat the previous step.


图文对齐图.png


■For example, to merge cells, first select two cells and click Merge Cells. Then if you need to merge, just select them and press the F4 key.


图1.gif 

■Similarly, you can also add rows and columns repeatedly.


图2.gif


■Delete rows and columns.


图3.gif 


■To copy the font format, just follow the normal steps in the first step, and then press the F4 key for subsequent operations~


图4.gif 


■In addition, F4 can also quickly change the reference mode of cell addresses.

Press F4 in the function reference area to apply absolute references. You no longer need to enter the $ symbols for absolute references one by one.


图5.gif 


Have you learned this skill?



Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/WPS-biao-ge-zhong-shen-qi-de-F4.html

Like (810)
Reward 支付宝扫一扫 支付宝扫一扫
single-end

Related Suggestion