![Copy Paste Row Height in Excel [Quick Tip]](../../wp-content/uploads/2013/04/1-minute-excel-tutorial-150x150.png)
Copy Paste Row Height in Excel [Quick Tip]
In Excel we have the ability to easily copy and paste the column width using paste special and the beauty of this trick is that you simply have to copy the column having a desired width and go the column of which you want to adjust the width and hit Alt+ Ctrl+V > from the […]
Excel ALTernate ‘Powercut’ - One key to rule ALL shortcut keys
Ranking up in Excel world is not easy but definitely there are steps you can take to become an Excel head and one of such steps is to remember shortcuts. Well you have no idea how much Excel nerds who know shortcuts are appreciated in this part of the world. But if you look at […]
Dealing with Telephone numbers in Excel - Dialing in the correct format
Many have the impression that Excel is a tool to do maths. But the ones who are using it on daily basis know that Excel is way beyond just calculation and helps you maintain information and later extract it they way you like. However, when it comes to number, there are situations where Excel stops […]
Comparing two columns to highlight Duplicates in the same row - Excel Conditional Formatting
Back to Excel after a long time. But now starting to relax a little as course is concluded for many subjects I teach. I really missed my Excel community and I really want to thank each and everyone of them that they have not given up on me. Love you all! During my break from […]
Adding specific Prefix to All cells or Specific cells in Excel - 3 Methods Explained
A dear friend of mine contacted me early in the morning and the length of his message was evident that he has tried his best to get his head round the problem but in vain. The reason was an excel file with over 25,000 contact numbers with or without area codes before actual contact number. […]
30+ Copy & Paste Tricks You Must Know - Mouse Keyboard Autofill Paste Special and More!
Ctrl+C & Ctrl+V - The Saga continues! For sure Ctrl+C and Ctrl+V is one of the most famous keyboard shortcut in windows environment and one big reason for it become famous beyond limits is that it can be used in almost every Windows application software including Microsoft Excel. You might know how to do copy […]
Hiding Gridlines in Excel - Learn the Right Ways
One of our facebook community member consulted for Excel help and sent me a sample file. In that I noticed in order to hide gridlines, that are visible by default, were “forced” to disappear by filling the cells with white fill colour. Yes it does work but its not the right way to do it. […]
Conditional Charts in Excel - Workaround + How To
Last time we learnt how to make simple dial charts. There is so much to be discussed as basics to Excel charting but without little fun and doing out of ordinary is what everyone asks for. So today we will talk about how to do conditional charting in Excel. Making things clear, there is no […]
Count Specific Weekday or Weekdays within Data range containing Dates
Often we have to deal with dates as they form integral part of almost every data set. But what if you want to count specific weekdays within a large range of dates? This is often the case with time sheets or similar kind of data set where dates are involved and you have to count […]
Removing leading Apostrophe (‘) in Excel from Numbers and Text
This question is asked by one of the member at our facebook community. He was stuck in common problem. Leading apostrophes. This is often the case if data is extracted from a famous business application Lotus Notes. If the data is copied or extracted to Excel then these unwanted characters interferes with Excel’s normal functioning. So […]
