How to paste data into non-hidden cells, ignoring hidden cells

The Copy tool - Paste is a useful tool in Excel. However, to best use this tool, not all users know it. In this article, Dexterity Software teaches you how to paste data that ignores hidden cells.

How to paste data into non-hidden cells, ignoring hidden cells Picture 1

For example, you have the following data table, and need to paste the data only into the cells shown in the spreadsheet.

How to paste data into non-hidden cells, ignoring hidden cells Picture 2

If your data sheet is small, you can manually copy each cell, but if there are up to 100 cells, then try the following steps.

Step 1: Copy the original data. The example in cell F4 contains the original data. Select the cell F4 and then type the keyboard shortcut Ctrl + C .

How to paste data into non-hidden cells, ignoring hidden cells Picture 3

Step 2: Select the data area to paste data. For example, from cells D4 to D12 .

How to paste data into non-hidden cells, ignoring hidden cells Picture 4

Step 3: On the Home tab (1) , press the Find & Select button (2) and select Go To Special . (3) .

How to paste data into non-hidden cells, ignoring hidden cells Picture 5

Or you can use the keyboard shortcut Ctrl + G , then press the Special button .

How to paste data into non-hidden cells, ignoring hidden cells Picture 6

Step 4: In the Go To Special dialog box , select Visible cells only and then press the OK button .

How to paste data into non-hidden cells, ignoring hidden cells Picture 7

Then you will see the selection changes as follows:

How to paste data into non-hidden cells, ignoring hidden cells Picture 8

Step 5: Now, you can use the keyboard shortcut Ctrl + V to paste that data into the visible cells.

How to paste data into non-hidden cells, ignoring hidden cells Picture 9

Or if you have not copied the original data, you start from step 2, so after completing Step 4 , start filling the word "Paid" and then press Ctrl + Enter to enter data or formulas into these non-hidden cells.

How to paste data into non-hidden cells, ignoring hidden cells Picture 10

5 ★ | 1 Vote

May be interested

  • 3 How to rotate a PDF file and save it as the simplest new filePhoto of 3 How to rotate a PDF file and save it as the simplest new file
    you have a pdf document and you need to read it, but when you open it, all the words are rotated horizontally or reversed? use one of the three ways to rotate a pdf file and save it as the simplest new file that tipsmake.com introduces below.
  • How to use Vlookup function between 2 sheets, 2 different Excel filesPhoto of How to use Vlookup function between 2 sheets, 2 different Excel files
    how to use vlookup function between 2 sheets, 2 different excel files. normally the vlookup function applies on the same file in a certain workbook, but in some cases where the work is not so simple, the condition area and the area you need to access the data belong to belongs to two other sheets. together
  • How to correct a #NAME error in ExcelPhoto of How to correct a #NAME error in Excel
    error #name? an error when excel cannot recognize what it is, it can be a function or an argument. common causes of #name errors? either because the function name is misspelled, or one of the following is caused:
  • How to fix the error can not save Excel filePhoto of How to fix the error can not save Excel file
    how to fix the error can not save excel file. in some cases, you can open a spreadsheet directly on outlook, or open a file as read only; you can edit the file, but when saving the file, excel will alert you with the following content:
  • How to fix non-unhide error in ExcelPhoto of How to fix non-unhide error in Excel
    when working on an excel spreadsheet, there are times when you clearly see that there are hidden lines (hide) that you cannot open offline (unhide). why is that happening? let's have a look at dexterity software through the article below.
  • How to fix date auto-jump error in ExcelPhoto of How to fix date auto-jump error in Excel
    due to the convention of the date format of different regions; for example, the americas region is usually the month / day / year format; for some asian countries and vietnam usually use the day / month / year. because of the difference, users sometimes encounter the error of writing the wrong date, the date you see jump is not as desired.