We are discussing about 5 Important Excel tips tricks you must know. Microsoft Excel is power full tool of Microsoft for data analyzing and mathematical work. Microsoft is introducing new and excited method to work fast and smoothly. You can also see useful and latest shortcut keys for Microsoft Excel. You may link shortcut keys for MAC Microsoft Excel
5 Important Excel tips tricks you must know 2020
How to hide text or numbers in cells
This is first trick in 5 Important Excel tips tricks. This is very important tip to hide data in cells. It will not hide the whole row or column but only data. The applied trick cells will show empty, when you will click on the cell and see formula bar, there it will show the data. Let’s start
- Type any data in multi cells, it may consist on number or text.
- Select the cells, and right click to choose format cells
- From format cells box in category click on custom
- And in type box enter ;;;
- Click on OK button.
- Now check, no cell is showing its value.
How to write 000 in start of each cell
Second trick in 5 Important Excel tips tricks. You may notice that when you enter 0 or 00 or 000 in start of cell with any number, zero value are vanished. Some time we have to append zero at start of digital number. So, let’s start How to write 000 in start of each cell.
Before type or entering any value in cell just type ‘ at start of number and then type your value. Now you will see zero are attached with the number. You can remove green symbol to click on drop down button to choose ignore error.
Warning: – You cannot apply formula on this cell to add, subtract etc.
Paste one cell data to multiple cells
3rd trick in 5 Important Excel tips tricks. Select multiple cell by pressing CTRL button from keyboard. After selecting last cell, type the data which you want to write in all selected cells. After typing the data press CTRL+Enter key. You will see all the typed data is pasted into all selected cells.
Lower to upper and upper to lower case and use of proper
4th trick in 5 Important Excel tips tricks. There are two formulas which used to case format of letters, words, and string. To apply lower to UPPER case please =upper(cellname) and hit Enter key. You will see that selected cell data is changed to UPPER case. Similarly you can change UPPER case to lower by using =lower(cellname). Proper funcation is used to capitalize all first letters of words. The syntax is =proper(cellname) and press Enter key.
Handling large string with short strings
5th trick in 5 Important Excel tips tricks. Some time you have to type your organization names which may be long with chance of spelling mistakes. You can simply apply autocorrect method to type such large string with short string. Click on file menu, click on options, click on Proofing. Next click on Auto Correct Options button. From Auto Correct Options dialog box first type a short string in Replace textbox and type in With textbox the long string and click on Add and OK button.
Tagged with: 5 Important Excel tips tricks 5 Important Excel tips tricks you must know 2020 Handling large string with short strings How to hide text or numbers in cells How to write 000 in start of each cell Lower to upper and upper to lower case and use of proper Paste one cell data to multiple cells. shortcut keys for MAC Microsoft Excel shortcut keys for Microsoft Excel