Ask Your Question

Odd Insert Row problem

asked 2018-05-29 01:14:40 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Have a spreadsheet that I'm filling out data, and pictures in - but no formulas. When I go to add an extra row between two filled out rows, only the first box moves. This happens if the extra row is added above, or below the filled out row. If the row is empty, insert row works as expected. I can't copy paste rows because of this.

Not seeing anything in help about any sort of insert configurations, or something that I ought to be doing different.

This really is hampering my ability to edit the spreadsheet.

Currently running 6.04.2 (x64)

edit retag flag offensive close merge delete


show your file, please

kompilainenn gravatar imagekompilainenn ( 2018-05-29 10:00:44 +0200 )edit

Are the images anchored in cells?

Gilberto Schiavinatto gravatar imageGilberto Schiavinatto ( 2018-06-01 00:50:22 +0200 )edit

I don't think so, but I'll look. do they need to be?

tmnathe gravatar imagetmnathe ( 2018-06-02 20:25:37 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-06-01 12:14:00 +0200

hjek gravatar image

Select all the images (Hold Shift and left click on them), then right click on an image, click Anchor -> To Cell. Now, if you insert rows above the images, they will move down as well.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-05-29 01:14:40 +0200

Seen: 65 times

Last updated: Jun 01 '18