Excel is one of the most widely used software for data analysis and management. It provides numerous features and options that make data management much easier and efficient. Excel shortcuts are one of these features that can significantly reduce the time and effort required to perform various tasks. One of the most commonly used shortcuts in Excel is the shortcut for writing 1 2. In this article, we will discuss how to write 1 2 in Excel using a shortcut.
Step-by-Step Guide:
Before we start discussing the shortcut for writing 1 2 in Excel, it is important to understand what this shortcut does. The shortcut for 1 2 in Excel simply means that you want to fill a series of cells in a column or a row with a pattern of 1, 2, 1, 2, and so on. Now, let’s move on to the step-by-step guide on how to use this shortcut:
Step 1:
Open an Excel sheet and select the first cell in the row or column where you want to fill the series of 1 and 2.
Step 2:
Type ‘1’ in the selected cell and press Enter.
Step 3:
Select the cell where you typed ‘1’ and move your cursor to the bottom-right corner of the cell. You will notice that the cursor turns into a small plus sign.
Step 4:
Click and drag the cursor to the last cell in the row or column where you want to fill the series of 1 and 2. Excel will automatically fill the cells with the series of 1 and 2.
Other Methods to Write 1 2 in Excel:
Aside from the shortcut method discussed above, there are other methods you can use to write 1 2 in Excel:
Method 1:
Type ‘1’ in the first cell and ‘2’ in the second cell. Select both cells and drag them down to fill the series of 1 and 2 in the column. Alternatively, you can drag them right to fill the series in the row.
Method 2:
Type ‘1’ in the first cell and ‘2’ in the second cell. Select both cells and press Ctrl+C to copy them. Select the range of cells where you want to fill the series and press Ctrl+V to paste the copied cells. Excel will automatically fill the range of cells with the series of 1 and 2.
Conclusion:
Excel shortcuts can significantly reduce the time and effort required to perform various tasks. The shortcut for writing 1 2 in Excel is one of the most commonly used shortcuts. In this article, we discussed how to use this shortcut and other methods to write 1 2 in Excel. By using these methods, you can easily fill a series of cells with a pattern of 1, 2, 1, 2, and so on.
