How to skip hidden lines when pasting in Excel

Taking Excel 2016 as an example, there are the following steps:

1. Open an excel**, as shown in the figure below:

2. You can see that the original ** is a 4*4**, as shown in the figure below:

3. Select one of the rows, right-click and select Hide, as shown in the following figure

4. You can see that the second line is hidden, as shown in the figure below:

5. Select the data to be copied, as shown in the following figure:

6. Find Find & Select, and select the targeting criteria, as shown in the following figure

7. Select in the pop-up form, and the cells can be seen, as shown in the following figure:

8. Copy this **, as shown in the figure below:

9. Paste to other locations, as shown in the figure below

Here's how:

1. First of all, open Excel**, the data from the fourth row to the seventh row has been hidden.

2. Select the displayed cells, and you need to copy them.

3. Click "Find" in the toolbar and click "Positioning" in the drop-down menu.

4. In the positioning dialog box that opens, select "Visible Cells" and click "Positioning".

5. You can select the visible cells, and use "Ctrl+C" to copy the visible cells.

6. Right-click in the blank cell below and select "Paste as Value".

7. You can paste the visible cell values into the new cells, and skip the hidden in-row data.

microsoft office excel：

Microsoft Excel is an electronic software written by Microsoft for computers using Windows and Apple Macintosh operating systems.

The intuitive interface, excellent calculation capabilities, and charting tools, combined with successful marketing, make Excel the most popular data processing software for personal computers. With the release of Excel in 1993 as a component of Microsoft Office, Excel began to dominate spreadsheet software on all operating platforms.

This is done by using the location feature.

Select the data region first - click Start - Find & Select - Targeting - Visible Area - OK.

2.Copy and paste directly, as you can see from the image below, the hidden content is not copied to.

In the excel software, you can select the cells by boxing, in the search and selection interface, in the positioning conditions, select the visible cells, and use copy and paste.

1. First, select the cells you need, and click [Find and Select] in the upper right corner.

2. A white box pops up and clicks Targeting.

3. In the pop-up window, click [Visible Cell]. Click OK in the lower-right corner.

4. Then right-click [Copy].

5. Finally, select the cell to be pasted, and right-click [Paste]. The Skip Hide Row operation is done when excel pasting.

Select the filtered cell range.

alt+;Or.

F5 targeting.

Visible cells.

Copy. Select any non-empty cell.

Ctrl+V paste.

Here's how to implement excel to skip hidden lines when pasting:

1. After copying C11 (AAAA), B1-B10 will remain unchanged.

2. Press keyboard F5 to bring up the positioning function dialog box.

3. Visible cells - OK.

4. At this time, it has actually become only C1, C9, and C10 selected, and the hidden ones are unchecked. (The appearance is slightly different).

5. Paste it normally. (or CTRL+V) OK.

6. Check after canceling the hidden lines of 2-8 rows, and you're done.

Method 1: Use helper columns.

This method is to use the sorting method to put together the data that needs to be replaced and then copy and paste. That is, first add a "serial number" auxiliary column, enter a numeric serial number in it, then use another auxiliary column to mark the filtered data, sort according to the second auxiliary column, then copy and paste, and finally sort the "ordinal number" column to restore the original data sorting order. The specific steps are as follows:

1.First, cancel the filter, enter the numbers "1" and "2" in the C2 and C3 cells of the "Sheet1" table, select these two cells and double-click the fill handle to fill the sequence number into column C.

2.Filter for "Apples" in column A. Enter the formula in the cell in the second row of column d:

row() then fill down all visible cells of the formula to column d.

3.Unfilter, sort by column d, and sort all the "apples" together.

4.Copy the data from sheet 2 b1:b7 and paste it into the b2:b8 area of sheet 1.

5.Sort by serial number column to restore the order of the original data.

Finally, delete columns C and D to complete the replacement.

Method 2: VBA**

Use the following vba** to directly paste the data in column B of "sheet2" table into the filtered area of "sheet1" table. If the data area of the "Sheet1" table is A1:B20, and the number of columns B in the "Sheet2" table needs to be copied and pasted is 7, first filter "Apple" for column A of "Sheet1", then press Alt+F11 to open the VBA machine, enter the following in the **window** and run.

sub Skip hidden line when pasting()dim rng as rangeset rng = range("b2:b20").specialcells(xlcelltypevisible)for each cell in rngworksheets("sheet2").

cells(i + 1, 2). destination:= = falsei = i + 1if i = 7 then endnextend sub

excel: skip hidden row copying, this operation is 10 times more efficient.

In Excel software, you can scramble by boxing the cells, in the Find & Select interface, in the Positioning Criteria there, select the visible cells, and use copy and paste.

1. First, select the cells you need, and click [Find and Select] in the upper right corner.

2. A white box pops up and clicks Targeting.

3. In the pop-up window, click [Visible Cell]. Click OK in the lower-right corner.

4. Then right-click [Copy].

5. Finally, select the cell to be pasted, and right-click [Paste]. Skip hail when excel pasting hidden line operation is done.

Here's how to implement excel to skip hidden lines when pasting:

1. After copying C11 (AAAA), B1-B10 will remain unchanged.

2. Press keyboard F5 to bring up the positioning function dialog box.

3. Visible cells - OK.

4. At this time, it has actually become only C1, C9, and C10 selected, and the hidden ones are unchecked. (The appearance is slightly different).

5. Paste it normally. (or CTRL+V) OK.

6. Check after canceling the hidden lines of 2-8 rows, and you're done.

The way to skip the hidden cells when excel paste is to select the content that needs to be copied, and then right-click in the corresponding cell. Then select the selective Triumph and paste the values in it to complete. Here's how:

Device: Lenovo Xiaoxin pad inch computer;

Operating system: win10 professional version;

Software: excel2010 version.

1. Open the required excel file on the computer, you can see the hidden content, click copy after selection.

2. After the copy is completed, right-click in the corresponding cell, click on the stool and paste selectively.

3. Select the value in the dialog box that appears and click the OK button.

4. At this time, you can see the hidden cells that have been skipped when copying and pasting.

In everyday life, excel is often usedOffice software。How to not stick to the hidden line of excel paste, here is the method of sharing the middle and closed.

1. After entering the WPS** file first, you can find the hidden lines, and select the lines that need to be copied.

2. Then click Find in the top right.

3. Then click Locate in the options.

4. Then check the visible cells in the positioning option and click Positioning below.

5. After the trip, press the Ctrl+C shortcut key on the keyboard to copy.

Replicate the data region.

6. Finally, select a blank cell, press Ctrl+V on the keyboard to paste the shortcut key to sell cracking, you can find that the pasted data is skipping the hidden line.