Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Adjustments
If i want to adjust the space in in one or two cells how
can i do this if i don't want the whole column adjust just two rows? |
#2
|
|||
|
|||
Hi Andy
the only way to achieve this is to merge cells (select the cells and click on the merge & center icon on the toolbar or choose format / cells - alignment tab) however, it is not a good idea to do this as it can cause problems later with sorting & filtering etc ... Cheers JulieD "Andy" wrote in message ... If i want to adjust the space in in one or two cells how can i do this if i don't want the whole column adjust just two rows? |
#3
|
|||
|
|||
Column width is a property of the column, not individual cells.
You can merge cells, but that almost always starts the decline and fall of the worksheet as a usable instrument, as it adversely affects formatting, sorting, filtering, etc. If you want to center across two columns, select the columns, choose Format/Cells/Alignment and select "Center across selection" from the Horizontal alignment dropdown. In article , "Andy" wrote: If i want to adjust the space in in one or two cells how can i do this if i don't want the whole column adjust just two rows? |
#4
|
|||
|
|||
thanks works fine
-----Original Message----- Hi Andy the only way to achieve this is to merge cells (select the cells and click on the merge & center icon on the toolbar or choose format / cells - alignment tab) however, it is not a good idea to do this as it can cause problems later with sorting & filtering etc ... Cheers JulieD "Andy" wrote in message ... If i want to adjust the space in in one or two cells how can i do this if i don't want the whole column adjust just two rows? . |
#5
|
|||
|
|||
you're welcome and thanks for the feedback
wrote in message ... thanks works fine -----Original Message----- Hi Andy the only way to achieve this is to merge cells (select the cells and click on the merge & center icon on the toolbar or choose format / cells - alignment tab) however, it is not a good idea to do this as it can cause problems later with sorting & filtering etc ... Cheers JulieD "Andy" wrote in message ... If i want to adjust the space in in one or two cells how can i do this if i don't want the whole column adjust just two rows? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|