I find working with Macros quite fun. I have automated many of my repetitive, manual and really really boring tasks with Excel VBA Macros. Once I got a task of copy-pasting more than 10,000 lines of items one-by-one from Excel to one of our ERP system and print these items. Usually, it would have taken me several days to finish this task but with macros, … Continue reading Two Easy Ways to Stop or Interrupt a Running Macro Command Without Closing Your Excel File?
Most of the time you may not need to cancel a command or interrupt your ongoing calculations in Excel as it carries out swiftly. But many times if you have got a very big file with lots of formulas and you have given a command or started any calculation say filtering any data then it may take a while to finish the action depending on … Continue reading Two Easy Ways to Cancel a Command or Interrupt Any Ongoing Calculations in Excel?
You want to change your Google Adsense account’s country to receive your website earnings in new country’s bank. When you go to Google Adsense account settings to change the address then you find that you can only change the address but not the country. Can you really change the country? Answer: No, You Can’t Google AdSense only allows you to change your address within the … Continue reading How To Change Country In Adsense
One of the common queries that I receive is “how I can clear cookies?” Probably they want to keep their browsing tracks clean. Before we start, let’s talk about Cookies; these are text files written by web browser like Google Chrome when you browse certain website. It stores your browsing information such as your login details, forms filled in the website and other information that … Continue reading How To Clear Cookies In Chrome Browser
Sometimes, when you copy the texts from website to excel then you may find extra spaces that you may like to remove it. If you have few texts then you can easily manually remove it but if you have got zillions of cells then it becomes quite a challenge. Simple Fix Luckily Excel have a simple solution for it. If your excel cells have got … Continue reading How To Remove Extra Spaces In Cells In Excel
If you encounter this error while attempting to login too many times then you may have to wait for 10-20 minutes in order to get your login page back. It’s a hosting server specific error that prevents your website against hackers. Next time, when you get your login page back, try to reset your password and login again instead of trial and error. Continue reading WordPress “Unused” Error When Login Password Entered Incorrectly
I work with large data in spreadsheet and pivot table comes very handy in summarizing the data. However, often I encounter with an error when I try to group the multiple sets of date. Types of Pivot Table Date Grouping errors Pivot Table does not Group dates properly – It gets grouped into just one Group namely ‘Group 1.’ Sometimes it gives an error that … Continue reading Excel Error – Pivot Table Does Not Group Dates Properly or Give Errors
If your Macbook Pro or MacBook Air is giving you hard time with issues like : The battery is not charging. The cooling fan has suddenly started making non-stop loud noise and it won’t go no matter how many times you restart the system. MacBook get frequently hanged and you lost all your work. There is a simple fix to all these problems. You just … Continue reading How to Fix – Macbook’s Battery Not Charging? Fan Problems? Overheating?
Lately, my Excel file started popping-up an error messages. It’s so annoying as it pops-up every time I save the file which I do like every 30 seconds. “Be careful parts of your document may include personal information that cannot be removed by the document inspector.” I fixed this error as below – Step 1 – Open your spreadsheet and go-to File Step 2 … Continue reading How to Fix – “Be careful parts of your document may include personal information” Error Message in Microsoft Excel
Many times we need to convert an URL to PDF, reasons might be different, the solution is pretty easy. You do not need any tool (if you Google, you will get many), you don’t need any software. This can be done right from your browser, see the process below. Open the URL you want to convert Now press Control+P (the one which is used for … Continue reading How to convert an URL/html to PDF?
Are you looking for a way to download Pokemon Go on your Android or iOS phone in India? Since this game is only available in few countries and India not being one of them, you might get disappointed that you can’t play this game. Well, don’t get disappointing, here ‘s how you can download, install and play this game in India, both in iOS and … Continue reading How to Install and Play Pokemon Go in India