Basic operations of Excel office software (beginner to excel office software)

In the workplace, we come into contact with the Excel office software every day. Although we know some of the more basic operations in Excel, there are still some Excel skills that can help us improve work efficiency that we still need to learn more about. !

As a sharer, I would like to share with you some skills that I personally think are often used in the workplace. I hope it can help everyone!

1. Automatically add Excel border lines

In fact, we can automatically set the border line in the Excel table, which means that when we enter content in Excel, the border is automatically set. !

Setting steps:

Select the area to be set-click Conditional Formatting-New Rule-Rule Type Select the last cell that uses a formula to confirm the format to be set-Enter the formula: = A1

2. Delete borders with one click

Now that we have added borders, let’s talk about how to delete borders with one click? In fact, adding borders is troublesome, but deleting borders is very simple. You only need a set of shortcut keys to do it for you!

Setting steps:

Select the table border content with one click and press CtrlShift-(minus sign) on the keyboard in sequence to delete all borders in the table with one click!

4. >3000000 appears purple

How can we quickly distinguish table data in Excel? In fact, it is still set in conditional formatting. You only need to create a new rule to complete!

Setting steps:

Click Conditional Formatting - New Rule - Click Use Formula to confirm the cell to be formatted - Enter the formula: =$E2

5 , Summarize merged cell data

How can you summarize the data in merged cells in Excel? General settings are impossible to achieve, so how can you help us? In fact, it’s OK to directly quote the functions in Excel!

Setting steps:

Input function: =SUM(C2:C11)-SUM(D3:D11), the coordinates in front of the function are the corresponding summary data, and the coordinates behind are your summary After typing in the displayed empty cell, just hold down the shortcut key CtrlEnter!