Excel or commonly known as the spreadsheet is a powerful tool when one knows how to use it. It starts with the basic to advanced techniques for making tedious task an easy one.
But, it’s a great loss for the ones who have them on their home screen but do not how to use it.
Microsoft has made various innovations over the years in the spreadsheet but the basic has always been the cornerstone for each version of Excel.
Excel is a vast tool which has unmeasured functions if known how to use it correctly.
Here, we will highlight only the basic tricks and tips for starters that you can lay your hands on if you are learning excel.
One click for selecting all
Just like the shortcut key Ctrl+A, the icon on the top left corner allows you to select all the elements in the spreadsheet.
Advanced Excel Tips to Open multiple excel sheets
When there is a need to navigate through multiple spreadsheets, just select different excel files and press enter.
Adding rows or columns
In order to insert more than one row or column, you can drag and select you are required no of rows and columns above or left.
Then you are desired no of rows and columns will be inserted.
Copying similar data in cells
You can easily copy all the same data from one column to another.
Just press Ctrl button before you drag to move the data.
The data will be copied.
For the better display of your data, you can transpose the row into the column or vice versa.
To do this,
first copy the portion that is to be transposed and move the pointer to another blank location.
Then go to home>paste>transpose.
Dealing with data which starts with zero
The data with zero are automatically removed from excel.
To prevent this,
you can simply add a single quote mark in front of first zero.
Then there is your solution.
Get more status
After you’ve input the data, you might want to check the status of your data.
Here’s how you can do it.
You can point to the bottom tab and right click to see the status of date like sum, average, max, min etc.
Renaming the cells
Most people will right click and rename the data cell to input new name in the sheet. However, to save the time, you can double click and rename the data cell in the blink of an eye.
Deleting blank cells: Advanced Excel Tricks
In the spreadsheet data, default data can be blank for different known and unknown reasons. So, in order to maintain accuracy while finding average etc, you can filter out the blank cells and delete them.
Here’s how you do it.
Go to Data>filter.
In the filter as the downward button shows up, you have to undo select all and tick the last option i.e. blank.
Then all the blank cells will be selected.
Now you can delete them directly from the home.
Most important Excel Tips to Create a new shortcut menu
Excel is known for its efficiency. Shortcuts like save, undo typing, repeat typing helps to make work faster in Excel.
However, if you want to have more shortcut option keys to be shown in the menu then here’s how you can do it:
file>option>quick access toolbar; add the desired option from the left column to the right and save it.
This is how you add other options in the top menu.
These are some of the basic tips in Excel for any beginner to work with data.
However, there are only handfuls of people in the world who truly know all the excel tips and tricks.
If practiced and experimented often, you too can become a master in a spreadsheet and will be amazed by how powerful and handy excel tips is.
This article was written by Dumhash