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 / Worksheet Functions / November 2006

Tip: Looking for answers? Try searching our database.

help with formatting a sheet with text and numbers

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Scudder65 - 10 Nov 2006 16:15 GMT
I'm trying to write a new purchase agreements templete in excel.  The top 15
rows of the templete is basically text with a bunch of merged cells and then
some single cells that I use to fill in the blanks; ie, date, name, address.

The remainder of the rows I use to list all the options on the left side of
the sheet and the value (price) on the right side of the sheet.  In order to
do this so it looks professional I need to make column "A" considerable
wider, however if i highlight all of column "A" and try to make it wider it
alters all the text in the top 15 rows.

Is there a way around this?

Thanks!
vezerid - 10 Nov 2006 16:36 GMT
What do you mean it alters the text?

Kostis Vezerides

> I'm trying to write a new purchase agreements templete in excel.  The top 15
> rows of the templete is basically text with a bunch of merged cells and then
[quoted text clipped - 9 lines]
>
> Thanks!
Scudder65 - 10 Nov 2006 16:46 GMT
I'm sorry in advance for not using the correct terminology, what happens is
when i try to widen column "A" it effects all the text in column "A" and
causes all the text on top of the sheet to get pushed beyond the print area.

> What do you mean it alters the text?
>
[quoted text clipped - 13 lines]
> >
> > Thanks!
vezerid - 10 Nov 2006 16:53 GMT
OK, to tell you the truth I am no expert in printing issues. One thing
I noticed is you use merged cells. These can certainly cause problems.
My advice, instead of merging cells leave them as they are and just use
formatting to create uniform areas. You might discover that several of
your plights go away.

HTH
Kostis Vezerides

> I'm sorry in advance for not using the correct terminology, what happens is
> when i try to widen column "A" it effects all the text in column "A" and
[quoted text clipped - 17 lines]
> > >
> > > Thanks!
 
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.