At 09:35 03/05/2020 +0200, Johnny Rosenberg wrote:
Let's say I have a spreadsheet (I actually have
several
) with a lot of cells and ranges already
filled with data and formulas. One day I
discover the range naming feature, so I name a
few cell ranges. Shouldn't there be some easy
way to
On Sunday, 3 May 2020 10:54:47 BST Robert Großkopf wrote:
> Hi Ian,
> >>
> >> you could try this:
> >> Change the TOC. It is protected against manual changes.
> > How do you change it if its protected other than update it? I couldn't find
> > how to "unprotect it"
>
> Right click with mouse on
Hi Ian,
> Thanks Robert. That allowed me to insert a page break but the new
> page had a background colour the same as the TOC and changing the
> style from "Contents Heading" to Default Style" wouldn't remove it.
Did you really press Alt + Enter two times?
The first break will be part of the
On Monday, 4 May 2020 09:28:02 BST Robert Großkopf wrote:
> Hi Ian,
>
> > Thanks Robert. That allowed me to insert a page break but the new
> > page had a background colour the same as the TOC and changing the
> > style from "Contents Heading" to Default Style" wouldn't remove it.
>
> Did you
