Hi

Record a macro,

On your sheet select "Tools" then "Macro" then "Record New Macro"

On the popup screen put a letter as in the blankbox next to Ctrl+ as this
will be your shortcut, then click ok.

Right mouse click the blank box above row 1 next to A, then right mouse
click, and do the format cells, alignment, check Wrap, then click A1 on your
sheet.

On the screen should be a small popup click the stop recording button.

Ok now do the same again but to unwrap, make the shortcut letter different
to the one used before.

Ok say you used letter shortcuts w to wrap and u to unwrap,

on your sheet do ctrl+w the sheet will wrap
do ctrl+u the sheet will unwrap.

The short cuts will work on each sheet your on.

Hope that helps.

--
This post was created using recycled electrons!


"Sanjay Shah" wrote:

Is there any way to create a speed button to wrap / unwrap text in Excel
without having to go through - Format Cells, Alignment Tab, Wrat Text?

Thanks in advance for the help
--
Sanjay Shah