Excel2013 How to fix row and column values

Source: Internet
Author: User

First, open the Excel2013, select the serial number you want to insert, the following figure, small set to enter the number in the C2, then click C2, enter the function "=row ()-1", row () This function is to obtain the line number meaning;

Second, enter the function directly after clicking Enter jump into the next line, you will find that the function value has automatically become 1;

Third, then click the lower right corner of the C2 cell, when the mouse into a solid cross, pull down, the range according to your actual needs, then release the mouse;

Four, you will find all the cells have been automatically filled with the serial number;

Five, then you can try to delete the whole line in Excel, check your study results.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.