151 results for excel sum highlighted cells

- All Tutorials
- Video Tutorials
- Quick Tutorials

- All
- Spreadsheet
- Presentation
- Writer

151 results for excel sum highlighted cells

#### Use SUM function to quickly calculate the sum

01:31### Use SUM function to quickly calculate the sum

The SUM function is commonly used when we process data with WPS Spreadsheet.Use the SUM function values in certain cells. Take this worksheet as an example. How can we sum the values in the yellow-filled cells? 1. Click the Insert Function button in the Formula tab.2. Insert the SUM function from the selection box.3. We can also click the SUM option in the AutoSum dropdown list in this step. Then, there will be a popup dialog titled Function Arguments, where Number means the range to r....

#### Use the shortcut Alt+= to quickly sum

01:02### Use the shortcut Alt+= to quickly sum

In tables, we often have to perform summation operations. Using the function to sum and then filling the cells with the fill handle is too troublesome. However, the sum shortcut Alt+= can help us quickly sum. Take this table as an example. We need to sum the column data of the table, just select the sum range B16:F16, then press the shortcut Alt+= to quickly complete the summation.Similarly, if we want to sum the row data, we can simply select the range G2:G15 that needs to be summed a....

#### More features in Reading Layout

00:45### More features in Reading Layout

Faced with huge amounts of data, we find it difficult to locate the selected cell or cells range. At this point, Reading the Layout can help a lot. Microsoft Excel doesn't support reading mode without plug-ins, while WPS Spreadsheets has the function of Reading Layout. Take this table as an example. 1. Click the View tab, and click the Reading Layout button to select a preferred color.2. When you click a cell, the row and column it lies in are highlighted. You can easily find the s....

#### Clear and avoid duplicates entries in WPS Spreadsheet

01:56### Clear and avoid duplicates entries in WPS Spreadsheet

When using WPS Spreadsheet to process a large number of data, it would be troublesome to find duplicated items manually. Here are some tips to delete duplicates. · Option OneSelect a range of cells. Get into the Data tab, and click the triangle next to Highlight Duplicates. Pick Set from the drop-down list. Duplicated cells within the selected range will be highlighted. To clear the highlight color, we just need to click the Set button. · Option Two Select cell range (A2:C14). Get into....

#### The SUMPRODUCT function for quick calculation of total sales

01:44### The SUMPRODUCT function for quick calculation of total sales

When using WPS Spreadsheets to process data, it is convenient to use the SUMPRODUCT function to multiply data and then sum the results that we get. The spreadsheet for demonstration records sales amounts and prices of clothes in different cities. What can we do for a quick calculation of the total sales in all cities? The SUMPRODUCT function can realize it. This video could be also used in Microsoft Office Excel and Openoffice. Place the cursor in cell F5. Then, click Insert Formula i....

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

#### SUBTOTAL function: Calculate the data with the hidden value

02: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....

#### How to set the calculated field of the pivot table

01:49### How to set the calculated field of the pivot table

We often need to use a pivot table to calculate sales in the work of commodity sales. So how can we quickly count the sales by setting the calculated fields of the pivot table?Take this pivot table as an example. As is shown in this pivot table, if we want to count the total sales, average sales, maximum sales, and minimum sales of each product, we only need to enter the fields in the pivot table to set it up.First, we need to drag the Total sales field to the VALUES list box three tim....