ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Viewing number of characters in cells (https://www.excelbanter.com/excel-discussion-misc-queries/130276-viewing-number-characters-cells.html)

falcios

Viewing number of characters in cells
 
I type a lot of information in the cells of my spreadsheets. They overlap to
the next cell and I don't know where the next empty cell is. I want all the
information on one line not word wrapped.
Is there a way in excel to get around this?
Thanks.


Mike

Viewing number of characters in cells
 
Format cell and un=check word wrap. Double-click the right hand edge of the
cell with the data in and it will autofit to the correct width.

"falcios" wrote:

I type a lot of information in the cells of my spreadsheets. They overlap to
the next cell and I don't know where the next empty cell is. I want all the
information on one line not word wrapped.
Is there a way in excel to get around this?
Thanks.


canudeep

Viewing number of characters in cells
 
Try to increase the size of the cell.

"falcios" wrote:

I type a lot of information in the cells of my spreadsheets. They overlap to
the next cell and I don't know where the next empty cell is. I want all the
information on one line not word wrapped.
Is there a way in excel to get around this?
Thanks.


falcios

Viewing number of characters in cells
 
I want to be able to see all the columns. When I autofit I can't view all
columns.

"canudeep" wrote:

Try to increase the size of the cell.

"falcios" wrote:

I type a lot of information in the cells of my spreadsheets. They overlap to
the next cell and I don't know where the next empty cell is. I want all the
information on one line not word wrapped.
Is there a way in excel to get around this?
Thanks.


Mike

Viewing number of characters in cells
 
Then reduce from 100% to the limit that you are able to read.

"falcios" wrote:

I want to be able to see all the columns. When I autofit I can't view all
columns.

"canudeep" wrote:

Try to increase the size of the cell.

"falcios" wrote:

I type a lot of information in the cells of my spreadsheets. They overlap to
the next cell and I don't know where the next empty cell is. I want all the
information on one line not word wrapped.
Is there a way in excel to get around this?
Thanks.



All times are GMT +1. The time now is 03:44 AM.

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