Inserting from the other site with the same format

%3CLINGO-SUB%20id%3D%22lingo-sub-2117969%22%20slang%3D%22en-US%22%3EInserting%20from%20the%20other%20site%20with%20the%20same%20format%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2117969%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%3CBR%20%2F%3ESorry%20in%20advance%20if%20I%20am%20asking%20a%20silly%20question%2C%20but%20I%20really%20didn't%20find%20the%20answer.%3CBR%20%2F%3EI%20have%20to%20insert%20the%20text%20data%20into%20a%20cell%20from%20the%20other%20site.%20And%20each%20time%20it%20pastes%20with%20the%20font%20and%20size%20of%20the%20text%20in%20the%20excel%20file%2C%20but%20also%20with%20the%20rows%20between%20text%20(not%20like%20the%20plain%20text%20in%20the%20formula%20bar).%26nbsp%3B%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EOriginally%20I%20have%20format%20without%20a%20check%20mark%20on%20the%20Wrap%20text%2C%20but%20when%20I%20insert%20text%2C%20the%20format%20changes%20to%20the%20format%2C%20where%20check%20mark%20on%20the%20Wrap%20text%20appears.%3CBR%20%2F%3EAnd%20each%20time%20I%20have%20to%20copy%20format%20from%20the%20other%20cell%20and%20paste%20it.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EHow%20can%20I%20escape%20this%20situation%20and%20copy%20paste%20with%20the%20format%2C%20that%20is%20set%20in%20my%20sheet%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2117969%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi!
Sorry in advance if I am asking a silly question, but I really didn't find the answer.
I have to insert the text data into a cell from the other site. And each time it pastes with the font and size of the text in the excel file, but also with the rows between text (not like the plain text in the formula bar). 


Originally I have format without a check mark on the Wrap text, but when I insert text, the format changes to the format, where check mark on the Wrap text appears.
And each time I have to copy format from the other cell and paste it.


How can I escape this situation and copy paste with the format, that is set in my sheet?

1 Reply

@Ekaterina_Petz 

 

Paste options

https://support.microsoft.com/en-us/office/paste-options-8ea795b0-87cd-46af-9b59-ed4d8b1669ad?ui=en-...

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)