All articles with 'Excel 101' Tag
{ 8 Comments }
Transpose Excel Rows and Columns [Quick Tip + Video]
Published on Nov 18, 2009 in Excel Howtos, Learn Excel
![Transpose Excel Rows and Columns [Quick Tip + Video]](https://chandoo.org/img/i/transpose-rows-columns.png)
Transposing rows and columns in a table is one of the most useful tricks when you are pasting data. Yet, it always surprises me that very few people actually know this. So here it is…
Continue »{ 33 Comments }
Excel Formula Errors – Understand and Debug Them
Published on Apr 20, 2009 in Excel Howtos, Learn Excel
In this installment of spreadcheats we will learn how to understand excel formula errors and fix them. The #DIV/0!, #NAME?, #N/A, #NULL!, #NUM!, #REF!, #VALUE! errors and how to fix them.
Continue »{ 252 Comments }
Excel Paste Special Tricks & How to
Published on Jul 2, 2008 in Featured, Learn Excel
Paste or Ctrl+v is probably the most effective productivity tool available to us. But how well do you know “Paste”?, do you know that there are many variations to paste data to your excel sheets? Surprised? Well, read this post to become a master paster 🙂 After copying your data, You can activate Paste Special […]
Continue »
