Ask Your Question

[SOLVED] Fill blank cells with value from above

asked 2020-07-26 19:21:49 +0100

zm23 gravatar image

updated 2020-07-27 11:43:51 +0100

Does Calc has such special option as there is in Excel (Go to special)?

I want to do exactly the same thing as on this tutorial:

Fill Blank Cells in Excel With Value from Above

Or maybe there is a function for this?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2020-07-26 21:14:01 +0100

JohnSUN gravatar image

You can done this with simple formula and Ctrl+Shift+V (Paste Special - Skip Empty Cells)


edit flag offensive delete link more


like that idea :-)

newbie-02 gravatar imagenewbie-02 ( 2020-07-26 22:08:03 +0100 )edit

Great. It works. One more question. It looks like you automatically filled column D and E with function. What was it? A shortcut or just a video is cut?

zm23 gravatar imagezm23 ( 2020-07-27 10:42:36 +0100 )edit

It's simple. Please note that in the video, the mouse cursor becomes a "cross". This happens when you hover over the lower-right corner of the selected cell (bold square dot). Double-clicking in this position works like "fill down to the end of the range". "End of range" is the end of a column of cells without gaps in the adjacent column (in the video it is column C)

JohnSUN gravatar imageJohnSUN ( 2020-07-27 10:54:35 +0100 )edit

Thank you very much.

zm23 gravatar imagezm23 ( 2020-07-27 11:44:39 +0100 )edit

And about your question. Yes, you can highlight blank cells in a range. This is very easy to do with a find regular expression ^$ (start of text - nothing - end of text). However, having received several selected ranges of empty cells, you will not be able to enter a formula in them in one motion. That is why I suggested using the formula in a free auxiliary range.

JohnSUN gravatar imageJohnSUN ( 2020-07-27 12:12:49 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-07-26 19:21:49 +0100

Seen: 394 times

Last updated: Jul 27 '20