logo-wlogologo-wlogo-w
  • Home
  • Classes
  • Training
  • Consulting
  • Blog
  • Contact
✕
Repeat Function
April 19, 2021
Filter Data using Wildcards
April 19, 2021

HOW TO DELETE ALTERNATE ROW

April 19, 2021

If we want to delete alternate rows from a data set, then the following steps can be performed to make our task easier instead of deleting the alternate rows individually.

For example, We take a small data set of the employees working ABC ltd.

STEP 1: We add a column to the data set (say, control column). In this column, we will write 1 and 0 in alternate columns. For doing this, we will write 1 and 0 in the first two-column and then select the first two rows and drag them to the whole data set.
If by default the series gets filled in the rows, then select the autofill option. From the drop-down menu, select the “copy cells” option.

STEP 2: Activate the filter option.
(HOME tab – Editing pane – Sort & Filter option – filter option).

STEP 3: Select the activated filter option beside the “control column” column. A dialog box will appear. Unselect “1” and click ok. We will see that only the rows which contain the data set in the even-numbered rows will appear.

STEP 4: Select the data and delete the rows.
(HOME tab – Editing pane – Cell option – delete option – delete sheet row option).

STEP 5: Deactivate the filter option.
(HOME tab – Editing pane – Sort & Filter option – filter option).

STEP 6: To delete the new column which was added. Select the contents of the column and select the “Clear contents” option under the “clear” option in Editing panes.

rowdeletescreenrecording

Contributor:Diksha Agarwal

I am a graduate of St. Xavier's College (Autonomous), Kolkata. I am pursuing CFA as well as actuarial science. I aspire to become an actuarial analyst and have a keen interest in programming language.
WhatsApp Image 2021-04-17 at 12.44.38
Share
1

Related posts

December 16, 2021

Stacking in EXCEL


Read more
December 9, 2021

SIMPLE EXCEL FUNCTIONS YOU SHOULD KNOW


Read more
November 25, 2021

Circular Referencing Solution


Read more

Comments are closed.

✕

Categories

  • Google
  • MS Excel
  • MS Word
  • Power BI
  • Uncategorized
  • Stacking in EXCEL
    December 16, 2021
  • SIMPLE EXCEL FUNCTIONS YOU SHOULD KNOW
    December 9, 2021
  • Tips and Tricks of MS PowerPoint
    December 3, 2021
  • Circular Referencing Solution
    November 25, 2021
  • Printing tricks
    November 18, 2021
    Disclaimer Policy | Terms of Service
    Powered by Aswini Aswini Bajaj
    Website Designed & Developed by 'A PIXEL HOUSE'