We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Autofill without changing format

asked 2018-10-31 12:57:35 +0200

student gravatar image

updated 2021-05-20 08:15:23 +0200

Alex Kemp gravatar image

Is there a way to Autofill a series of cells without changing the formatting of those cells? Specifically, I want to Autofill without changing the background colors of the cells. In Excel, you right drag the handle for the cells you want to fill, and when you release the click, you are given the option of filling without formatting. That doesn't work in Calc.

This question was already posted on https://forum.openoffice.org/en/forum... with the following answer:

Here's one way: Say we want to fill A1 into A2 though A17. Highlight A1 through A17, then Edit, Copy to save the formatting. Select A1 and drag the fill handle to A17. The formatting is lost but you can use Edit, Paste Special, uncheck all Selection options except Formats, OK and it will be restored. Hopefully someone has a more elegant way to do this.

The answer is from 2010 which works for me but is a bit annoying since it involves several steps. My question is, if there is a better, more elegant solution in 2018.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-10-31 13:07:37 +0200

SheetFill CellsSeries... is one way.

edit flag offensive delete link more


Thanks, but this doesn't seem to answer my question because 1. it influences the format of cells and 2. inserts only a series of numbers and is not equivalent to a "fill cell" operation (which for example inteligently fills formulas etc.)

student gravatar imagestudent ( 2018-11-01 15:15:08 +0200 )edit
Login/Signup to Answer

Question Tools



Asked: 2018-10-31 12:57:35 +0200

Seen: 1,130 times

Last updated: Oct 31 '18