14 Excel tips to help you work faster

Accountants have a lot of work to do and to save, shorten their working time, fast operation is very important. With the following 14 excel tips will help the handling of work on excel of accounting people is much 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

14 Excel tips to help you work faster Picture 1

=> Select the numbered area and left-click on 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

14 Excel tips to help you work faster Picture 2

- 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 on this location

14 Excel tips to help you work faster Picture 3

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.

14 Excel tips to help you work faster Picture 4

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

14 Excel tips to help you work faster Picture 5

5.Insert the letter 'd' as the unit 'dong' to the right of the amount

- Select the required columns

14 Excel tips to help you work faster Picture 6

Please adjust according to the symbol characters for money

14 Excel tips to help you work faster Picture 7

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

14 Excel tips to help you work faster Picture 8

- 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.

14 Excel tips to help you work faster Picture 9

7. Excel page numbering

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

14 Excel tips to help you work faster Picture 10

8. Draw arbitrary lines

- Choose the table to be framed

14 Excel tips to help you work faster Picture 11

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

14 Excel tips to help you work faster Picture 12

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

14 Excel tips to help you work faster Picture 13

Use '&' to make concatenation

If you want 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

14 Excel tips to help you work faster Picture 14

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

14 Excel tips to help you work faster Picture 15

12. Print according to options

- Print only the selected location (highlighted)

+ Select the text you want to print

14 Excel tips to help you work faster Picture 16

14 Excel tips to help you work faster Picture 17

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 Excel tips to help you work faster Picture 18

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, wants to delete all the data you want in the table, use the 'DELETE' key or right-click and select 'Clear Content'.

14 Excel tips to help you work faster Picture 19

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

Hopefully the above tips will bring useful computer manipulations for you