If youuse Microsoft Excel , you ’ll spot that it is a brawny software , capable of acting as a full - featured spreadsheet and data analysis cock .
While Excel is fully capable of some powerful information manipulation tasks , sometimes you need to do something simple like merge and unmerge cell . That essentially means position the value of one into multiple cells or two prison cell into a single cell . That ’s precisely what we ’re go to cover in this how - to .
Using the Merge and Center command to merge cells
The easiest agency to merge a single cell into multiple cell is using theMerge and Centercommand from the main menu . This command takes the economic value in the left - most cell in left - to - right languages or the right - most cadre in right - to - left languages and come in it into however many cells are choose . It ’s particularly utile when you want a column lintel to cover multiple columns , such as in the sample spreadsheet where we would wish the " Q1 Sales " title to refer to all of the first quarter calendar month .
( This information might afterwards be used tocreate a graphical record in Excel . )
Step 1 : pick out the cell you desire to coalesce into and select theMerge and Centercommand .
tone 2 : If you simply get through on theMerge and Centerbutton , then the " Q1 Sales " will be open across the three jail cell and center . Note that any data in the prison cell to the right will be overwritten .
stride 3 : you’re able to also selectMerge Acrossand the cells will be merged but the mental object will be moved to the left . TheMerge Cellsfunction will do the same in most cases .
Using the Merge Cells command to unmerge cells in Microsoft Excel
It ’s easy enough to unmerge cells that you ’ve merged using theMerge Cellscommand .
just select the cells you bid to unmerge , and selectUnmerge Cellsfrom the fall - down menu .
Using the Concatenate function to merge cells in Microsoft Excel
Sometimes we want to take two columns and merge them into one , hold the entropy from both columns . In our sample spreadsheet , we ’d like to take the first name and last name and flux them into a cell stop the full name .
This is easily done by using theConcatenatefunction . We create the formula in the cell where we want the full name to live . The formula is in the formatting " = CONCATENATE(A2 , " " , B2 ) , where A2 name to the left - most cubicle in the second row , B2 refer to the right - most mobile phone in the second wrangle , and the middle section indicates that we want the information separated by a space . Of course , the cadre references will change as you move down your table . We could use any symbolisation we like here . take note that any data in the column where the data is to be merged will be overwritten .
Using these dance step you’re able to easily merge , unmerge , and mostly manipulate the layout of your spreadsheet . It has possibilities beyond a simple board , as you ’ll discover with unconstipated use .
Recording important data that you do n’t want changing ? Learnhow to interlock cells in Microsoft Exceland protect your data .
