44 results for sort rows in excel 2010
- All Tutorials
- Video Tutorials
- Quick Tutorials
How to unhide rows in excel
When using WPS Spreadsheet to process data, the Hidden Row function can hide the data temporarily not in need. The double line presents in between two columns means one/several column(s) has/have been hidden. For instance, Column B is hidden in the following screenshot. How can we show the hidden rows again in excel?1. Select Columns A to C.2. Right-click on it, and choose Unhide. To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.
How to hide rows in excel
· Hide a single row1. Right-click on the target row for operation.2. Choose Hide from the pop-up list. · Hide rows within a continuous range range1. Right-click to select a continuous row range.2. Choose Hide from the pop-up list. · Hide multiple row selections 1. Long-press Ctrl on the keyboard, while using the mouse to left-click the rows for operations.2. Right-click on the last row(s) selected, and choose Hide from the list. To be office excel advanced, you could learn how to use....
Rows and columns tools in WPS Spreadsheet02:34
Rows and columns tools in WPS Spreadsheet
Today, we are going to show you the usage of the Rows and Columns tool in the WPS Spreadsheet. This tool can help us set the rows and columns of cells and make our work easier with WPS Spreadsheet like Microsoft Excel. Take this table as an example. We need to adjust the row height and column width of the current table.1. Select all tables, click the Home tab, and click Rows and Columns. Select AutoFit Row Height and AutoFit Columns Width. The WPS Spreadsheet will automatically adjust ....
How to transpose columns to rows in Excel
1. Select the table area that needs to be transposed.2. Right-click, and choose Copy in the pop-up shortcut menu, or press Ctrl+C.3. Select a blank area where we want to paste the transposed table. Right-click, and place the cursor behind the Paste Special option in the pop-up shortcut menu. Finally, click Transpose.4. Then, we can transpose columns to rows in Excel, and vice versa. To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.
How to switch data from rows to columns in Excel
1. Select the table for operation, and right-click to copy it (Shortcut key: Ctrl + C).2. Right-click on the cell for the new table → click Special Paste → click Transpose.WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, etc.
Custom sorting in WPS Spreadsheet02:14
Custom sorting in WPS Spreadsheet
We often need to sort the data to organize the table in our work, so how can we sort the data in a table? Take this table as an example. We want to sort the Overall result of this table from largest to smallest.1. Select the cell range in the Overall result column, and click the Home tab, then click the Sort drop-down button.2. Select Descending in the drop-down menu, and then select these two options Expand the selection and Continue with the current selection in the pop-up Sort Warni....
How to sort text in WPS Writer02:37
How to sort text in WPS Writer
When editing documents with WPS Writer, here are three options to sort the data. ONE: Sort by paragraphsTake this document as an example. If we want to sort the data in ascending order, how can we realize it?1. Select the text content.2. Go to Home and click Sort. After that, a dialog box will pop up. 3. Go to Sort by, where we can choose to sort by 'paragraph', 'headings', and 'fields'; in this example, we choose 'paragraph'. We can also set the sortin....
SUBTOTAL function: Calculate the data with the hidden value02:33
SUBTOTAL function: Calculate the data with the hidden value
Take this table as an example. When using the SUM function to do summations, we may find two rows hidden in the table, but the result of the summation still includes the hidden value. So how can we calculate the data containing hidden values and get a result that does not include the hidden values? This video can help us and it can be also used in Microsoft Office Excel and Openoffice. In this case, we can use the SUBTOTAL function. Next, we are going to show you the usage of the SUBTO....