Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I automatically adjust a column width
Hi
I have an order sheet and am using a V Lookup to pull through the data. Some of the data is say 10 characters and others 20 or more. Is it possible for Excel to size its either cell or column to reflect the largest or smallest set of characters. Otherwise some of the data is missing or the column is so big the text is missing? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I automatically adjust a column width
Double click the line to the right of the column header. So to make B
exactly the right width double click the line between B and C in the column header row Or select all columns to be fixed and use Format : Columns : AutoWidth best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "BABYPINK" wrote in message ... Hi I have an order sheet and am using a V Lookup to pull through the data. Some of the data is say 10 characters and others 20 or more. Is it possible for Excel to size its either cell or column to reflect the largest or smallest set of characters. Otherwise some of the data is missing or the column is so big the text is missing? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I automatically adjust a column width
Select the columns. From menu FormatColumnAutofit selection
OR Once you select the columns double click on the column header. When you bring th e cursor between header A and B; the cursor change to a cross.. Double click then If this post helps click Yes --------------- Jacob Skaria "BABYPINK" wrote: Hi I have an order sheet and am using a V Lookup to pull through the data. Some of the data is say 10 characters and others 20 or more. Is it possible for Excel to size its either cell or column to reflect the largest or smallest set of characters. Otherwise some of the data is missing or the column is so big the text is missing? Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I automatically adjust a column width
"BABYPINK" wrote in message
... Hi I have an order sheet and am using a V Lookup to pull through the data. Some of the data is say 10 characters and others 20 or more. Is it possible for Excel to size its either cell or column to reflect the largest or smallest set of characters. Otherwise some of the data is missing or the column is so big the text is missing? Thanks See http://en.allexperts.com/q/Excel-105...lumn-Width.htm Haven't tried it myself but it sounds like what you are after HTH Chris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column Width: cannot adjust | Excel Discussion (Misc queries) | |||
column width will not adjust | Excel Worksheet Functions | |||
Adjust column width | Excel Discussion (Misc queries) | |||
Adjust Column Width? | Excel Discussion (Misc queries) | |||
adjust column width | Excel Discussion (Misc queries) |