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.
For example, you have the following data table, and need to paste the data only into the cells shown in the spreadsheet.
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 .
Step 2: Select the data area to paste data. For example, from cells D4 to D12 .
Step 3: On the Home tab (1) , press the Find & Select button (2) and select Go To Special . (3) .
Or you can use the keyboard shortcut Ctrl + G , then press the Special button .
Step 4: In the Go To Special dialog box , select Visible cells only and then press the OK button .
Then you will see the selection changes as follows:
Step 5: Now, you can use the keyboard shortcut Ctrl + V to paste that data into the visible cells.
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.
You should read it
- Merge cells in Excel
- How to Lock Cells in Excel
- How to split cells, combine cells in Excel
- How to combine 2 or more cells in Excel without losing data
- How to color formula cells in Excel automatically
- How to split cells, combine cells (cells) in Word table
- How to merge cells in Excel with no data loss
- Two new types of blood cells were discovered
- Top 6 hidden cameras to protect your house
- How to Sort Cells Alphabetically in Excel
- MS Excel 2007 - Lesson 4: Working with data
- How to split 1 cell into 2 cells in Excel - Split cells in Excel
Maybe you are interested
How to use the Round function in Excel to round numbers and process data
How to Overwrite Deleted Data on a Drive in Windows 11/10
How to sort data in Excel using Sort is extremely simple
How to stay safe from 'SpyLoan' Android apps that use your data to blackmail you
6 Excel functions to find data quickly
Email threatening to reveal private data from Microsoft may be a scam