How to quickly number rows in WPS Spreadsheet

After we open the spreadsheet in WPS, enter 1 in the first cell you want to number. Place the mouse cursor on the lower right corner of the next cell. When we see that the mouse cursor turns into a plus icon, just click and hold to drag down the cursor to automatically number rows according to our needs.To be an office excel advancers, you could learn how to use WPS Office Spreadsheet online in WPS Academy.

How to set a picture as the background

After we use WPS Office to open the slide, click the Design tab, and then click the Background button. We can find the Insert the picture drop-down button in the popup window on the right side. Then select File. We can choose the picture according to our needs here, and click the OK button to apply the picture in the slide.This skill could be compatible with Microsoft Office powerpoint.

How to start a slide show

After we use WPS Presentation to open the slide, click the Slide show tab. We can choose to start a slide show from whatever slide we want here. · From Beginning:· From Current Slide:By clicking the Play icon in the status bar below, we can start the slide show from the current slide quickly.We can also use the shortcut key F5 to start the slide show from the beginning and Shift+F5 to start from the current slide. This skill could be compatible with Microsoft Office powerpoint.

How to print a table in WPS Spreadsheet

1. First, use WPS Office to open the spreadsheet.2. Then click the Print button in the upper left corner or use the shortcut key Ctrl+P to use the print feature.3. In the Print pop-up box, we can adjust the settings according to our needs and then click OK.Note: We can click the Print Preview button on the upper left corner of the page to view the printout effect before printing.This skill could be also used in Microsoft Office Excel and Openoffice.

How to set the slide transitions in WPS Presentation

After using WPS Office to open the slide, select the slide we want to add transition first. Then we can select a type of transition according to our needs in the Transitions tab. We can also preview the transition effect by clicking the Preview tab.This skill could be compatible with Microsoft Office powerpoint.

5 special skills you must know when using WPS Office

You probably know the general skills of WPS, but how many special skills of WPS do you know? Today, we will introduce you to 5 special skills you must know when using WPS. l Shortcuts integrated into oneAfter installing WPS Office, you will find that there is only one shortcut on the desktop. The previous WPS Writer, WPS Spreadsheet and WPS Presentation are all removed, and all are unified as WPS OFFICE.Open WPS OFFICE, you can create text, tables, presenta....

How to quickly find the content we want

We can use the Find feature in WPS to quickly find the content we want.Take WPS Writer as an example. 1. After we open the document, we first need to click the Find and Replace button in the Home tab. 2. Then we can enter the content we want to find in Find what of the pop-up Find and Replace. 3. By clicking Find Previous or Find Next, we can see the needed content has been selected on the corresponding page of the text. To be office specialists, you could learn how to use WPS Office o....

How to add comments in WPS Writer

After we use WPS Writer to open the document, select the content we want to add comments to, or click where we want to write comments. Click the Insert tab, then and click the Comment button.Now we can write down our comments in the input box. This skill could also be used in Microsoft Office Word and Openoffice.