Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Cells Fixed height and width

I want to be able to create a table that has "fill in the blank" cells with
permanent width and height (Form). The problem I am having is that I copied
and pasted it in MS Word and everytime you fill out any of the requested
info, the whole table moves changing the width and height of the cells. I
want to be able to lock some cells and allow users to fill in the information
I am asking for but want the margins and cell dimensions to remain at the
original size.
Example. In one cell I ask for the Designer's name (Designer:) When I
protect the document the users should be able to enter their names and if the
name is too long the text should shrink to fit the text, but it doesn't and
it disarranges the other cells and changes the height and width of the cell
where you typing the designer's name.
Sorry for the long question. Just want to be able to create a form in excel
that remains with the original dimensions whenever you "fill in the blanks".
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 69
Default Cells Fixed height and width

Not sure if you want the form in Excel or Word. They are different animals
when it comes to forms. If you want it in Word, create a table that has one
cell for the word Name, and another cell for the fill-in. That will prevent
the cell drift. When I design forms, I keep them in their Excel format - far
better results than a Word form.

Carole O

"Rayelle" wrote:

I want to be able to create a table that has "fill in the blank" cells with
permanent width and height (Form). The problem I am having is that I copied
and pasted it in MS Word and everytime you fill out any of the requested
info, the whole table moves changing the width and height of the cells. I
want to be able to lock some cells and allow users to fill in the information
I am asking for but want the margins and cell dimensions to remain at the
original size.
Example. In one cell I ask for the Designer's name (Designer:) When I
protect the document the users should be able to enter their names and if the
name is too long the text should shrink to fit the text, but it doesn't and
it disarranges the other cells and changes the height and width of the cell
where you typing the designer's name.
Sorry for the long question. Just want to be able to create a form in excel
that remains with the original dimensions whenever you "fill in the blanks".

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
Cells with wrapped text won't auto-adjust row height correctly [email protected] Excel Discussion (Misc queries) 2 December 12th 06 05:40 AM
Resize individual cells w/o changing the entire column width Mary Ann Excel Discussion (Misc queries) 3 April 28th 06 04:39 PM
cell width and height Brian Brandt New Users to Excel 3 February 14th 06 10:57 AM
how can I print a sheet without the height & width being adjusted pb Excel Discussion (Misc queries) 1 December 5th 05 03:56 PM
Displaying column width and row height swirlygirl Excel Worksheet Functions 3 February 7th 05 09:53 PM


All times are GMT +1. The time now is 11:38 PM.

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

About Us

"It's about Microsoft Excel"