Ask Your Question

Odd Insert Row problem [closed]

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 reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-11 14:55:55.622422


show your file, please

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

Are the images anchored in cells?

Schiavinatto gravatar imageSchiavinatto ( 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

Question Tools

1 follower


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

Seen: 170 times

Last updated: Jun 01 '18