For newcomers to the workplace, mastering the skills of using office software can make us get twice the result with half the effort, and next, I will share with you some practical tips for Excel, so that everyone can be more handy in their work.
Quickly generate drop-down menus
Do you often need to set a drop-down list for certain cells in Excel so that users can only select the fixed option?
Just select the cell you want to set the drop-down menu to, and then press the "Alt+↓ key", and Excel will pop up a simple dialog box for you to easily set the content of the drop-down menu.
Convert images to Excel
Sometimes we need to extract the Excel sheet in the picture, many friends don't know how to extract, the following will share with you a practical tool - fast OCR text recognition software.
Quick OCR text recognition software is a computer recognition tool specially used to recognize all kinds of text content. In the recognition of pictures, files and other content, the recognition rate is accurate, it supports one-click quick recognition, and the text content in pictures can be recognized in batches, which is very convenient to use as a whole.
Baidu search fast OCR text recognition software can be downloaded~
You only need to open the homepage of the software, select the "Image to Excel" function, upload the pictures that need to be processed, set the export format and export directory, and click "One-click recognition" to complete.
Quickly copy cells
In the process of using Excel, we often need to copy the contents of one cell to other non-contiguous cells, and the traditional copy-paste method may be a little complicated when working with multiple cells.
At this time, we can use the shortcut key combination of "Ctrl+D" to quickly copy the contents of the top cell to other selected discontinuous cells with one click.
Keep two decimal places
Select the data area, press "Ctrl+1" to open the Format Cells window, then under the number option, select "Value", set the number of decimal places to "2", and click with the mouse to confirm.
Well, that's all for the Excel tips shared today, remember to like and share after reading it~