Excel 2016 Copy & Paste - Microsoft Community


dear excel gods/community, 

i have question in regards coping , pasting text in excel. when pasting large text in cell box know right away fills row. however, if want expand text within range, example, $a$22:$h$24. in order paste text in desired cell range using previous example, inserting text box option? thank time!

from,

hannah

hi hannah,

you can select range , go format cells (ctrl+1) > alignment > check wrap text & merge cells options.



Office / Excel / Mac / Office 2016 for Mac



Comments

Popular posts from this blog

Getting ErrorCode: 120018 when trying to access Microsoft account - Microsoft Community

The message was sent to a distribution list ‎(DL)‎ - Microsoft Community

Activation Error 0x8004FE93 - Microsoft Community