different column size on the same sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

dear all,
if i have 2 table on the same worksheet, how do i make the column size different for the below table from the above table
example below, how to have wider column for address when i want the column size remain for sex? pls hel

name sex scor
winnie f
vincent m
terry m

dob address
20/5/1990 123, stamford road
30/1/1956 59, united road
 
One way: move the cursor to the top of the column. It
should change to a double arrow - click and drag the line
to the size you want.

Another way is to place your cursor at the top of the
column again and double click. This automatically sizes
the column to the largest column-cell entry. You can also
do this for a group of columns (highlight more then one
and double click at the top of any highlighted column).

Another way is to highlight the column, then right click
over the highlighted area, click on width, then enter the
column width you want for that column.

hth//

-----Original Message-----
dear all,
if i have 2 table on the same worksheet, how do i make
Click to expand...
the column size different for the below table from the
above table?
example below, how to have wider column for address when
Click to expand...
i want the column size remain for sex? pls help
 
If the tables are one below the other, you can't.

--

Vasant

ek said:
dear all,
if i have 2 table on the same worksheet, how do i make the column size
Click to expand...
different for the below table from the above table?
 
ozzie, they are on the same worksheet. i know to resize the column but what if i want different column size even they are sharing the same column as i have table one on top of another. that is my concern
 
You can't..

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

ek said:
ozzie, they are on the same worksheet. i know to resize the column but
Click to expand...
what if i want different column size even they are sharing the same column
as i have table one on top of another. that is my concern.
 
Back
Top