ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Cell padding (https://www.excelbanter.com/excel-discussion-misc-queries/250052-cell-padding.html)

Jennifer

Cell padding
 
I have a worksheet with multiple row heights. When I do autofit some of the
words are being cutoff in the rows. How can I adjust to a little extra space
in each cell without manually adjusting each row?

trip_to_tokyo[_3_]

Cell padding
 
I'm assuming that the words are being cut off from left to right (not top to
bottom) - I am not sure from you posting.

If the above is the case, in EXCEL 2007, try the following:-

- click in the cell to the left of column A and above row 1

- this will highlight the whole Worksheet

- then double click the line between the A and the B column headings

The above will cause all cells to be correctly aligned (show all the data)
from left to right.

If my comments have helped please hit Yes.

"Jennifer" wrote:

I have a worksheet with multiple row heights. When I do autofit some of the
words are being cutoff in the rows. How can I adjust to a little extra space
in each cell without manually adjusting each row?



All times are GMT +1. The time now is 05:12 PM.

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