Adding & Subtracting Vertical Columns in Excel. Part of the series: MS Excel Tips. Adding and subtracting vertical columns in Excel is something that you can do with specially designed formulas. Add and subtract vertical columns in Excel with help from a mechanical engineer in this free video clip.