Adding a new column to either an entire spreadsheet or just a portion is an easy thing to do in Microsoft Excel. Here's how.

This will apply this formula to the whole column and you won’t receive a #DIV/0! in any of the cells in a column. In a similar manner, you can also use the ISERROR function.