How to change the page orientation in Excel

To be office excel advanced, you could learn how to use WPS Office Spreadsheets online in WPS Academy.When we need to print, it happens that the table is display incompletely. At this time, we need to manually change the page orientation. 1. Head to the Home tab > Print Preview, where you can find this table is incompletely in one page because of its landscape orientation 2. To change its orientation, click Portrait, then the table is changed from the landscape to portrait orientation....

How to hide page breaks in Excel?

1. Click Menu > Options > View.2. In the view area, uncheck Page breaks. Then click OK. To be office specialists, you could learn how to use WPS Office online in WPS Academy.

How to insert header and footer in Excel？

To make a table normative, we can insert header and footer when printing. The methods of header and footer are the same, so here we take header as an example. Here are the steps.1. Open your Excel document, click Menu > Print > Print Preview to enter the print preview mode. 2. Click Header and Footer on the toolbar to pop up a dialog. 3. We can select a built-in header from the drop-down menu. And check Different odd and even pages and Different first page according to actual needs. 4....

How to compare two excel sheets side by side

· Option 1:1. Open two Excel files respectively.2. Click the View tab → the Arrange All button → Vertical Text Box.3. Then, two sheets will appear side by side.4. By sliding the scroll bar of each table up and down, we can compare data in these two tables. · Option 2:1. Open two Excel files respectively.2. Click the View tab → the View Side by Side button. Then, the two tables will appear side by side.3. At this point, the Synchronous Scrolling button is grayed out. The two sheets can ....

How to show or hide gridlines in Excel

· Show gridlinesOption 1:1. Click the View tab.2. Check the View Gridlines option. Option 2:1. Click the Menu drop-down list in the upper left corner and click Options.2. In the pop-up dialog, click the View tab, and check Gridlines in the Window options area.3. Click the OK button. · Hide gridlinesOption 1:1. Click the View tab.2. Uncheck the View Gridlines option. Option 2:1. Click the Menu drop-down list in the upper left corner and click Options.2. In the pop-up dialog, click the V....

How to delete background in WPS spreadsheet?

Open the table in WPS Office. Click Page Layout → Delete background. WPS office software could be compatible with Microsoft Office, and these training contents help students or home workers finish their work efficiently.

How to print the entire worksheet on one page?

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. Sometimes, it is annoyingly to find that a printed page is can only accommodate a few columns of data. Today we will learn how to print the entire worksheet on one page and it's easy to grasp.1. Open your worksheet in WPS spreadsheets.2. After clicking Print Review, we will find several columns of the table have disappeared. 3. To solve this, you c....

How to change background color of cells

1. Select a cell range. 2. Get to the Home tab → click the Fill Color icon (a paint buckets-looked icon) → choose a color in your preference. You can also fill multiple separated cells with one click.1. Long-press Ctrl on the keyboard → select the cells one by one with your mouse → release Ctrl when you finish the cell selection.2. Click the Home tab → the Fill Color icon (a paint buckets-looked icon) → choose a color in your preference. To be office excel advanced, you could learn how....