ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Column/Cell Question (https://www.excelbanter.com/excel-discussion-misc-queries/200441-column-cell-question.html)

stacy

Column/Cell Question
 
I have my spreadsheet columns set to the width I want. My question is if I
type in the cell and it exceeds the width of the set column, how can I make
it automatically adjust?

Bob I

Column/Cell Question
 
Double click on the line between the column headers at the right of the
column with the long entry.

Stacy wrote:
I have my spreadsheet columns set to the width I want. My question is if I
type in the cell and it exceeds the width of the set column, how can I make
it automatically adjust?



Gord Dibben

Column/Cell Question
 
Adjust which way? Column wider or the row taller?

You can set the cells to "Wrap Text" and rows to "Autofit"

You could also set the columns to "Autofit Selection"


Gord Dibben MS Excel MVP

On Wed, 27 Aug 2008 10:40:05 -0700, Stacy
wrote:

I have my spreadsheet columns set to the width I want. My question is if I
type in the cell and it exceeds the width of the set column, how can I make
it automatically adjust?




All times are GMT +1. The time now is 04:18 PM.

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