Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / July 2007

Tip: Looking for answers? Try searching our database.

Compressing letters in a cell

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
JERRY - 10 Jul 2007 17:43 GMT
I have a seating chart for a group of students. I want to show each first
and last name in a single cell in the following fashion, without changing
the font size or cell length.

Last Name,
First Name

Some names are quite long.  Is there a way to compress the letter spacing
(up to a reasonable degree of course) so that the last name stays on top
without separating the last few letters of the first name

Otherwise, here is what is happening

First Nam
e Last Name

Thanks for any help ... I am using office Excel 2007

Jerry
Earl Kiosterud - 10 Jul 2007 22:01 GMT
Jerry,

One possibility: After typing the first name, press Alt-Enter, then the last name, then
Enter.  You can also select and format either part, then format it for a smaller (or
different) font to get it compressed.

Signature

Earl Kiosterud
www.smokeylake.com

   Note: Top-posting has been the norm here.
   Some folks prefer bottom-posting.
   But if you bottom-post to a reply that's
   already top-posted, the thread gets messy.
   When in Rome...
-----------------------------------------------------------------------

>I have a seating chart for a group of students. I want to show each first and last name in
>a single cell in the following fashion, without changing the font size or cell length.
[quoted text clipped - 14 lines]
>
> Jerry
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.