What should I do if there are too many words in an excel cell and it can t be fully displayed after

1) Auto-wrap rows within cells. Formatting--> Cells--> Alignment--> Wrap on the outline.

2) Double-click the edge line of the row header or column header as needed to automatically adjust the width and height of the row and column.

3) Print. File --> Page Setup --> Page --Adjust to 1 page width and 1 page height. (Or adjust the paper orientation, margins, etc. according to the actual situation).

Microsoft Office is the most popular office software, mainly in two versions: Office 2010 and Office 2007. Office 2000 is a representative product of the third generation of office processing software, which can be used as a platform for office and management to improve users' work efficiency and decision-making ability. Office 2000 Chinese Edition is available in 4 different versions:

Standard Edition, Small and Medium Business Edition, Chinese Professional Edition, and Enterprise Edition.

In Office 2000, there is still a relatively clear division of labor among various components: generally speaking, Word is mainly used for text input, typesetting, printing and other work; Excel is mainly used for budgeting, finance, data aggregation and other work with heavy calculation tasks; PowerPoint is mainly used to make presentations, slides and slides, etc.; Access is a desktop database system and database application; Outlook is a desktop information management application; FrontPage is primarily used to create and publish web pages on the Internet.

Microsoft Office XP is the most important version of Office that Microsoft has ever released, and it is considered to be the most powerful and easy-to-use Office product to date. The new version of Office has abandoned the old convention of naming the product after the year of the release! XP in the product name is the abbreviation of "Experience" in English, which means that the new version of Office will bring users a rich and fully expanded new experience after embracing web services covering a wide range of devices.

In addition to the core Office XP programs—Microsoft Word, Excel, Outlook, and PowerPoint—Office XP Professional includes Microsoft Access 2002, an Office XP database solution that helps users store, access, and analyze data.

Cell formatting – word wrap or print after shrinking font fill.

Because Microsoft Office adopts the "what you see is what you get" mode, you can't see what you can't see and can't print, unless there are a few error values, you can set it to print blank or not print in File - Print - Options - Error Value Printing Method.

Open the excel document you want to print, and click "File --> Print";

Under the Settings bar, click the small arrow next to No Scaling; Select "Resize Worksheet to One Page" from the drop-down menu

So that we can open the full ** on the same page.

In the print preview window, we can see the page setup in general. Sometimes a slight adjustment is required, and we usually click on "Page Setup" to do so.

Actually, there's an easier way to do it: drag and drop the mouse to adjust the settings.

Click the "Show Margins" button at the bottom right of the preview window;

Some gray lines and black nodes will appear in the preview window, and you can easily adjust the settings of the page by dragging them with the mouse.

If you can't display a fully stretched cell, you can stretch it up and down, and you can stretch it left and right.

The key combination "Alt+Enter" can force a line break, and you can see the text in the cell to wrap the line.

First, open Excel**.

program, you can see that at this time, the number of words entered in excel** is too much, and the display is incomplete.

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

3. Then, select "Align Tab" in the window and click to open.

4. Then, check "Word Wrap" in the window and click to open.

5. Finally, adjust the height of the cell, and the cell can display all the contents, and the problem will be solved.

1. Open the content in the excel cell is too long, but you don't want it to display all the content.

2. Left-click the first cell.

3. Right-click, a drop-down box appears, move to Set Cell Formatting.

4. Move to the alignment option at the top of the pop-up window.

5. Move to horizontal alignment.

6. Select the filling option.

7. Click Confirm in the lower right corner to get into the hole.

8. At this time, the text beyond the cell will be hidden, and when you double-click the cell, all the text content will be displayed.

2.In the Start menu, find "Wrap Cells" and select it to make the contents of the cell wrap automatically;

3.Then you can adjust the column width to make the content all displayed in a cell, and then print after the display is complete, and you can print it completely;

5.In the Start menu, find "Merge Centered" and select it;

6.Adjusting the row height can also make the contents of the cell display complete.

Thanks for the invite. If I don't have a computer at hand, I won't make a presentation. Quite simply, three ways:

2. Set cell formatting-alignment-auto-shrink filling. Does not affect the print area.

3. Set this cell to wrap automatically, and then adjust the row height.

1.Select the cells that need to be set.

Start "--Cell" --Format "--Automatically adjust row height".

2.If you want to merge cells, you want to adjust the row height, manually adjust them one by one if there are fewer rows, and use VBA if there are many rows.

1. Automatically adjust row height and column width.

2. Change the printing direction to landscape.

3. It is recommended to change the word for the cell text, and the text in the excel cell is limited by the number of words.

Above, I hope it can help you.

Preview it before printing, and you can see the printing effect, and then adjust it if you don't have all of it. Incomplete printing should be that the cells are not large enough.

You can set the line wrap (alt+enter) and adjust it to the appropriate line height and column width! Then print and preview the effect.

Set to automatically adjust the row number column width! Or manually increase the width of the row number.

You can set the cell content to scale with the cell size.

So that everything is displayed, or set up word wrapping. Reduce the font size appropriately.

Hello. Please format the cells: reduce the font fill.

This problem is caused by enabling the display of page breaks, which can be fixed by correcting it. The steps are as follows:

1. Select the tool menu directly in the main interface of excel to enter.

2. If it's okay, continue to find the icon button and click Jump.

4. In this way, the cell text printing will be restored to normal, and the requirements can be realized.

Idea: Adaptive line height - add a fixed size to the adapted line height to avoid cell edges pressing the text.

Step 1: Select the region to be modified in WPS. (Start in Office Word --Cells--Formatting--Automatically adjust line heights" - proceed to the fourth step).

Step 2: Select "Word Wrap".

Step 3: Select the most suitable row height in "Rows and Columns", at this time, each "row height" is different according to the number of Chinese characters in the cell. On top of that, proceed to the fourth step.

Step 5: Find "Set Row Height and Column Width" in the numeric value.

Step 6: On the basis of the first step, because each row of cells has been adjusted to a suitable height, in order to make the text have a certain distance from the cell edge, you can add a fixed size on the basis of "the most suitable line height", which can avoid the cell edge line pressing the text of the cell.

Step 7: Set the column width as above.

Excel, the display is incomplete, is caused by the content and line height does not match, sometimes can be displayed normally, but in the printing is beyond the border, although manually adjust the line height and column width, do not use automatic adjustment, in addition to reduce the font size.

This requires manual adjustment of the row height, leaving a margin for each row, as is the case with some versions of the operating system.

I encountered a similar situation, and I couldn't find a solution after searching for an hour on the Internet, and finally came up with it myself,—— increasing the line height. The page view can see the full text, and the print preview and print are that there is a line that only prints half of the text.

Right-click the selected cell to set the cell, and check the line wrap automatically. Just adjust the spacing yourself!

Before printing, you can do a print preview and check it first.

I encountered this problem just now, and I was able to solve it after consulting the big guy.

First of all, arrange everything in your formatting, and it's a good idea to set the "Zoom" of the "Page Setup" to "1 page width".

Finally, double-clicking on the divider between each column will automatically adjust to the appropriate width. If it becomes extremely wide, cancel the word wrap for the whole table and set the word wrap again.

Because, when exporting and printing to a PDF printer, the default column width may not be covered, and after double-clicking, it is really printed according to this column width, which is to automatically zoom the cell to the content coverage.

Hope it can help you and others who encounter this problem in the future.

I just encountered this problem, there is no solution on the Internet, I studied it for a noon, it should be the problem of EXL printing and typesetting, and the screen shows that.

This is true when printing and previewing.

You can do this by selecting Page Layout under the View menu.

The page you see under this layout is the same as what is printed.,At this time, you can follow the regular operation.,Select all automatic line height on OK.,I'm using EXL2010.,Other versions haven't been tried.,It should also be OK.。

Sets the edge to flow out of a certain gap.