WHAT TO DO IF THERE IS ONLY ONE LINE ON A PAGE WHEN EXCEL IS PRINTED

Before processing the data, you should first observe the patterns of the data and determine how to split it to achieve your desired goals. As shown below, you need to separate the city, district, and district, and the data in the cell are separated by comma",", as long as the comma is replaced with the dividing line.

It was naturally divided into 3 columns.

You can use a separator for this table.

Splitting method, the specific steps are as follows:

Click Column A to be split.

Opens the Column Wizard window.

Select the Delimiter and click the Next button.

Select the [Comma] and click the [Next] button.

The default data format is "General", click Done

Note: The default separators of the system are all symbols in the state of English input method, when the source data is Chinese characters or Chinese punctuation marks, you need to enter them manually in other columns, such as the following can be separated by "part".

2. Split according to fixed width.

When the source data does not have a unified symbol or text, you cannot use a separator to split it. For example, to extract the date of birth on the ID number:

Box select the cells in column b that need to be split.

Opens the Column Wizard window.

Select Fixed Width and click the Next button.

In the data preview area, click Add Data Divider and click Next.

You can select "Do not import this column" for the first 6 digits (select this option if you don't need to display it), select the "Date" format for the date of birth, and select "Don't import this column" for the last 4 digits (select this option when you don't need to display it), and click [Done].

One More Thing—"Ctrl+E" or right-click and drag down to quickly fill.

Method 1: Enter what you need to get in the first cell, press the shortcut key.

Ctrl+E for quick filling, you can automatically fill in the required content later;

Method 2: Enter the content you need to get in the first cell, put the mouse in the lower right corner of the cell until it is displayed as a solid + sign, drag it down, select Quick Fill, and then you can automatically fill in the content you need later.

This method is suitable for data with the same format or common rules, such as replacing the 4th to 7th digits of an 11-digit mobile phone number with an * number to extract the digits in the text and number mixture, and using Quick Fill can avoid repeated operations according to the same rules.

Such extracted fields can also be manipulated using functions (such as left, right, mid, etc.).

Click View to pagination preview.

Then CRTL+A selects all the contents of Excel, right-clicks on the stand-alone mouse to reset all page breaks, and then you can see if it will not be a page by line.

This may be caused by the setting of the print area.

From the page view, unset the print locale and try it.

The steps are as follows: the tools we need are: computer, office20161, first open excel, enter the "Page Layout" in the upper menu bar, and find the "Print Title" option.

2. Then in the "Page Setup" tab, click the button on the right side and select the header line area you want to print.

3. Press CTRL+P to enter the print settings, you can see in the print preview, there is a first line on each page when printing, and the setting is completed.

In the page layout, the hash is set to print the title and the macro cavity.

Tool: Excel 2010 version.

1. To print the first line on each page, click "Page Layout" at the top of the page;

2. Under the page layout menu bar, click "Print Title";

3. In the pop-up page setup box, click the worksheet column, select the area you want to print in the printing area, select the first row in the top title row of the mask under the print title, and then click the print preview below;

4. You will see that the first line of each page to be printed is the title line in the print preview interface.

Reason: 1. If the printing range is set, only the pages with the set range will be printed when printing.

2. The current page number is set to print when printing.

Solution: Method 1:

1. Click the "Page Layout" of the source guess on the Excel page, and click "Print Area".

2. Select the option of "Cancel Print Area" and then print it.

Method 2: 1. Click the "Print" button in the upper right corner of the excel page.

2. Enter the print settings page, and change the original "page number range" from "1 to 1" to "all".

3. Change the option in "Print Content" to "Entire Workbook", and click OK.

Summary. Here's how to solve it.

1. Find the ** that needs to be printed in the computer desktop, right-click, and open **.

2. After opening, find the page layout above the navigation bar and click the page layout to enter. 3. Then in the tab of the page layout, find the page settings, and click the print area above the page settings.

<> excel** has multiple pages, why can only the first page be printed.

Hello, dear, happy to answer your <>

Pro: This is caused by the print area that is set.

The solution is as follows: 1. Find the ** that needs to be printed in the computer desktop, right-click, and open **. 2. After opening the **Potato Boy Xun, find the page layout above the **navigation bar, and click the page layout to enter. 3. Then in the number tab of the page layout, find the page settings, and click the print area above the page Qi scatter settings.

There is a line in excel that cannot be printed because the print area is set, as long as the print area is canceled.

When using Excel, sometimes the layout and the preview page are different, that is, there is a lot of content, but only a part of the content can be previewed, and the same is true when it is printed. In fact, this is caused by setting the printing area, and you can cancel the printing area, and the specific method is as follows:

1. First of all, open an existing excel in a computer, and we can see that there are more than 40 lines of information in the figure.

2. Now we click on the print preview, and find that we can only see 30 lines of information when previewing, so even if we print it out, it is the same, there are only 30 lines of information.

3. Let's set it up in this order of operation: first click the page layout Print Area to cancel the print area.

4. Then click the preview again, and now we can see from the picture that the preview can be seen to be consistent with the original content of the layout.

5. Now that the preview is consistent, we can click Print OK to print the file, and the printed file will be exactly the same as our content.

Excel settings have a first row for each page when printing, which can be achieved by printing the header row.

The steps of the method are as follows:

1. Open the Excel** that needs to be operated, switch to the page layout tab, find and click "Print Title".

2. Click the text box behind the "top header line", then select **first line $1:$1, and click OK.

3. Return to Excel**, and you can find that the first line of each page is set in the print preview through CTRL+P.

1. Open the target file with the 2007 version of Excel software on the computer, and click the "File" option at the top.

2. Then in the drop-down menu that appears, click on the "Page Setup" option.

3. Then in the page that comes out, click the "Worksheet" button.

<>6. Return to the main interface and make sure, so that the first line of excel can be printed and displayed all the time.