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

Today, I would like to share with my friends some practical Excel recipes to help you improve your work efficiency.

1. How can all data be adjusted upwards? For example, here I need to give all my employees a 500 raise. First enter a 500 in the cell, then copy, and then select all the data cells, "right"-"paste"-"add".

2, picture automatic alignment grid lines every time you want to drag the picture into the cell is very troublesome, here to teach you a small folk square, press and hold the "Alt" key is not loose, and then drag the edge of the picture, you can automatically absorb to the cell border.

3. How to quickly clear the newline characters in the Excel table by clearing all line breaks in batch? Use the shortcut key "Ctrl + H" to open "find and replace", use the shortcut key "Ctrl + J" in "find what", and click "replace all" to clear all line breaks.

4. Mini Chart We often generate charts in Excel to show the data. And the ordinary chart is too large, at this time we can use the Excel mini chart, not only the effect is good, but also will not take up too much space.

5, Clipboard merge data merges multi-cell data into one cell, without using functions, you can easily merge using the clipboard.

6. Copy the entire worksheet style if you need to copy the style to other worksheets, we can use the format brush to help us finish it quickly.

7, folding data is more convenient, too much data, dazzled? Try folding the data.

8. How to make the slash meter head? Here we teach you to use superscript and subscript to make slash meter head.

9. How to paste data to multiple worksheets at a time to copy the contents of the table to multiple worksheets? We can press the "Ctrl" key, then click with the left mouse button and select other worksheets, then select the data area that needs to be copied and pasted, and enter "start"-"fill"-"to the same group worksheet".

10. Text formula calculation if the data that needs to be calculated is in a cell, how should we calculate it? Enter the "formula"-"definition name"-"definition name", enter anything in the "name", here I enter "calculation", enter "= Evaluate (Sheet1calculation A1)" in the "reference location", and then go back to the B1 cell and enter "= calculation" drop-down.

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.