Excel 2016 consolidating

Since Quick Books for Mac does not work with Marketplace programs, you have to use Option 2 if you are currently using this version (applies to US only).

Simply select the columns you want to Auto Fit, then select the Auto Fit Column Width command from the Format drop-down menu on the Home tab. Instead of resizing rows and columns individually, you can modify the height and width of every row and column at the same time.

This method allows you to set a uniform size for every row and column in your worksheet. After you've been working with a workbook for a while, you may find that you want to insert new columns or rows, delete certain rows or columns, move them to a different location in the worksheet, or even hide them.

I remember one particularly tedious experience where our accounting department was given a folder of more than 200 CSV files that had to be combined into a single Excel workbook.

When a new CSV file arrived, those records had to be deleted and replaced in the workbook.

Fortunately, Excel 2016 (and all prior versions) make it very easy to grab data from many different cells and put it into one.

Just don't confuse this "combining" with "merging," another Excel procedure which causes one cell to span across multiple columns, but only uses the content from that single cell. Select a location where you want the new, combined cell(s) to appear.Most likely, you'll want to pick a new column that's to the right of your other cells, but you don't have to. Type =B2&C2 into the formula bar where B2 and C2 are the addresses of the cells whose data you want to combine (it could be any two cells).You can use an unlimited number of ampersands to add an unlimited number of cells. Include spaces between cells by adding &" " to the forumla. Copy and paste your formula to reproduce the results in other rows.With numerical data, the cell will display pound signs (#######) if the column is too narrow.Simply increase the column width to make the data visible.The Auto Fit feature will allow you to set a column's width to fit its content automatically.