Forum Discussion

V_SHAH228's avatar
V_SHAH228
Copper Contributor
Mar 24, 2023

Format of data change

Hi Everyone , 

I am facing one issue from today. when I am trying to copy table like this in to Excel. Previously I use to copy -paste as table . now a days it copy as some data together as in 2nd screen shot.  Not sure why this is happening. Can please someone help me fix this issue ? 

- Table I am trying to copy

 

- This is how it copy

 

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor

    V_SHAH228 

    You are copying from another application. Maybe this application writes the data to the clipboard in different format (only one column).

     

     

      • Detlef_Lewin's avatar
        Detlef_Lewin
        Silver Contributor

        V_SHAH228 

        Does this happen every time when you copy?

        Does it happen in every sheet/workbook?

        Did you close and restarted Excel?

        Did you started Excel in Safe Mode?

         

Resources