ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to make cell width different than the column width it lies in (https://www.excelbanter.com/excel-discussion-misc-queries/109432-how-make-cell-width-different-than-column-width-lies.html)

John

How to make cell width different than the column width it lies in
 
Is there any way to change the width of a cell, or a few cells, while keeping
all the other cells in the column the same width?

PCLIVE

How to make cell width different than the column width it lies in
 
You can only change row heights and column widths. Not individual cells.
However, you can merge cells to make them appear the way you want. Try
highlighting a couple of cells that you want to merge, and then right click
them. Select Format Cells. On the Alignment tab, check the box for Merge
cells.


"JOHN" wrote in message
...
Is there any way to change the width of a cell, or a few cells, while
keeping
all the other cells in the column the same width?




asyado

How to make cell width different than the column width it lies in
 
Hi,

I'm pretty sure that is not possible.
What do you intend to do with the "shortened" cells. is it for printing?
formatting?
an alternative would be to Merge two adjacent cells to form the "longer"
cells and leave the other cells as single cells. You could then change the
widths as needed.

John.

--
John


"JOHN" wrote:

Is there any way to change the width of a cell, or a few cells, while keeping
all the other cells in the column the same width?



All times are GMT +1. The time now is 05:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com