标签：Excel
-
How to Insert an Excel into Another Excel File
If you’re doing a work that involves a huge amount of data, a single excel sheet can hardly meet your need. Try inserting an Excel file into another. It may enrich the information and work as a reference or an addition. First of all, click any cell in the sheet you are editing. Choose Insert […]
-
2 Tips to Alternate Colors for Rows and Columns in Excel
You must have seen some Excel spreadsheets with alternating colors in rows or columns. It can make the data more vibrant and easy to distinguish. Here I’ll introduce 2 commonly used methods to make a table like this. How to Shade Every Other Row in Excel with Conditional Formatting 1. First, select the range of […]
-
How to Generate the Sequence Numbers automatically in Excel 2016
For a worksheet with sequence numbers, inserting a row into it means re-numbering the sequence column. Not only inconvenient to operate, but it takes a lot of workload to modify them. So how can we achieve it? Here’s a simple guide. First, enter all contents you want to generate the sequence numbers. Then, enter the […]
-
How to Rotate a Pie Chart in Excel
If you’ve made a pie chart in Excel, you can apply any color or style you like to it easily. But if you’re not satisfied with the location of these slices, how can you rotate the pie chart to finally meet your need? Look at this chart below, the blue slice of A is on […]
-
How to Subtract in Excel 2016
In the previous post, you know how to calculate the summation in excel, and what about subtraction? Surely we can use the formula for it, and let’s check it out. Enter all numbers you want to subtract, here we calculate the value of column A data subtracting column B data and place the difference in […]
-
How to Set and Clear the Print Area in Excel 2016
Sometimes you may not want to print the entire form, is there any method to define the specific print area of your need? Here I’ d like to share the tip of setting and clearing the print area in Excel. First, select all texts you want to set as the print area. Then, find Page […]
-
How to Extract the Root of a Number in Excel 2016
While processing data in Excel, sometimes we may need to extract the roots of numbers. At this point, you can insert a function to do the operation. For example, I want to extract the cube root of 3375. Type the number in A1 and input the formula “=3375^(1/3)” in half-angle. Then press [Enter] key or […]
-
How to Add Watermark to Excel
It’s true that Word has a feature of inserting watermark directly while Excel does not. But with the similar reason (claim the ownership, protect the information from being tampered, etc.), we may also want to add watermarks to Excel files. How can we do it? Open the file you want to add a watermark. Click […]
-
How to Insert a Random Number in Excel
Random numbers are quite useful in many situations of life and work. And it’s very simple to generate them with Excel function. Here’s the method. 1. Open the Excel file, click a cell and type the formula in it. If you want to generate a number in the range of 1-100, then input “=RANDBETWEEN(1,100)” . […]
-
How to Insert Excel Files to PPT
While making presentations at work, a detailed PPT with a series of relevant Excel data can be very persuasive. Therefore, I’d like to share the experience of inserting Excel file into a PPT.. Open the PPT and turn to the page you want to insert an Excel file. Then switch to Insert tab. Click Object […]
