Mike asks how he can hide 100 lines of text from Word in a single Excel cell. When the cell is selected, the text will appear. This episode 1866 shows one way to do this using cell comments. There are likely other ways - please post how you would solve this in the YouTube comments.
Transcript of the video:
MrExcel podcast is sponsored by Easy-XL. Learn exel from MrExcel podcast.
Episode # 1866 Fit a multi-page document in a cell.
Hey welcome back to MrExcel netcast.
I'm Bill Jelen. Today's question sent in via YouTube from Mike.
He has a very long document in word. He'd like to fit that in one cell in excel.
And so he says he has 100 lines in word and it has a cell that says functional testing and when he clicks on that cell it will open up and give me all hundred lines that was copied and pasted from Microsoft Word.
How can I do that? Well here's one way there might be other ways but this is the way that came to me.
First I'm going to switch over to Microsoft Word or I use the RAND function to create a hundred lines of text.
Ctrl C to copy.
Come back here to Excel and on Review tab, I'm going to insert a new comment.
Now the comment starts out with whatever name is assigned to your system and it starts out kind of small but you can Ctrl V to paste those hundred lines in there and then resize the comment.
However it needs to be bigger then this B so that we can see all 100 lines.
Now on my other monitor it was actually big enough to show the entire thing. On the small laptop monitor that I'm using here well it's not.
But that text is now kind of hidden in the comment you see click away from the cell and the comment gets hidden but even if we just hover over the cell it pops up and shows all of that text.
So based on Mike's question that's the way that I would probably go to allow all of that text to appear when we either select or hover over the cell.
All right hey I want to thank you for stopping by.
Will see you next time for another netcast from MrExcel.
Episode # 1866 Fit a multi-page document in a cell.
Hey welcome back to MrExcel netcast.
I'm Bill Jelen. Today's question sent in via YouTube from Mike.
He has a very long document in word. He'd like to fit that in one cell in excel.
And so he says he has 100 lines in word and it has a cell that says functional testing and when he clicks on that cell it will open up and give me all hundred lines that was copied and pasted from Microsoft Word.
How can I do that? Well here's one way there might be other ways but this is the way that came to me.
First I'm going to switch over to Microsoft Word or I use the RAND function to create a hundred lines of text.
Ctrl C to copy.
Come back here to Excel and on Review tab, I'm going to insert a new comment.
Now the comment starts out with whatever name is assigned to your system and it starts out kind of small but you can Ctrl V to paste those hundred lines in there and then resize the comment.
However it needs to be bigger then this B so that we can see all 100 lines.
Now on my other monitor it was actually big enough to show the entire thing. On the small laptop monitor that I'm using here well it's not.
But that text is now kind of hidden in the comment you see click away from the cell and the comment gets hidden but even if we just hover over the cell it pops up and shows all of that text.
So based on Mike's question that's the way that I would probably go to allow all of that text to appear when we either select or hover over the cell.
All right hey I want to thank you for stopping by.
Will see you next time for another netcast from MrExcel.
