### How to insert carriage return in Excel

· Option 1:1. Click the cell within the long sentence.2. Click where we want to insert carriage return, and press the shortcut Alt+Enter.3. Then, the carriage return has been inserted. We push the content to a new line in the same cell. · Option 2:We want to combine the values of several cells into a new cell. And, we need each value to be a new line in the new cell.If we use the shortcut key every time, it can be a very tedious task. In order to save time and improve efficiency, we ca....

### How to lock cells in Excel

1. Go to the Review tab.2. The Lock Cell button is grayed out, which means that the entire sheet has been locked by default.3. Click the Protect Sheet button, then a dialog will pop up.4. In the Allow all users of this worksheet to area, Select locked cells and Select unlocked cells these two options have been checked by default. (Note: Other options can be checked as needed.)5. We enter password in the Password (optional) box, and click the OK button.6. In the pop-up Confirm Password ....

### The MINUTE Function in Excel

To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.· Description:MINUTE function returns the minute as a number from 0 to 59.· Syntax:MINUTE(Serial_number)· Arguments:Serial_number: A number in the date-time code used by WPS spreadsheets, or text in time format.· Example:Suppose we have the starting time (8 AM) and end time of different products on sell and we want to calculate how long it took for each item to be sold out.1. Select....

### The SIN Function in Excel

The SIN function can be used to calculate the sine of a certain angle.· Syntax=Sin(number)The argument “number” is any numeric expression that expresses an angle in radians. (“PI” radian corresponds to 180 degrees.) For example, we want to calculate the sine of an angle, which is 30 degrees. So we need to enter the corresponding radians: PI/6.1. Click the Formulas tab > Insert Function. Enter “SIN” in the dialog and select it.2. In the pop-up dialog, enter an angle in radians in the Nu....

### Text to Column function in Excel

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. For those who want to split the cell text into multiple columns, the function of Text to Column will help you get what you want. WPS Spreadsheet seems superior to table processor for its "Smart Split Columns" function.In today’s case, we want to split text with fixed width and delimited text respectively in a smart way. · Fixed Width Text:Fixed Width me....

### 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 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....

### IFERROR Function in Excel

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, etc. · Description:The IFERROR function returns an alternate value if the result is an error. · Syntax: IFERROR( value, value_if_error ) · Arguments:Value: The formula or value that you want to test.Value_if_error: Is any value or expression or reference if an error is found.(#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME? or #NULL) · Example:Assume that we want to....