Cancel method: First open the excel sheet that needs to be operated, click the "File" tab at the top of the page, select "Options"; then find "Display of this worksheet" in the pop-up "excel options" window Options" setting group; finally uncheck "Show page breaks".
The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.
First open the Excel table and click the "File" menu in the upper left corner
Next in the open drop-down menu, we click " Options" menu item.
The Excel options window will open. In the window, click the "Advanced" menu item in the left sidebar.
In the right window, find the "Display options for this worksheet" settings group, and you can see a "Display page breaks" setting item.
Remove the checkbox in front of this setting item, and finally click the OK button.
Related learning recommendations: excel tutorial
The above is the detailed content of How to cancel paging settings in excel table. For more information, please follow other related articles on the PHP Chinese website!