Why is the content of the two vertical boxes on the left of Excele not neatly typeset???? What is th

This is a copy-pasted text with the original file format, just delete it and re-type.

Select ** first, then click on the cell in the format, click "align" in that direction and "text" in black. Then do it according to your own needs.

Select ** first, right-click to copy, open another worksheet, right-click, paste special, click Transpose, OK.

Copy the content you want to typeset, right-click, paste special, and select [Transpose] OK.

Open the excel file, drag and select the vertical column data, right-click and copy.

After selecting a cell, right-click "Paste Special" and tick "Invert" to confirm.

Delete the original content and reformat.

There is a drawing, it is more convenient to draw a few rows or columns, and the grid is small and you can drag and drop.

Then you can use WPSOFFICE to simply insert Excel**.

Insert ** directly, a few rows and columns are you can choose, and you can typeset them after you choose.

You can use nesting, which is nesting. Depending on how many of these small ** you want to make, how many in a row and how many in a column are made on the outside, and then paste your small ** into the big **.

You can do it in Excel and import it in Word.

In "File" and "Page Setup", set the paper size, horizontal or portrait, and set the margins.

Adjust the row height and column width of **, and see the layout effect through the preview function.

1. First of all, we find excel**.

2. Double-click to open.

<>4. We select all the cells where the course is located, and right-click at the same time to select Format Cells.

5. In the pop-up checkbox, we select it, select the center in the horizontal and vertical, click the vertical text on the right, and OK.

6. Finally, we can see that the courses in the curriculum have changed from horizontal to vertical.

Select the area, right-click - format the cell, select Align in the pop-up form, and click on the vertical bar text in the direction.

Note: Do not select 2 rows, but select the areas that need to be processed in these two rows.

Mine is office2010 first format the cells, dot the label "align" and there is a direction selection on the right. As for the font, you select the text you want and choose the size.

This data is a line marker, and the font size will not change, so it must be that your display scale has been reduced, so it looks small. You can leave it alone. Press the Ctrl key and scroll the mouse wheel forward to increase the display scale and enlarge the line mark number.

Press the ATRL key and the mouse wheel to scroll up to zoom in**, scroll down to zoom out**.

You try to see if that's the reason.

Or select the --- view in **--- display scale is 100%.

There are two possibilities that come to mind, one is that the data has been deleted, and the other is that the color of the font is set to colorless. In the second case, you can see it by setting the font to black in the unit cell format.

2003 version, tools->options->conventional-> standard font to choose the font size larger;

2007 Edition, Start (top left) - > excel options - > regular - > the font size of the standard font.

First, open the excel** program, and see the cell numbers in the excel cell.

2. Then, right-click the cell in the selection, select "Format Cell" in the right-click menu, and click to open.

3. Then, select "Text" in the dialog box and click to enter.

Fourth, finally, you can see that the cell numbers in Excel** are displayed normally, and the problem is solved.

This situation will occur because the input word is too long, to select the cell - right-click the mouse "Format Cell" - under "Number" - Special - OK on it.

Or double-click the ** you want to enter in the excel sheet, and enter the number you want to enter, so you can also do it.

In this way, you can directly type the numbers, including the ID number.

This is because if you enter more than 11 digits in numerical format data in Excel, it will automatically become a scientific notation method.

If you want numbers to display as all numbers instead of scientific notation, you need to store them in text format in two ways:

Before entering a number, enter a single quotation mark', enter the numbers, and all the numbers will be displayed;

First set the format of the cell that needs to enter the number to text, and then enter the number, and all the numbers will be displayed;

It's best to open 'Print Preview', click 'Margin' on the page, show the hidden margin lines, and then adjust the position of the margin lines, and it's OK. You can see the diagram below.

Click Menu: View - pagination preview, use the mouse to pull the dotted line to the appropriate position. If it is difficult to find the right position, you can pull the horizontal dotted line to the bottom, and the vertical dashed line to the far left, and then click the menu: File - Page Settings, Zoom - Scale - The scale is set to 100.

There's no setting. Preview - Margins can be set --- manually adjusted borders.

Set it in the print preview area, as long as you can preview it, you can print it, if you can't get it, send it to me to get it for you.

Excel text vertical method, haha, I seem to have worked it out.

Take the text "My Research" as an example:

1.Vertical text: Select an excel cell, select "Format Cells - Align", click the vertical "text" under "Direction" to make it a black shading state, "OK", enter "My Research" in the cell, and the text will be vertical.

2.Multi-column vertical arrangement: In the vertical text "My Research" cell just completed, move the mouse above the word "I", and then press alt+enter, you can add a new vertical column to the right of the cell; If you move the mouse below the word "research" and press alt+enter, you can add a new vertical row to the left of the cell.

I've also been thinking about the vertical row, thank you for sharing!

If you want to enter two columns of vertical text in a color table cell, it is actually very simple, we have the corresponding text sorting direction in the function bar, if we want to use it according to our needs, then first check, we ask to enter the vertical text cell, and then directly click on the function bar text sorting direction, and then select the vertical layout, in this way, the text we input will be automatically converted into vertical text in the cell, therefore, this is very convenient, Or we can directly enter the text first, then select the cell, and then directly right-click the property to find the text sorting direction.

If you want to reflect this operation in **, it is recommended that you make **** in the world document to format the text more conveniently.

1. Right-click the cell.

2. Select "Format Cells".

3. Select the "Align" tab.

4. Select "Direction" (vertical) on the right

5. Enter the text, when the text in the first vertical row is finished, press "Alt+Enter" before entering the second vertical row

There is an "Align" window in the formatting of cells, and the "Direction" can be adjusted.

Right-click - format cells - align (click on the text) to enter the text, alt+enter to switch columns.

Place the cursor in front of the text, alt+enter, and the word will go to the next line.