Excel2016 three tips for improving work efficiency

Divine Skill 1: Quick Format Brush

In an Excel table, there are times when multiple cells require the same format, one setting, and the efficiency is too low, so you can use the Format Painter. But you know what? Double-click the Format Painter to quickly "brush" the same format to multiple cells!

Divine Skill 2: Quick Select discontinuous cell

It's easy to select contiguous cells, but what if you want to select multiple cells and they don't connect? The most convenient way is to press the SHIFT+F8 key to activate the "Add Selection" mode, you can see the status bar appears in the "Ready to add to the selection" words, at this time do not have to press the CTRL key, You can also click on a continuous selection.

Divine Skill 3: Quickly adjust column width

The default column width sometimes does not display the entire contents of some cells, one to adjust the width of the column is a waste of time, in fact, you can do so: the mouse to move to the top of the column to the right, double click on the OK! As shown in the figure, when the column width is not enough, the display is chaotic characters, at this point, move one of the following width to achieve the image left to right changes, This tip allows us to do this without dragging the mouse and double-clicking on the right side of the column.