How to make data flow from one cell to next in Excel
Posted on 2014-12-10
I've been using Excel for years and this may not be possible. But I figured if it was, someone here would know how.
If it's not, I'd be interested in options.
I'm trying to create a simple receipt using Excel Invoice templates. We've tried several and even tried making one from scratch.
What we are wanting to do, is to have the description of an item drop down to the next line if it won't fit in the allotted space.
Qty (column) Description (column) Price (column)
If I start typing here when it
gets to the next line I want it
to drop down to the next cell.
We are familiar with word wrap, and that creates unexpected and unwanted behavior. It will kick all the cells down a line and this causes the invoice/receipt to create a second unwanted page.
We are using Excel 2010, if that makes any difference, on Windows 7 Pro systems.
Any and all help is appreciated.