ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Column fixed width (https://www.excelbanter.com/excel-discussion-misc-queries/173224-column-fixed-width.html)

juanpablo

Column fixed width
 
Hello,

Im currently inserting each day, several information copied from a web page,
in sort of columns.
But every time i paste, the text does not fit and I have to adjust the widht
of some columns.
Can I fix the width of this specific columns.

Thanks

JP

Hole Alex

Column fixed width
 
Hi,
You can set specific widths for the columns,

If you highlight the column that you wish to set the width. Then right click
and go to column width. Then enter your desired width.
Alternatively you can double click the divider at the top and it will snap
to maximum required width for the information stored in that column.

Is that what you meant? Or did you want to restrict the amount of characters
in a cell?

Alex




"juanpablo" wrote:

Hello,

Im currently inserting each day, several information copied from a web page,
in sort of columns.
But every time i paste, the text does not fit and I have to adjust the widht
of some columns.
Can I fix the width of this specific columns.

Thanks

JP



All times are GMT +1. The time now is 08:22 PM.

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