Batch-change value of thousands of cells in Excel sheet

There are milion of ways on modifying many cells’ value in single pass using… formula. But, what about a situation, when you need to perform only a single one-time bulk-change of value in many Excel’s cells?

I had a situation when I was preparing some IT project’s budget. Since I am an IT geek then writing amounts in thousands like 1,30k USD was no problem at all. However, this solution had two falls:

  • Some accounting freak, having nothing to do with IT, had problems understanding that “k” means thousands
  • Cells itself had to use some custom formatting of ##0,00k USD in order to add that damn “k”

Thus, I had to do a one-time recalculation of most of cells in my sheet to multiply their value by 1000.

Read More “Batch-change value of thousands of cells in Excel sheet”

Factory reset Kindle with semi-frozen screen

The steps for performing factory reset of a Kindle are quite easy:

  1. From the home screen, select Menu.
  2. Select Settings.
  3. Select Menu again then select Reset Device.

The problem appears when your screen is frozen and you don’t see anything or almost anything.

I had this situation that only tiny part of my screen was still responsive. I wasn’t able to see most of the menu and settings sections, but at least I managed to see:

  • When my Kindle is awaken
  • When its menu is or isn’t opened up (I didn’t see many menu items though)
  • Which page of Settings I am currently at

This allowed me to figure-out a key combination needed to blind-reset my Kindle.

If your Kindle has a completely dead screen and you don’t see anything of above then sorry, this article won’t help you.

Read More “Factory reset Kindle with semi-frozen screen”