Ms Excel 2008 For Mac How To Insert Text Box

Active3 years, 11 months ago

What key combination do I have to press to create a line break in a cell in Excel for Mac 2011? The Windows combination of Alt+Enter does not work on the Mac.

Note that I work for a large company and have Microsoft Office Standard Edition 2003 installed, so my question pertains to my installation of Microsoft Excel 2003. I would like to be able to add new line(s) to in only 1 cell in a row.

nwinklernwinkler
5,73321 gold badges41 silver badges65 bronze badges
Insert

10 Answers

The answer is to use Control+Option+Enter, which will create a line break in the cell.

As an alternative, Control+Command+Enter can also be used to achieve the same.

These combinations work both in Excel for Mac 2011 and the new Excel for Mac 2015.

As pointed out by Shameer in this answer, Alt+Enter now seems to work as well in the new Excel for Mac 2015.

Community
nwinklernwinkler
5,73321 gold badges41 silver badges65 bronze badges

The ⌥ alt key is also the ⌥ option key on a Mac keyboard.
Hence, ⌃ control+option ⌥+↩ return works too.

grg

How To Insert Text In Pdf File

Calendar
145k25 gold badges229 silver badges340 bronze badges
Mark BergmanMark Bergman
Jawa
2,2675 gold badges17 silver badges25 bronze badges
eshamesham
dwightk
6,26112 gold badges37 silver badges60 bronze badges
user72377user72377

None of these seems to work. Have tried all. I am using a keyboard to interface to the Mac. I am using Office 365.

EDIT: Weirdly if I used fn+f2 to get the curser in the cell, fn+alt+cmd+return then worked...

SuzySuzy

All was wrong. Fn + Shift + Enter is the right combination .

user123786user123786
jherran
10.6k9 gold badges40 silver badges63 bronze badges
JaredJared

fn + + + .

The fn causes the option key to become the alt key.

jherran
10.6k9 gold badges40 silver badges63 bronze badges
Martin ErbMartin Erb

In Microsoft Excel for Mac (Preview)

ctrl ^ + U

or

fn + F2

Nika MamulashviliNika Mamulashvili

http://giffconstable.com/2013/10/mac-excel-keyboard-shortcuts/ helped me figure it out -> it turns out to be ctrl-i worked on my macbook

nohillside
57.1k14 gold badges120 silver badges168 bronze badges
olivierolivier

You must log in to answer this question.

Ms Excel 2008 For Mac How To Insert Text Boxes

protected by CommunitySep 24 '15 at 4:11

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged keyboardms-office .

To add text to a chart that is separate from the text in chart titles or labels, you can insert a text box on the chart. You can then enter the text that you want.

Tip: Instead of entering text in the text box, you can link the text box to data in a worksheet cell. When the text box is linked to a worksheet cell, any changes that you make to the data in that cell will appear automatically in the text box on the chart.

After you create a text box in a chart, you can move, resize, or remove it as needed.

WindowsmacOS
  1. Click the chart to which you want to add a text box.

  2. In Office 2013 and newer versions: On the Format tab, in the Insert Shapes group, click the Text Box icon .

    In Office 2010: On the Layout tab, in the Insert group, click Text Box .

  3. In the chart, click where you want to start a corner of the text box, and then drag until the text box is the size that you want.

  4. In the text box, type the text that you want.

    The text will wrap in the text box. To start a new line in the text box, press Enter.

  5. When you finish typing, press Esc to cancel editing mode, or click anywhere outside of the text box.

See also

Insert a text box on a chart

  1. Click the chart to which you want to add a text box.

  2. On the Format tab, click Insert Shapes, and then click the Text Box icon .

  3. In the chart, click where you want to start a corner of the text box, and then drag until the text box is the size that you want.

  4. In the text box, type the text that you want.

    The text will wrap in the text box. To start a new line in the text box, press Enter.

  5. When you finish typing, press esc to cancel editing mode, or click anywhere outside of the text box.

Move or resize a text box

  1. On the chart, click the text box that you want to move or resize.

  2. Do one of the following:

    • To move the text box, position the cursor on the border of the text box so that it changes to a four-headed arrow, and then drag the text box to the location that you want.

    • To resize the text box, use one of the following ways:

      • Click any sizing handle, and then drag until the text box is the size that you want.

      • For precise sizing measurements in Windows, select the text box and on the Format tab, in the Size group, enter the size you want in the Height and Width boxes.

        For precise sizing measurements in Mac, select the text box and on the Shape Format tab, enter the size you want in the Shape Height and Shape Width boxes.

        .

    • To rotate the text box, click the rotation handle, and then drag the text box to the degree of rotation that you want.

      Tip: For precise rotation, on the Format tab, in the Arrange group, click Rotate, and then click the rotation option that you want.

Remove a text box

How To Insert Text In Pdf

On the chart, click the border of the text box that you want to delete, and then press DELETE.