Forum Discussion

Jim_Henderson's avatar
Jim_Henderson
Copper Contributor
Feb 24, 2021

Merging Cells without losing data

I have an excel spreadsheet made by someone else. Instead of merging 4 columns G, H, I, & J then typing the information, he left the 4 columns separate and typed the information into column G, The in...
  • BobOrrell's avatar
    Feb 25, 2021

    I agree with the suggestion above to avoid using merged cells. Typically it can be avoided by just adjusting the column width to fit the data in it, but we can't see what lies below, so you may have a reason, and it's not my place to tell you it's wrong or right. To answer your question directly, Select cell G4 to J<last row of data>. Go to the Home tab, and click the arrow next to Merge, an you should see other options. Choose Merge Across, and it will do all the cells that you have selected row by row. Also, for future reference, I suggest not posting personal information in your posts. Name email and phone numbers are probably not information you or the individuals on the spreadsheet want published on the interwebs. 

    <Edit>
    When you merge, Excel will keep the data on the leftmost cell, so if you do this on row 2, you may lose the E-MAIL header, but as long as the email addresses are all in G you shouldn't lose any of them

Resources