Sometimes, you want to add a new column to just part of a spreadsheet. That's easy to do as well. Step 1: Select the cells to the right of where you want to add the new column.

Finally, people who want to sum an entire column, must add the column letter to the SUM function, and ensure the results come up in a different column: =SUM(C:C) That’s it.

How to add a column in Excel using the "Home" tab. 1. Open Microsoft Excel on your PC or Mac computer.. 2. Instead of right-clicking, you can also use a feature in the "Home" tab. This tab is the ...

Step 3: From the menu that appears, choose Hide. Your selected columns should now be hidden from view. Note that you cannot add new columns into the hidden group.. How to unhide columns in Excel ...

Comparing two columns in Excel doesn’t have to be a difficult task, and to get the job done, we suggest using VLOOKUP.You see, not always; the columns you want to compare are in the same ...

How to combine two or more columns in Excel. 1. In Excel, click the "Insert" tab in the top menu bar. Then, click "Table." 2. In the "Create Table" dialog box that pops up, edit the formula so ...

Sorting is one of Microsoft Excel's easiest tasks. Click; you're done! At least until you need to sort by multiple columns. For this sort task, you'll need a custom sort. Here's how.