How to delete even pages in excel

Numbering and reordering.

Why would you want to delete even-numbered pages? If you want to delete it, the pages after the even-numbered pages should move forward and become even-numbered pages. If you just want to print odd pages, it's a little easier, there is a page range when printing in Word, you move the content in Excel to Word, you can choose to print only odd pages.

I didn't find an item in excel that uses commas to separate printed pages. You can only set a few dozen pages in a row.

If your data is in sheet1, please see how many [number of columns] and [number of rows] there are, in order not to affect the original data, let's operate in sheet2:

Write the formula in A1 of Sheet2:

Press and hold the solid cross in the lower right corner of A1, drag to the right to copy to Number of Columns, release the mouse, then press and hold the solid cross in the lower right corner, and drag down to copy to Number of Rows 2

If it's not an odd-numbered line, change the formula:

Copy the formula into your table and give it a try! You will succeed!!

Happy New Year to you!!

If the even-numbered row is directly blank, select column A, press F5 directly, the positioning box appears, the point positioning condition, the null value, OK, right-click, delete, and it's OK.

Method 1 creates a new column, enter 1 in the first row, enter 2 in the 2nd row, enter 1 in the 3rd row, enter 2 in the 4th row, select Quick Enter until the bottom, make this column present, select the menu item data - filter, select filter 1 or 2 (the number that is an even number) on the newly created column, delete it, and cancel the filter.

In the leftmost column of method 2, enter 1 in the first row, null in the second row, and then pull it down, so that even rows are null. The second step is to use the F5 key to invoke - locate and select a null value. Step 3 - Delete, select the row.

Method 3 is column 1, 2, and 3 on the far left, ,......Sort number, the second column on the left with the command =if(mod(a2,2)=0,"Delete",""), then move the mouse to the small square in the lower right corner of cell B2, hold down the left mouse button and drag down, so that the even number of rows is marked. Call Data-Filter-Auto-Filter, then check Delete, Show Only Deleted Rows, Select Region, Delete Rows, Done.

If your data is in sheet1, please see how many [number of columns] and [number of rows] there are, in order not to affect the original data, let's operate in sheet2:

Write the formula in A1 of Sheet2:

Press and hold the solid cross in the lower right corner of A1, drag to the right to copy to Number of Columns, release the mouse, then press and hold the solid cross in the lower right corner, and drag down to copy to Number of Rows 2

If it's not an odd-numbered line, change the formula:

Copy the formula into your table and give it a try! You will succeed!!

Happy New Year to you!!

Method 1

Press the "Ctrl" key on your keyboard and select the columns you want to delete one by one. Just delete it.

Method 21: Enter " in cells A10 and A11 respectively, select two cells, move the mouse to the lower right corner of cell A11, change the cursor to a black cross, press the keyboard "Ctrl" key and the left mouse button to not loosen, and drag to the right to H10.

2. Click "Data" and "Sort", and click "Options" in the sorting dialog box to bring up the options dialog box. Check "Sort by row", 3. Return to the sort dialog box after confirmation. Select "Main Keyword", "Line 10", "Ascending".

4. Select the columns in the 10th row with cell 1 to delete.

You can consider making use of VBA, the main ** part.

Delete odd-numbered columns.

for i=100 to 1 step -1'1 to 100 columns, remove odd columns, if i mod 2=1 then

columns(i).delete

end if

next

Press Ctrl+Column to be deleted, that is, select the column to be deleted first. Then, right-click where you want to select and select Delete.

Transpose the columns to rows first, and then pivot back with reference to the last row and column.

This question is easy.

Okay, add another column after the numbered column (let's say it's column z, replace the row number with a * sign below), and the value of each row of this column is set to "mod(z*, 2)", which is to take the value of the corresponding row in column y and modulo 2 (that is, the remainder divided by 2). Set up each row like this.

If you're smart, you've probably already figured out how to do it, so I'll repeat it here.

As long as we use the sorting function of excel to sort ** according to column z, then all values with 0 (that is, even rows) are ranked in front of odd rows, we start from the last even row and select all the rows to delete all the even rows, and the rest is the odd row.

This method can delete odd number of lines, triple number of lines, and so on.

If you like it, choose my answer.

In the first cell of any blank column (let's say column z), i.e. z1, enter or copy and paste the following formulas.

mod(row(a1),2)

or =mod(row(),2).

Drop down to fill or double-click the fill handle of cell z1.

Filter the rows with a result of 0 in column z.

Delete the entire line.

Create a new column, enter 1 in the first row, enter 2 in the 2nd row, enter 1 in the 3rd row, enter 2 in the 4th row, select Quick Enter to the bottom, make this column the same, select the menu item Data - Filter, select Filter 1 or 2 (the number that is an even number) on the new column, delete it, and cancel the filter.

1. Select column A, right-click, "Insert", and insert an auxiliary column before column A.

2. Enter 1 in A2, select A1:A2, and drag down to the last row of the data area.

3. Press CTRL+G at the same time to open "Positioning", select "Constant" in "Positioning Condition", and confirm.

4. Right-click on the selected cell, "Delete", "Whole Row", OK.

There's a very simple way to do it.

Add a secondary column.

For column z, enter "odd and even" in cell z1

On the mentioned row of the data row (e.g., the data starts from row 2), enter 1 in cell Z2 and enter 2 in cell Z3

Copy Z1:Z2, then select Z cells corresponding to Z3 to the last row of the data, and paste.

Select the header row, click the "Data" menu, automatically filter, select the double row in the drop-down menu of Z1, and delete it.

Added: Forgive me for being stupid, I don't know how "delete the even number of lines" and "do not delete the content of the even number of lines" coexist

Create a secondary column.

Enter 1 in the singular row of the auxiliary column and 2 in the even row, brush black, pull down the last row, and then sort the auxiliary column to delete the even row.

Enter =if(mod(row(),2),) in the empty column at the end"", 1) and fill down. Then filter this column for 1 item. Once selected, press the delete key.

It's very simple, enter 1 in the first row of another column, enter 2 in the second row, and then select these two cells to drop down, that is, generate . in another column. and then sort by that column, and delete the row as 2.

If your data is in sheet1, please see how many [number of columns] and [number of rows] there are, in order not to affect the original data, let's operate in sheet2:

Write the formula in A1 of Sheet2:

Press and hold the solid cross in the lower right corner of A1, drag to the right to copy to Number of Columns, release the mouse, then press and hold the solid cross in the lower right corner, and drag down to copy to Number of Rows 2

If it's not an odd-numbered line, change the formula:

Copy the formula into your table and give it a try!

Use a secondary column, enter the first row.

mod(row(),2)

Fill down to the end, and the rows with a filter result of 1 are copied to the new table.

Or delete rows with a filter result of 0.