Excel 2021

How to Quickly Fill a Number Series in Excel 2021 by Dragging

How to Quickly Fill a Number Series in Excel 2021 by Dragging

Excel doesn't include the option to automatically number data, unlike other Microsoft Office applications. However, you can quickly add a sequence of numbers to a row of data by moving the Fill Handle to fill the column. Fill Series is a useful Excel function that increases spreadsheet productivity. Based on the interval, type, unit, and value of the user-defined step, it allows filling in the data directly in the selected cell. How to Use the Fill Handle An interesting feature used inside spreadsheets is the Fill Handle from Excel. The Fill Handle, a plus sign, is displayed when you select the initial cell and move the mouse cursor to the lower-right corner of the cell range. Press and drag the Fill Handle to the desired cell while holding down the mouse button to enable auto-load. After the mouse is released, the compartment has been filled. The default Fill Series in Microsoft Excel 2021 differs from previous versions of Excel. In the 2021 version of Excel, you use the right mouse button to drag it. Whereas in the previous Excel, use the left mouse button. How to Use Fill Series in Excel 2021 Select the starting cell in the range that you want to fill.Type the initial value for the series.Drag the lower right corner of the range you selected using the mouse's "Right" button. Once in the range you want, release the mouse button. In the options that appear, select "Fill Series". If you want sequential numbers (1, 2, 3, 4, 5... ), simply type the initial number (1) and drag...

How to Unprotect Excel without Password

How to Unprotect Excel without Password

When you work with Microsoft Excel, you can protect the documents you create by using a password. There are two ways to protect your excel file with a password. First, you can protect the excel file by every time you open the file, excel will ask for the password you created. Second, you can protect it by preventing other people from changing your excel file. It can only make changes when protection has been disabled using the password you created. Protection secondly can be applied to the "Sheet" or "Workbook" in the excel file. You can set this method to prohibit changes to part or all of the documents that you create. What if you forget the password you have created? You cannot change an excel file that has been protected in the “Sheet” or “Workbook” without knowing the password. You can only see without being able to make changes. But you don't have to worry, Bardimin will share how to open excel protection without using a password. How to unprotect Excel "Sheet" in Microsoft Excel 2010 and below In Microsoft Excel 2010 and below, if you forget the password protection, you can open the protection by using Macro VBA. Open your excel file with Microsoft Excel.Press ( Alt + F11 ) to open the Visual Basic Editor.After the Visual Basic Editor window opens, then click “ ThisWorkbook > Insert > Module ”. Then type the following VBA code in the window that appears. Sub PasswordBreaker() 'Breaks worksheet password protection. Dim i As Integer, j As Integer, k As Integer...