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

Today, Xiao Wang shared a very useful shortcut key "Ctrl + G" with everyone, which has a variety of ways to use it!

01. Select the specified cell area and use the shortcut key "Ctrl + G" to enter the selected cell in the "Reference Position". Confirm that the cell can be selected.

02, batch fill blank cells If we need to fill all blank cells in the data with the same content, you can first select the table area, and then use the shortcut key "Ctrl + G", enter the "positioning conditions"-"empty value", you can select all blank cells, and then enter the content, press "Ctrl + Enter" to batch fill.

03. Delete redundant blank rows There are many useless blank rows in the table. How to delete these blank rows quickly without affecting other data? After selecting the table,"Ctrl + G","Positioning Condition"-"Empty Value", and then you can delete all blank rows.

04. Select all cells using formula To select cells using formula in the table, we can use the shortcut key "Ctrl + G" to enter the "positioning condition", check the "formula", OK, at this time, all cells using formula have been selected.

Ctrl + G shortcut key can also compare two columns of data to find out the differences. Select two columns of content, then use Ctrl + G shortcut key,"positioning condition"-"row content difference cell".

06. Do not copy hidden cells Sometimes, we hide some rows or columns. When copying, we do not want to copy the hidden cell contents. This can be done easily by Ctrl + G.

07. Fill merged cells The cells are merged and centered. How to cancel and fill them? First cancel the merge and center, then Ctrl + G, enter the "positioning condition", select "null value", then enter "=" in the edit bar, select the previous cell, press "Ctrl + Enter" to fill.

08. Batch Compute Subtotal When using Excel, we often operate formulas to calculate the result of subtotal. However, learning to use Ctrl + G allows us to quickly and easily perform subtotals.

This article comes from Weixin Official Accounts: Word Alliance (ID: Wordlm123), author: Yi Xuelong

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.