归档： Olivia
-
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 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 Batch Convert Number to Date Format in Excel
While working with Excel, if there are a large number of dates to enter, you can enter the numbers without the format at first for convenience, then batch convert them to the format of date. So how can we achieve it? Here’s a simple guide. 1. First, enter the numbers and select all of them. […]
