Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
PL PL is offline
external usenet poster
 
Posts: 58
Default Wrap Text, Hyper links

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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 39
Default Wrap Text, Hyper links

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


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,934
Default Wrap Text, Hyper links

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



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 39
Default Wrap Text, Hyper links

Columns for width and rows for height?

--
-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



"Rick Rothstein" wrote in message
:

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




  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,934
Default Wrap Text, Hyper links

I'm not sure I understand your comment. As I read it, the OP wanted *each
individual* column to fit its own longest text and *each individual* row to
fit its own highest row... AutoFit does that.... selecting all the columns
and row, each by themselves, applies the auto fitting individually to each
column and each row respectively. Did you read the question differently or
were you trying to imply something else?

--
Rick (MVP - Excel)


"Ben M. Schorr - MVP (OneNote)" wrote in message
...
Columns for width and rows for height?

--
-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



"Rick Rothstein" wrote in message
:

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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Hyper Links Cblasingame Excel Worksheet Functions 1 March 12th 08 09:32 PM
Changing Hyper links for the whole sheet Praveen.U Excel Discussion (Misc queries) 0 December 15th 06 07:13 AM
hyper links stop working Peter Excel Worksheet Functions 0 October 13th 06 05:27 PM
hyper links in pull down menus Wayne Knazek Excel Discussion (Misc queries) 2 June 26th 06 02:43 PM
Hyper Links sweetcircuit Excel Worksheet Functions 2 June 13th 05 03:35 PM


All times are GMT +1. The time now is 09:19 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"