changing Size of a cell without affecting the others in the same column

  • Thread starter Thread starter Simon Lee
  • Start date Start date
S

Simon Lee

Dear All,
May I ask how can I change the size of some cells, let say
changin the width of A1 cell without affecting the one
below it (A2).

Or if that's not feasible.

can I create a table like sheet that could cover on some
part of the existing worksheet to "archieve" a similar
effect(i.e Changing the size of one cell without affecting
the one below it.)

Thanks so much for your kindly help again.

Cheers,
Simon Lee
 
You cannot do exactly what you want. A couple of workrounds :-

1. Use 2 or more columns instead of 1 so longer data spreads across the
width of all columns. Format the columns as 1 with borders and set
options to not show gridlines.

2. Use several columns as above and merge cells. I use the above method
in preference because merging cells has such unpredictable effects when
selecting columns etc.
 
Hi Simon

You can't change the width of A1 without also chaging the width of A2. Width
is a column function.

You can give an appearance of a wider cell however, by Fomatting.
Either Merge cells A1:B1 whilst leaving A2 and B2 unmerged Format
Cells=>Alignment=>Merge Cells
or mark A1:B1 and Format Cells=>Alignment=>Horizontal=>Center across
selection
 

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

Back
Top