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

The original title: "Super useful Ctrl+G shortcut key, can you use it?" "

Today, Mr. Wang shares a very useful shortcut "Ctrl + G" to everyone. It has many ways to use it!

1, select the specified range of cells to use the shortcut key "Ctrl + G", in the "reference location", enter the cell you want to select, make sure you can select the cell.

2, batch fill blank cells if we need to fill all the blank cells in the data with the same content, we can first select the table area, and then use the shortcut key "Ctrl + G" to enter the "positioning condition"-"null value". Then you can select all blank cells and press "Ctrl + enter" to fill them in batches.

3. Delete extra blank rows. There are many useless blank rows in the table. How to delete these blank rows quickly without affecting other data? Select the table "Ctrl + G", "positioning condition"-"null value", and then delete all blank lines.

4, select all the cells using the formula want to select the table using the formula of the cell, we can use the shortcut key "Ctrl + G", enter the "positioning conditions", check the "formula", to determine, at this time, all the cells using the formula have been selected.

5. Compare the two columns to find out the Ctrl + G shortcut keys with different contents, and you can also compare the two columns of data to find out the differences. Select two columns, and then use the Ctrl + G shortcut key, "location condition"-"Row content difference cells".

Do not copy hidden cells sometimes, we hide some rows or columns, copy, do not want to copy the contents of hidden cells. It can be easily done through "Ctrl + G".

7, fill merge cells are merged in the center, how to cancel and fill it? First cancel the merge and then center, then Ctrl + G, enter the "positioning condition", select "null value", then enter "=" in the edit bar, select the previous cell, and press "Ctrl + enter" to fill it.

8. Batch calculation subtotal when using Excel, we often calculate the formula to calculate the result of the subtotal. However, learn to use "Ctrl + G" we can easily and quickly complete the subtotal calculation.

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.