Excel

Show value as Kb/Mb/Gb with Excel

2011-12-05 121 words, 1 minutes
excel
format

There are times when you want Excel to show numbers with a specific unit. In my case, I have a list of memory size that I want to print as Kb, Mb or Gb.

Switch Excel columns and rows

2011-07-14 102 words, 1 minutes
column
excel
line
switch
transpose

When using Excel to write down things, I often end thinking I’d rather have used another layout. Most of the time, I want to switch columns and rows to get a better “one-screen” view.