What are the advanced tips of Excel to ensure data security?

As shown in the figure, we need to complete the protection of the "hai lind" cell in our tutorial. Right-click on any cell and select Format Cells. <

In the pop-up dialog box, select the [Protection] tab, and we see that the default "Lock" is checked. Cancel your exit.

After returning to the worksheet, use Ctrl+A to select all cells, then right-click and select Format Cells, switch to the Protection tab, cancel Lock, and return OK. <>

Cancel the Select All statusThe cells to be protected are selected, right-click and select Format Cells, switch to the Protection tab, and select Lock. <>

Then click [Review] - [Protect Worksheet] in turn, and the "Protect Worksheet" dialog box will pop up, and you can choose which operations users are allowed to do in the list box of Allow all users of this worksheet, and generally leave the default settings to <>

Here we can also "set a password to unprotect the worksheet". Just type the password you set in the "Password to use when unprotecting worksheet" text box. <>

Clicking OK will ask us to confirm your password. (set to 123456) <>

At this time, when we try to perform the "Protect" operation on the cell, the system will prompt as follows. <>

If you want to unlock it, switch to the Review tab, click the Revoke Sheet Protection button, and <>

You will be asked to enter the unlock password dialog box, enter the correct password, and you can unlock it. <>

Quickly select all worksheets, right-click the worksheet tab below the work window, and select the "Select All Worksheets" command in the pop-up menu. Move quickly Copy a cell, select the cell first, then move the mouse pointer to the cell border, press the left mouse button and drag to a new position, then release the key to move. To duplicate a cell, press Ctrl before releasing the mouse.

Quickly move a row or column, select the row or column, move the mouse over the cell border, hold down the shift key and press the left mouse button to drag the entire row or column to move.

There are many advanced tools in Excel that can also greatly improve efficiency and aesthetics. The first is diagramming tools, as humans, as visual animals, increasingly need to utilize diagrams to understand and express. In the article, in order to express the year-on-year increase in the willingness to consume cocktails, it is necessary to use visualization to express the data after extraction.

Using the default configuration of the system to draw the chart, is it a strong square dance style? In order to achieve the style of the financial magazine on the right side of the figure below, you have to optimize the parameters one by one: optimize the chart type, configure the title, annotation and data source, add trend lines, optimize the font, etc.

In order to make the chart look better, all kinds of tricks and parameters have been used once, and for the chart tool of Excel, it is natural to master.

Shift+F8 can activate the "Add Selection" mode, and the words "Add to Selection" will be displayed in the status bar at the bottom of the workbook, and then click on the discontinuous cell or cell range to select it.

Shortcut keys, in fact, shortcuts do not need to be deliberately memorized, as long as you repeatedly encounter some slightly complex operations in the practice of excel (especially those operations that require the use of a mouse), you will check whether there are shortcuts, and then continue to use them to remember naturally. Here are some of the most commonly used and inevitably encountered. Another way to force yourself to memorize shortcuts is to unplug the mouse.

Various states and functions of the mouse, the functions corresponding to different mouse states and actions, master this table, you will be much more handy when operating excel. To quickly switch worksheets, to switch between multiple workbooks under multiple windows, right-click the two arrows in the lower left corner of the worksheet to view all the worksheet lists, in this list, you can quickly select any worksheet.

As a "repeat" key, the F4 key can repeat the previous operation, and for a large number of repetitive tasks, being good at using the F4 key can greatly improve work efficiency.