How often do you use excel? If you use excel quite often and want some handy Excel tips then continue reading. There are better ways of performing tasks that you currently use Excel for. There are many tips and chart sheets online which include very basic shortcuts such as Ctrl+C is copy. But I am writing neither for very basic nor for any high funda formulas. So just simple daily use Excel tips.
Sum Function in Excel.
Do you use =sum(A3:A10) such kind of formula to get sum? So how do you do it? You type this formula. Right?
But there is shortcut to this. First of all go to cell below your values you want to sum (in example below it is cell C20). And you JUST have to press Alt + = to get sum of above values.
Want to press enter to go to another line but in same cell?
You JUST have to press Alt + ENTER.
Formatting cells –
Outline border CTRL + SHIFT + &
Remove outline border CTRL + SHIFT + _
Also we want to remove duplicates from a list more often.
a. First of all select the list from which you want to remove duplicates.
b. Go to Home –> Styles –> Conditional Formatting –> Highlight Cells Rules –> Duplicate Values.
c. See below screenshot and you can easily understand.d. Then a pop up will appear. From this you can either select option to highlight Duplicate or unique values. And also you can select how you want the formatting for those values. See below
Part Sentence Deletion
So you have written a big sentence in a cell and want to remove the last part. Yes there is a shortcut for this too. To delete text to the end of the line Ctrl + Delete . See example below. I want to delete the whole part after the word highlight. Just get your cursor there and press Ctrl + Delete.
All these trick will surely save you some clicks and time.
Like this article? Many more to come from basic to hi-tech formulas and easy explanation. So please Subscribe to get them all by mail as soon as I post.
Do share and spread knowledge.