How to Fix – Macbook’s Battery Not Charging? Fan Problems? Overheating?

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 need to reset your PRAM and SMC.

Before you go further, it is highly recommended to take back-ups of your important files and photos.

How to reset the PRAM?

  1. Shut down your MacBook by pressing power button for longer period. 
  2. Once your system is completely shut down. Press the Power button.
  3. Then, Press Command Option P R at the same time and keep holding these keys until the grey screen appears.
  4. After sometime, you will hear the Macbook’s Start-up sound. You can now release the keys, and let your MacBook do the rest of the work.
  5. You are done.
1) Press the Power button.
2) Then, Press Command Option P R at the same time.

How to reset the SMC of your MacBook Pro or MacBook Air?

  1. Shut down your MacBook by pressing power button for longer period.
  2. Keep the power cord of your MacBook plugged in.
  3. Press Shift-Option-Control Power Button at the same time and then let go
  4. Now, turn your MacBook on.
Press Shift-Option-Control Power Button at the same time and then let go

How to open a CSV file if you don’t have MS Excel installed?

When I joined my new company, I was given a Mac and was asked to do all my works with that. That Mac didn’t have MS office and it was not allowed to install as well. So I was finding it very difficult since I had to deal with MS excel and CSV files.

Ultimately I found the solution of my problem, I am sure its a common problem for many people and therefore I would like to share it.

How to open a CSV file if you don’t have MS Excel installed?

It involves two easy steps:

  1. Upload on Google drive
  2. Once uploaded, open it with Google spreadsheet

Upload on Google drive

– Go to and click on New, then select upload files option and choose your CSV file to upload.

– Open it with Google spreadsheet

– Once the upload is complete, just click on the file and it will open in a Google spreadsheet and Yay… you are all set to go.

Important: Just remember one thing, once you have uploaded the file, try to rename it, else later you might not be able to find it. So either rename it to something which you can remember, or add the link to any other spreadsheet, or add it to any folder which you remember.

Still confused? Watch this video.

How To View Multiple Image Files On Mac?

If you’re a new Mac user who just switched from a decade use of Windows then this one will be a good hack for you to learn.

Opening multiple image files on Mac is a common headache among Mac users and we have just the aspirin you need.

1. Open the directory/folder where the image files to be viewed have been stored.

Screen Shot 2014-12-15 at 10.44.43 PM

2. Select the photos that you’d like to open in a slideshow. If you want to open all the image files present in the directory, then press: command + A

Screen Shot 2014-12-15 at 10.45.04 PM

3.  Press control and then click.

Screen Shot 2014-12-15 at 10.45.17 PM

4. Select open option.

Screen Shot 2014-12-15 at 10.45.26 PM

5. The photos selection made by you are now open to view. To view it as a slideshow, all you have to do is maximize the window.

Screen Shot 2014-12-15 at 10.46.10 PM

6. That’s how the slideshow looks like.

Screen Shot 2014-12-15 at 10.46.30 PM

Below is a video walk through of the above process.


How To Setup Mac As A Wifi Hotspot?

Did you know that you could use Mac to setup a Wifi Hotspot thereby eliminating the need of a physical Wifi router.

So if you have a LAN connection and don’t have a wifi router, you can turn your Mac into a wifi hotspot and use the Wifi for all your other devices like mobile phones, tablets and other laptops.

The steps have been listed below.

1. Click on system preferences.

Screen Shot 2014-11-29 at 12.20.14 AM


2. Now click on sharing.

Screen Shot 2014-11-29 at 12.21.09 AM


3. Select Internet options(don’t check the box) and from the drop down select USB Ethernet and then check the wifi option below, then click on wifi options below.

Screen Shot 2014-11-29 at 12.35.29 AM


4. Now in this portion you can decide on a name and then decide on a password as well so that no random people can join your network, don’t change security or channel.

Screen Shot 2014-11-29 at 12.39.31 AM

5. Now come back to the previous screen and check internet option.

Screen Shot 2014-11-29 at 12.40.53 AM

Now you are all set to go, you can find this wifi from other devices and you know which password to put.