This is a regular question or problem that arises with Excel users (it’s all the same for me).
How to insert a blank line into every other line of your dataset? The many solutions available require the user to write a code or a macro, which is fine, but some users do not like VBA. There is an easy way to achieve the same result in Excel without having to write VBA. But I can give you some code to do the same thing as ... if you want it.
OK let's insert some blank lines into our dataset. Our data set is configured as below.
Date: Week: Day: WeekDay: User
01/06/15 1 1 11 AmyH
02/06/15 1 2 12 JoeP
03/06/15 1 3 13 PeterH
05/05/15 1 5 15 SuseM
First we need to insert a new column to the left of the existing column A. (we assume that our existing data starts in A1), so our data is now contained in column B, inserting a new column A.
The next step is to enter the number 1 in cell A1 and select column A to the last row of your dataset.
You can quickly press CTRL + SHIFT + DOWN to quickly do it. (Dow this twice to select the entire column, including cells with no data.
- Select the Home tab - go to the Edit Group group, select Fill
- On the Fill series, click OK.
- Column A should now be filled with numbers from 1 to the total number of lines to the end of your data set.
- CTRL + C to copy pasted values.
- Navigate to the next free cell below your data series.
- Press CTRL + V to paste the values.
- Highlight the entire data area, including new rows with a number that appears in column A
- Main tab - Sort and filter - smallest in column A
Your blank lines will be inserted in Flash!
Then you can simply delete the auxiliary column A created in the early stages of the process, and your work will be done. Excel used line numbering to insert blank lines on a sheet of paper without any VBA programs.
