Custom Footer Wrapping text

**NewToExcel-2007** · 09-05-2010, 10:54 AM

How do I get a Custom Footer to word wrap to next line.

eg use 2 lines instead of 1

**solnajeff** · 09-05-2010, 12:32 PM

Hi

Excel will wrap text automatically in a footer, however if you need to have specific parts of your text on a separate line use Shift+Enter and it will give you the equivalent of a carriage return. If you want to use VBA then insert CHR(13) at the appropriate point in the text.

Regards

Jeff

**NewToExcel-2007** · 09-05-2010, 09:03 PM

Thanks
Will try

**Oppressed1** · 01-21-2015, 05:54 PM

Originally Posted by solnajeff

Hi

Excel will wrap text automatically in a footer, however if you need to have specific parts of your text on a separate line use Shift+Enter and it will give you the equivalent of a carriage return.

This is an old thread, but since Google landed there for me and it might for others (atop my result list), I am replying to this now. I would disagree with the quote above, and say rather that Excel does not wrap footers. Also, that shift-enter does not cause the actual footer to wrap; only the dialog display. Tested only in 2003 and 2010 though.