PC Review


Reply
Thread Tools Rate Thread

Column width Static

 
 
eighthman11
Guest
Posts: n/a
 
      29th May 2007
Hi everyone: This is probably an easy question, but I have a column
for notes in excel 2000. I want the user to be able to enter in a few
dozen letters maybe a hundred at the most but I don't want the text to
spill out beyond the length of the column which is 25 and I don't want
the row to increase in size.

Just cut off the text where the length of the column ends. If the
user wants to view the entire note he would have to click on the cell
and look up top.

Thanks for any help.

 
Reply With Quote
 
 
 
 
Tim
Guest
Posts: n/a
 
      29th May 2007
Is there anything to the right of the Notes column ? Can you just put a
space in the cells in that column ?

Tim

"eighthman11" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi everyone: This is probably an easy question, but I have a column
> for notes in excel 2000. I want the user to be able to enter in a few
> dozen letters maybe a hundred at the most but I don't want the text to
> spill out beyond the length of the column which is 25 and I don't want
> the row to increase in size.
>
> Just cut off the text where the length of the column ends. If the
> user wants to view the entire note he would have to click on the cell
> and look up top.
>
> Thanks for any help.
>



 
Reply With Quote
 
Gary Keramidas
Guest
Posts: n/a
 
      30th May 2007
try formatting the cell, horizontal->fill or right justified.

--


Gary


"eighthman11" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi everyone: This is probably an easy question, but I have a column
> for notes in excel 2000. I want the user to be able to enter in a few
> dozen letters maybe a hundred at the most but I don't want the text to
> spill out beyond the length of the column which is 25 and I don't want
> the row to increase in size.
>
> Just cut off the text where the length of the column ends. If the
> user wants to view the entire note he would have to click on the cell
> and look up top.
>
> Thanks for any help.
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
cannot paste source column width to destination column width transkawa Microsoft Excel New Users 1 15th Oct 2010 04:09 PM
Dynamically Resize Gridview Width Property (NOT Column Width) Hartman_Ralph@Hotmail.com Microsoft ASP .NET 0 2nd Jun 2009 04:59 PM
Change Cell Width WITHOUT changing Column width dww701 Microsoft Excel Misc 1 12th Jan 2009 10:52 PM
Create a macro which takes a column name and width and sets the column width to what it should be Ag Microsoft Excel Programming 4 29th Sep 2007 11:29 PM
sum of multiple columns width differs from single column width Sven Passig Microsoft Excel Programming 0 4th Feb 2004 10:16 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:46 AM.