Some people have suggested putting a space in the next cell. Each of those solutions can mess up the layout of your sheet. Of course, you can make the column wider or turn on text wrapping, but you might not want to. How can you prevent a cell's contents from overflowing into the next cell? I am posting this solution for anybody still struggling with this.

I saw two threads in this forum that asked this question, with no good answer. Thanks a million and warm regards ::: Jack Just in case of excel formula, which we copy and paste, Can I get a command by virtue of which the column titled Photo or column next to it gets automatically Hyperlinked to respective photo WHEN I copy and paste such command to all cells in that column. I have to do this hyperlinking one by one and if there 1000 photos, lot of time is wasted. In order to hyperlink one has to select that particular Cell, press Ctrl K and you automatically go to the folder containing individual photographs, you select that photo and OK. In the Excel file, in last column, I have given the respective serial numbers.

While scanning the photographs, I have saved them serially i.e. In the same folder where I have saved this excel file, are lying photographs of individuals. The last column is for hyperlinking photographs of individuals. I have an MS Excel File (2007 version) sample file attached, which has name, designation, blood group and so on.

Am in need for this solution very badly and what could be a better place than excelforum !

Excel analysis toolpak in french