Hi, I would like to know of suggestions that can make pasting spreadsheet data more useable. I was pasting data from PayPal and my bank and it seems to layout in a way that is not optimum. I then changed the column sizes to better fit. It still is not the way I would want it to be. Can someone advise me on the following: How can you make the data hide it self when wider and taller than the cell you are pasting into? How can I make the data (that does not fit) show in a tooltip when hovering over? If the second is very complicated I would leave for now and deal with just getting data to layout neat, and focus on parts I need to see now like amount. I would like it when I paste data to the typical cell size in Excel it does not resize the cell, I would than resize the ones that I want to see. Thanks
http://pctechtv.com/forumpic/mrexcel/rowsize/ExcelRowSize.jpg
http://pctechtv.com/forumpic/mrexcel/rowsize/ExcelRowSize.jpg
