1.) How To Convert Positive numbers into Negative – Part 1
Sometime While working with negative numbers we do forgot to add Minus in the start of number and its a bit frustrating when we have to enter huge table with negative numbers and have to put minus again and again in the start of every number.
In that case we have two Options
Change the number Formatting of the number –
For that go to Format cell by CTR + 1 and in that go to custom and type -##################.
This will Change the visibility of Positive number to negative number but when you will perform the Sum of Substract with this number it will act like the positive one
so In that case we can use the 2nd option
2.) How To Convert Positive numbers into Negative – Part 2
Use the formula in the cell near the cell which contain positive Number
=positive number cell ref – (2*positive number cell reference)and then drag it along the table and then paste special it to column where you want it.
3.) Convert The numbers in 10,00,000 Format
We Indian Use to have an Habit of Watching the number into 10,00,000 Format but Ms Excel Does Not give us the default formation for this type of presentation
To Change the formatting we just have to perform the following steps
1- CTR + 1 to go to format cell
2- Go to custom
3 – paste this formatting _(* #,##0.00_);_(* (#,##0.00);_(* “-“??_);_(@_)
4.) How To hide Formulas In Excel
Sometimes While sending the worksheets to other person we do not want to reveal the formulas we used for that You just have to perform the following Steps
1- Go to Format Cell using CTR + 1
2- Under Format Cell Go to Protection Tab
3- Under protection Tab Select both locked and hidden box as Shown in above image and then click OK
4- Now Go to Review tab and click over protect sheet and give the password
5- its done now no formula will be visible unless you UnProtect it
5 ) Short Cut Key of Opening Pivot Table In Excel
Alt + N + V
LETS WRAP IT UP FOR THIS WEEK
I HOPE THE ABOVE INFORMATION WILL ADD VALUE TO YOUR WORK.
BUT WAIT WAIT ITS NOT DONE HERE YOU HAVE TO PRACTICE EACH TRICK AT-LEAST ONCE.
IF YOU LIKED IT PLEASE SHARE YOUR VIEW VIA EMAIL
IF YOU DIDN’T LIKED IT OR FACED ANY PROBLEM IN ANY TIP PLEASE LET ME KNOW VIA EMAIL
SHARE THE SAME WITH YOUR FRIENDS AND TEAMMATES
IF YOU ARE NEW VISITOR YOU CAN SUBSCRIBE TO WEEKLY FREE TIPS BY CLICKING HERE