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

  • How to merge cells in Excel with no data lossHow to merge cells in Excel with no data loss
    how to merge cells in excel with no data loss normally, you often use merge & center directly to merge cells in excel, but cells with data, you will lose data in the back cells because merge cell only retains data in the first cell.
  • How to split cells, combine cells in ExcelHow to split cells, combine cells in Excel
    how to split cells, combine cells in excel. on excel spreadsheets, many times you need to split cells, merge cells to fit the data you need to enter. you can combine two or more cells together using excel's built-in functions or use visual basic to merge
  • 6 Hidden iOS Settings That Are Draining Your Data Plan6 Hidden iOS Settings That Are Draining Your Data Plan
    the iphone is great in many ways, but saving mobile data isn't one of them. if you're running out of data frequently, here are some key settings you should change to reduce the amount of data your phone uses.
  • How to Cut and PasteHow to Cut and Paste
    whether you work on the computer or just use one at home, the ability to cut and paste text and files is a valuable time-saving technique. the terms 'cut and paste' come from the now-obsolete practice of manuscript editing by cutting...
  • How to color formula cells in Excel automaticallyHow to color formula cells in Excel automatically
    coloring formula cells in excel helps us quickly identify cells that use formulas in long data tables.
  • Fixing errors cannot Copy Paste in WindowsFixing errors cannot Copy Paste in Windows
    copy paste is one of the most basic and handy functions in windows. if you can't copy and paste on windows, follow these steps.
  • Instructions for copying formulas and data between Excel tablesInstructions for copying formulas and data between Excel tables
    often you still copy and paste normally with the key combination ctrl + c and ctrl + v for each data. but if you need to copy data or formulas to different cells and not adjacent to each other, this will take a lot of time ...
  • Fix the phenomenon of hidden files in the explorer virusFix the phenomenon of hidden files in the explorer virus
    plug the usb into the computer as usual and suddenly find no data present; while the drive capacity is still occupied ... using all kinds of ways is still not done, do not rush to format usb but please calmly review this article to be able to save your data.
  • How to Copy and Paste in MinecraftHow to Copy and Paste in Minecraft
    today's tipsmake will show you different ways to copy and paste in minecraft. as long as you are hosting or are an operator on a private minecraft server, and have the worldedit plugin installed, you will be able to copy and paste builds in one or all worlds. if you don't have server or worldedit access, the '/clone' command will help you copy and paste projects from one location to another. besides, you can also copy and paste text from the chat box or chat frame.
  • How to Sort Cells Alphabetically in ExcelHow to Sort Cells Alphabetically in Excel
    excel is a powerful spreadsheet tool used to store and manage text or figures. alphabetical sorting is one of excel's useful features with the ability to help you sort, access and reference data quickly. to sort cells in excel alphabetically, simply double-click by highlighting the range of cells to sort, then click the 'az sort' or 'za sort' icon in the bar. standard tool. to sort cells alphabetically in excel using the advanced sort option, highlight the entire worksheet, click the 'sort' option from the 'data' menu. , then select the column and order you want to sort in the dialog box that appears.