Selecting the last row, then extending the selection downwards, followed by Ctrl-D allows you to continue to data etc. down as far as you want. The ### output simply tells you the cells aren't wide enough to display their contents. You can widen the columns and/or make the font smaller to overcome that.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|