How Excel Imports CorelDRAW

Too many friends are bothered by the form problem inside the CorelDRAW, the most common is the form obtained from MS Excel. The following methods are the simplest, easiest to understand, and most version-compatible scenarios that are found in the long-term practice, and look carefully:

1, now to the MS Excel table to the CD, direct copy of the required area;

2, on the CD proposal to open a new file, and then "paste selectively" just the content:

3, the proposed removal of all the text attributes for the next operation;

4, here is the key! You must choose the bottom of this, only things can be changed in the future;

5, ok! you should be able to see the form in the page, here is a schematic form, your table if in Excel more complex, will be the same turn over.

To facilitate editing, the following decomposition process is performed: Dissolve all objects;

6, Next, you want to separate all the table frame and text parts to different layers:

The question is, how do I select all of the table boxes? with "Find Replace" to complete, in the "Edit" menu;

Create a new lookup option and check the rectangle so that you can get out of all the table boxes.

7, with the selection of all, to select all the rectangles on the screen.

8. Open the Object Management Dock window and create a new layer 2

9, you can see in the Management window you select the rectangle is highlighted, now in the object management Docker with the mouse drag them to the new layer, the release will be preceded by an icon prompts:

10, OK, now the box and text parts completely separate on the different layers, editing is easy.

11, first to edit the text section, in order to avoid the interference of the box line, in the object management Docker in the table border of the layer point is not editable

12, can now arbitrarily select the entire row or any text box, change their font, size, color, alignment ...

13, and then turn off the editing properties of the text layer to modify the less good-looking box line:

14, the same simple can be the entire row of the entire column to modify the thickness of the box and the table fill color, it is easy!

Notice the outer frame of the entire table, at the bottom of the table box, to find it and set a different Benquan or color.