For Item #2.... I believe it would be done in two parts.

1) Select all the columns you want to adjust the fit for, then click
Format/Columns/AutoFitSelection from the menu bar.

2) Select all the rows you want to adjust the fit for, then click
Format/Rows/AutoFit from the menu bar.

--
Rick (MVP - Excel)


"Ben M. Schorr - MVP (OneNote)" wrote in message
...
Would be helpful if you told us what version of Excel you were using
but...

For 1) CTRL+A to select all cells, right-click in that area, Format Cells,
Alignment, Wrap Text...

For 3) Select the cell and press CTRL+K or right-click | Hyperlink.

For 2) I'm not exactly sure what you're asking or how to do what I think
you're asking. Maybe somebody else will have an answer for you on that
one.

--
-Ben-
Ben M. Schorr, MVP
Roland Schorr & Tower
http://www.rolandschorr.com
http://www.officeforlawyers.com
Author - The Lawyer's Guide to Microsoft Outlook 2007:
http://tinyurl.com/5m3f5q



"PL" wrote in message
:

1) How do I select Wrap Text for all the cells, without doing it
individually
for each ?

2) How to adjust all cells so its width & height just fit all the text,
without doing it individually for each ?

2) How do I insert Hyper links for URL?

Thanks