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
- 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
May be interested
- 3 How to rotate a PDF file and save it as the simplest new fileyou 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 fileshow 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 Excelerror #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 filehow 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 Excelwhen 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 Exceldue 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.