changing cell width

S

steven

Ok here goes
I hope this can be done. (you folks haven't let me down
yet.)
I am making a work order, sheet that has an area to fill
in for
Work Request.
the discription could be quite lenghty. is there a way to
change the width and height of a cell in a column with out
changing the ones above it.
(I also will be locking the sheet so they can tab to the
areas they need to fill in. I know how to do this part )


Thanks in advance
steve
 
C

Chris Leonard

You can only do it using some VB and even then you can't change one cell
without changing the whole column or row unless you start looking at merging
cells which would be messy

Why not use a form ? (Excel 2000)

Chris
 
N

Narda

Sorry, but you cannot change the width or heighth of a
specific cell. Cell heighth and width is for the entire
column or row. You might try merging the cells needed to
accomodate the size you need.
 
S

steven

OK thanks
I'll take a look at the forms program and see what I can
come up with.
thanks again
steve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Table Preferred width is changed when pasting 1
External cell reference between two excel worksheets both in One Drive 0
Unclear change tracking process 0
Wrap text in cell 1
Visio 2016 - Single exterior wall with multiple thicknesses 1
Unable to set the desired column width for a table with merged cells 0
Unable to set the desired column width for a table with merged cells 0
Creating a template that I can reproduce every month by keying ininformation from SAP 8

Top