Excel - Expand overflow text vertically without changing cell, row, or column sizes.

Anonymous
2020-04-28T19:04:55+00:00

As simply as I can put it... I'd like to expand the overflow text from one cell to not only extend horizontally, as it automatically does, but also vertically without changing the size of any rows or columns. Is this possible?

When I type in a cell, the text continues to the right and over the next few cells without changing their configuration. As if its a ghost text hovering above. In order not to mess up the structure of the worksheet, I'd like to see overflow text from one cell lay on top of empty cells to the right and below. Is there a way to trigger a line break in overflow text in order to see the text extend to the right on top of cells and also continue downward on top over lower cells while keep the size of surrounding rows and columns the same?

The closets solution I have found is to first select multiple vertical cells, merge those cells, wrap text, then adjust the width of the column. This however changes the overall structure of the surrounding cells/column. 

Thanks in advance!

Windows 10

Office/Microsoft 365 Personal - Excel

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
{count} votes
Answer accepted by question author
  1. HansV 462.4K Reputation points MVP Volunteer Moderator
    2020-04-28T20:13:47+00:00

    No, that is not possible.

    8 people found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful