14 Excel Tips to Help You Work Faster

1. Numbered

–Instead of having to manually number numbers from 1- n numbers take you a lot of time, numbering with tables created with a number of columns and numbers is very simple, you just need:

+ Enter the number 1 in the first row

+ Enter the number 2 in row 2

? Select the numbered area and left-click the position of the '+' number will automatically fill the table.

- Or you:

+ Enter the number 1 in the first row

+ Then place the mouse cursor at the end of cell soos1 and when the '+' appears, drag down, there will appear a small grid table Auto Fill Options - select Fill Series

- In the absence of a board, the steps are as above, but instead of double-clicking on the '+' symbol, we hold and hold the left mouse button and drag it to an arbitrary position.

2. Select all data

- In addition to the familiar Ctrl + A key , you can perform a mouse click this location

3. Automatically adjusts columns and rows to fit snugly

- Right on the Home bar you select Format - select Auto Fix Row and Auto Fix Column to automatically align between text and cells.

4. Automatically adjust the text to fit the cell, jump the text to fit the cell

With the trick to using Wrap Text, the text that doesn't fit in the cell automatically jumps down

5. Insert the Letter 'D' as the Unit 'Dong' to the Right of the Amount

- Select the required columns

Please adjust according to the symbol characters for money

6. Automatically capitalize the first character

- First, you create a column named 'Hide' for example, the purpose of creating this column is to enter data and hide it. You enter normally without the first capital letter

- Next, you add a Name column and use the Proper function to capitalize the first character, the results as shown below

- And finally, select the 'Hide' column and right click and select 'Hide' to hide this column, that's it. Now only the TT column, Full name, Gender and year of birth are left.

7. Excel page numbering

You will have many templates for page numbering in Excel with the simple steps below.

8. Draw arbitrary lines

- Choose the table to be framed

Implement grid options

9. Enter your phone number, = sign, + sign, - sign in the board

- Use the feature to convert the format to text format by entering the 'before entering information 0

Use the format conversion feature to enter text format by entering the 'before entering 0 information

10. Pair string, or data

Use '&' to make concatenation

Use '&' to make concatenation

If you may need to create spaces, put spaces within quotes.

Ex: & '' &

11. Hang title always on top (top)

- Using this trick makes it easy to track all information beyond the page to match the title

Result: The title is always at the top when you scroll down

12. Print according to options

- Print only the selected location (highlighted)

+ Select the text you may need to print

Go to File / print and choose Print Selection

+ Go to File / print and select Print Selection or press Ctrl + P

13. Edit the data in the cell

- Use the F2 key to edit data directly in the cell

14. Delete the available data in the table

Some of you use the Backspace key, but this key only deletes the letter of a cell, needs to delete all the data you want in the table, use the 'DELETE' key or right-click and select 'Clear Content'.

Using the 'DELETE' key deletes existing data in the table

Social Share and Social Share