Password Protect Excel File

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

Excel Auto Fill Columns with Numeric Value

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: