Shulou(Shulou.com)11/24 Report--

The original title: "this shortcut key in Excel is so strong that it can be used in so many ways!" "

Today, I would like to share with you a very easy to use shortcut key "F4", the main function is to "repeat the previous step", a button can be used in many ways, let's take a look at its powerful effect!

1. Copy format F4 can be used as a format brush. After using the color once, we just have to give it to F4.

2. Merge cells Excel does not have the shortcut key to merge cells. If you need to merge cells in many places, you might as well try the "F4" button.

First merge once, the following we press "F4" on the line, convenient and fast!

3. Insert rows and columns if you have more than one place to insert rows or columns, F4 is the best way!

Delete rows, columns if you have multiple useless blank columns or rows that need to be deleted, you can try F4.

5. Delete worksheets similarly, "F4" can also help us delete worksheets quickly.

6. How to adjust row height and column width in other worksheets to the same height or column width? Set it once, and repeat the previous step for the remaining F4.

7, isometric replication Excel, we can also use the F4 button to quickly equidistant replication.

8. Switch the reference method when using the formula, we usually use F4 to switch references to the formula, absolute reference and relative reference.

This article comes from the official account of Wechat: Word Alliance (ID:Wordlm123), author: Wang Wangqi

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.