Use the Auto Fill feature to fill cells with data that follows a pattern or are based on data in other cells. Select one or more cells you want to use as a basis for filling additional cells.For a series like 1, 2, 3, 4, 5…, type 1 and 2 in the first two cells. For the... » read more
How do I set up a password on Excel files? This method only works with Windows 10 and beyond versions of Excel. Open up the Excel file you want to protect. Go to File. Then click on Info. Go to Protect Workbook. Then click on Encrypt with Password. Enter and confirm the password you want.... » read more
Fill a column with a series of numbers Select the first cell in the range that you want to fill. Type the starting value for the series. Type a value in the next cell to establish a pattern. … Select the cells that contain the starting values. … Drag the fill handle. Sources: https://support.microsoft.com/en-us/office/automatically-number-rows-76ce49e3-d8d2-459b-bd85-ee1d3973e6e6