Microsoft Excel is the most popular and best application to manage, organize and organize crucial data.
This application is used in countless ways and this is the reason why the number of features are packaged within the popular application of this Microsoft.You can get Office 365 and office 2019 from here.
This does not matter if you are a casual user or an Excel expert, it is important to know everything in it so you can easily use this complex application.
Here in this article, we are describing – easy tips n tricks that will make you master Microsoft Excel:
- Columns in rows
If you have data in columns that should be in rows or otherwise …
… so here we have advice to do it without losing anything.
Simply copy the original cell block> right click on the target cell > click Paste Special> Transpose.
- Hide individual cells
Excel has a main trick of hiding cells.
All you need to do is select the cell you want to hide and right-click> select Format Cells, and then set the format to Custom in the Number tab and Enter ;;; (three semicolons) as the format.
Now the content of the cell disappears but they are still present there and can be used in formulas.
This is really amazing to excel tricks and tricks
- Freeze rows and column headers
This is the simple but useful trick to become an Excel expert.
Freeze the row and column headers so they can always be seen when you scroll.
For this, LOOK
Place the cursor in the upper left cell where the real data begins and go to the VIEW menu and simply select Freeze Breads and Freeze Breads.
Now the header is visible wherever it moves.
- Quickly move and copy data in cells
If you want to move a column of data in a spreadsheet. then the easy and quick way is to select it and move the pointer to the edge after it becomes a crossed arrow icon and then drag to move the column freely.
But if you want to copy the data, then press the Ctrl button before dragging to move the new column will copy all the selected data.
- Quickly remove blank cells
Some of the default data will be blank for several reasons.
So if you need to eliminate these to maintain accuracy, particularly when calculating the average value.
The simplest way is to filter entire blank cells and eliminate them with a single click.
Choose the column you want to filter and go to Data> Filter after the button is shown down,
… undo Select All and then select the last option Blanks.
The entire blank cell will be displayed immediately.
Now go to Start and click on Remove directly, everything will be deleted by clicking once.
- Use Flash Fill to save time
Fill filler makes work easier, so if you reformat the data in adjacent columns,
… then this is very useful.
Recognize the patterns and fill in the rest of the details for you.
Just give some examples excel at the top and you will see the suggestions in gray , press Enter to accept.
- Add comments to the formulas
Add space and + N (“your comment here”)to leave comments on your formulas …
… for your own reference or to help other people understand your spreadsheet.
Comments do not appear in the cell but are displayed in the formula bar and can also be searched.