Fixing the width of a column

D

Daniel

Hi all

I have Excel 2002 SP3
is it possible to fix the width of all the columns
in a spread sheet?

thanks

Daniel
 
D

Daniel

Anne

thanks for the link, it was not quite what I wanted but
it put me on track to work it out and of course
I learned something.

thanks

Daniel
 
D

David McRitchie

Hi Daniel,
Well what exactly were you looking for.
Same applies to rows as well (autofit rows)

It is easier for me to use Ctrl+A (if you have Excel 2003 use Ctrl+Shift+SpaceBar)
then double click on the boundary between the column headers (A-B-C) or between the
row headers (1-2-3).

If you want cells to wrap within a cell use Format, cells, align (tab), wrap cells.

There is a problem with using AutoFit if you have merged cells.
There is a problem with using AutoFit in that once you've used it
you have overridden automatic and will have us it for that worksheet from that
point on. There is a macro to reset it back.
 
A

Anne Troy

Dave: I wondered the same thing myself, and then decided he wanted to set
all columns to a specific width.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


David McRitchie said:
Hi Daniel,
Well what exactly were you looking for.
Same applies to rows as well (autofit rows)

It is easier for me to use Ctrl+A (if you have Excel 2003 use Ctrl+Shift+SpaceBar)
then double click on the boundary between the column headers (A-B-C) or between the
row headers (1-2-3).

If you want cells to wrap within a cell use Format, cells, align (tab), wrap cells.

There is a problem with using AutoFit if you have merged cells.
There is a problem with using AutoFit in that once you've used it
you have overridden automatic and will have us it for that worksheet from that
point on. There is a macro to reset it back.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm


Anne

thanks for the link, it was not quite what I wanted but
it put me on track to work it out and of course
I learned something.

thanks

Daniel
Click to expand...
Click to expand...
 
D

Daniel

Anne

that's correct, and I was able to do so
once I played around in the Format>Column
area, which I did not realise was there,
having only used Format>Cells before.

thanks again

Daniel
Anne Troy said:
Dave: I wondered the same thing myself, and then decided he wanted to set
all columns to a specific width.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


David McRitchie said:
Hi Daniel,
Well what exactly were you looking for.
Same applies to rows as well (autofit rows)

It is easier for me to use Ctrl+A (if you have Excel 2003 use Ctrl+Shift+SpaceBar)
then double click on the boundary between the column headers (A-B-C) or between the
row headers (1-2-3).

If you want cells to wrap within a cell use Format, cells, align (tab), wrap cells.

There is a problem with using AutoFit if you have merged cells.
There is a problem with using AutoFit in that once you've used it
you have overridden automatic and will have us it for that worksheet from that
point on. There is a macro to reset it back.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm


Anne

thanks for the link, it was not quite what I wanted but
it put me on track to work it out and of course
I learned something.

thanks

Daniel
Try this:
http://www.officearticles.com/excel/fix_width_of_all_columns_or_rows_in_microsoft_excel.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


Hi all

I have Excel 2002 SP3
is it possible to fix the width of all the columns
in a spread sheet?

thanks

Daniel
Click to expand...
Click to expand...
Click to expand...
 
Top