Well, first of all, you can do all the color management you want on your end, but if your printers say things like “swop coated is fine” then your workflow is a deadend. It’s like ballroom dancing with a mannequin.

Second, you can’t get accurate proofs of many spot colors (e.g. many Pantone colors). It cannot be done on a desktop printer and isn’t worth worrying about. If you’re printing a CMYK job (such as on a digital press), then you want to use CMYK colors, not spot colors.

The key is to turn on “All Information” in the ‘when pasting text and tables’ section in the Clipboard Handling section of the Preferences dialog box.

However, then I think you may need to copy the info in Excel, paste into a new text frame in InDesign (where you’ll get a new table), and then copy from that table and paste into your original InDesign file.

Alternatively, if it’s a new table that you’re importing for the first time, you can turn on Show Import Options in the place dialog box, and then set it to Formatted Table or Formatted Only Once.

It’s for doing things like this: https://creativepro.com/setting-reversed-out-headline-text-white-on-a-black-bar.php

There is no easy solution for what you’re trying to do. Perhaps put each heading in its own text frame and then anchor those frames in the larger frame.

I see lines above and below the text. Are you trying to make it so the lines are only above the text? (currently it is across the whole paragraph?)

No, not automatically. You would have to create those footnotes yourself.

What do you mean by “paragraph 3”? Is that the name of the paragraph style?

You may be able to do this with a cross-reference instead of a table of contents… that is, you would build your TOC out of x-refs. But even that might not work.

I think number adjuster script is the only way I’ve seen. You’d can use a grep condition inside the script to limit it to the numbers you want to change.