Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
You can create a text box in a Numbers spreadsheet from existing text in other applications. For example, if we have some existing draft text in a TextEdit text file, we can copy that from the text file into our Milea Listing and prospects spreadsheet here. First, we'll switch to that document. It's called Milea_Draft_Text and it's a rich text format document. Next we select the text we want to copy. Let's click and drag across the first paragraph only and we'll copy that either by clicking Edit and choosing Copy or use the keyboard shortcut Command+C, with our text copied now we switch back to our Numbers spreadsheet and we'll paste it.
Now if we want to keep the style from our text file, we can just choose Paste, but we wanted to match the style of our spreadsheet, click Edit and choose Paste and Match Style. A text box is automatically generated and the text is inserted inside that text box. So all we need to do now is resize our text box and move it into position. We can manipulate this text box like any other text box in a Numbers spreadsheet. Deselect the text box by clicking the canvas to see the end result better.
Now if you already have text in a text box in another application like Pages or Keynote for example, you can copy the entire text box over. Let's switch to our Pages document called Milea Brochure. Here we have got some text in the text box, so that we can select by clicking once and now we'll copy that either from the Edit menu or Command+C if you prefer using the keyboard shortcut. Now we'll switch back to our Numbers spreadsheet and let's go to the current listing sheet by clicking it in the Sheets pane, we'll click Edit and this time we'll choose Paste to keep the original styling, we won't match the style of our current spreadsheet, Command+V is the keyboard shortcut for that. Notice it appears down here below our images and again we could resize this and position it accordingly and deselect when we are done.
So remember, if you wish to add text in a text box in Numbers and that text already exists elsewhere, there is no need to retype. Copy the text from any other application to paste it into a text box in Numbers.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 74154 Viewers
80 Video lessons · 129550 Viewers
52 Video lessons · 63843 Viewers
59 Video lessons · 49621 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.