#How to consolidate data in excel 2016 how to
#How to consolidate data in excel 2016 free

In Excel, click 'Tools' under the navigation bar.

The Apple operating system doesn't have an ALT key, so you have to set up your own shortcut to merge cells. Then, type the following key combinations. For fast merging, start by highlighting the cells you want to merge.

#How to consolidate data in excel 2016 how to

Source How to Merge Cells in Excel ShortcutĬlicking the correct 'Merge' function over and over can be a drag if you need to combine a lot of cells. Step 3: Your cells will merge and the data will be centered within the cell. Step 2: Under the Home tab, click the 'Merge' icon and choose 'Merge & Center.' Step 1: Highlight the cells you want to merge. Merge and center cells by following these steps. Say you're building a marketing report and want your titles to be centered above your data. If you only need the information in the upper-left cell, click 'OK' to merge the cells. This alert will pop up:ĭon't want to delete the data? Click 'Cancel,' and copy/paste the information into a separate document or cell before merging. If you happen to have data in both A1 and B1, Excel won't simply wipe it. Make sure to save the information from the other cell so it's not lost. Note: When combining cells, only the data in the upper left cell is saved. Step 3: That's it! You've merged the cells. Step 2: Under the Home tab, click the 'Merge' icon and choose 'Merge Cells'. Step 1: Highlight the two adjacent cells you want to merge (I'm merging A1 and B1 in the example). This is useful for organizing information and creating headers, without the need to resize individual cells. Merging is a way to turn two small cells into one new, large cell.

#How to consolidate data in excel 2016 free

To sharpen your skills, we'll cover several ways to combine cells.ĭon't want to start from scratch? Use these free Excel templates as a foundation for your own marketing spreadsheets. Whether you're planning blog articles for the upcoming quarter, creating an email list for a targeted campaign, or designing SEO-friendly Google ads, merging cells is a handy way to organize your information. One is knowing how to merge cells in Excel. The tool is great for quickly processing vast amounts of data, but it can be overwhelming if you don't spend the majority of your workday whipping up spreadsheets.įortunately, a few basic skills are all you need to put together an easy-to-read spreadsheet. Knowing the ins and outs of Excel is essential for organizing data, understanding analytics, and getting the most from your marketing efforts.