To put the same value in visible rows of a filtered Excel range, select the target cells, choose Home > Find & Select > Go To Special > Visible cells only, type the value, and press Ctrl+Enter. For a block of different values, Excel does not reliably paste into a discontinuous visible-only selection; use a helper column or temporarily remove the filter and paste into the intended contiguous rows instead.
Why filtered cells need special handling
A filter hides rows from view; it does not remove them from the worksheet. If you select a range that appears to contain only a few rows, the selection may still include hidden rows between the visible ones. A normal paste can therefore affect cells you cannot currently see. That is the main reason to explicitly select visible cells only before editing.
This is different from hiding rows manually, but the practical concern is similar: a hidden row is still part of a selected range unless you exclude it. The same caution applies to a worksheet with manually hidden rows and to some grouped or outlined ranges. Filtering changes which records are displayed, not the underlying arrangement of cells.
It also helps to separate two tasks that sound alike: copying only visible source cells, and pasting into only visible destination cells. Excel has a built-in visible-cells selection command for both. However, a visible selection can consist of many separate areas, and pasting a rectangular block of different values into those separate areas is not always supported as users expect.
Enter one value in every visible filtered cell
This method works well when all visible target cells should receive the same text, number, date, or formula. For example, if a filtered order list shows eight records and each should receive the status “Reviewed,” you can fill the visible status cells without changing the hidden records.
- Apply the filter using Data > Filter, then filter the table to show the records you want to change.
- Select the target cells in the filtered column. Select the data cells only if you do not want to include the header.
- Choose Home > Find & Select > Go To Special, select Visible cells only, and click OK. In many Windows installations, Alt+; is the shortcut for selecting visible cells only.
- Type the value. Do not click a different cell after typing.
- Press Ctrl+Enter to put that entry in all selected visible cells.
Ctrl+Enter is useful here because it enters the typed content in each cell of the selection, including a selection made up of separate visible areas. Check the result before clearing the filter: the displayed rows should have the new value, and the hidden rows should retain their previous contents. If the selection included a header or an unwanted visible row, undo immediately with Ctrl+Z and repeat with a narrower selection.
Select visible cells only on Windows and Mac
On Excel for Microsoft 365 on Windows, the menu route is Home > Find & Select > Go To Special > Visible cells only. The Go To dialog is also available with Ctrl+G or F5; choose Special, select Visible cells only, and confirm. These menu steps are useful if the keyboard shortcut is unfamiliar or does not work with your keyboard layout.
Excel for Mac has the Go To Special command as well, though ribbon layout and shortcut behavior can differ by version and keyboard settings. Use the Home tab’s Find & Select or Go To controls, open Go To Special, and choose Visible cells only. If you are using a Mac keyboard, do not assume the Windows Alt+; shortcut applies; use the menu command when uncertain. Excel for the web also has a more limited set of desktop selection and editing features, so the desktop app is the safer choice for complicated multi-area edits.
The visible-cells command applies to the current selection; it does not turn on a permanent mode. If you later select a different range, you must select visible cells again before editing that new range.
Copy visible source cells
To copy only the displayed records, select the source range and choose Go To Special > Visible cells only before copying. Then press Ctrl+C, select the destination, and paste. This prevents hidden source rows from being included in the copied selection. It is especially helpful when copying filtered records to another worksheet or workbook.
For example, suppose a table has 100 orders, but a filter displays only orders for one region. Selecting the visible cells in the order-number and amount columns before copying means the hidden regions are not included in the copied source. The copied result may retain separate areas corresponding to the gaps between visible rows, however. If you need a clean, continuous list, paste into a new location and inspect the result, or use a method that creates a compact filtered list, such as copying the displayed table data through a carefully selected contiguous output area.
Copying visible cells and pasting them into a filtered destination are not mirror-image operations. Excel can copy visible cells from a filtered source, but a multi-cell paste into discontiguous destination cells may fail, fill an unexpected pattern, or show a message that the operation cannot be performed on a multiple selection. Do not assume that a normal Ctrl+V will distribute each source value to the next visible row.
Paste different values into visible rows
If each visible row needs a different value, first decide whether the source values are tied to specific records or simply intended to go into the visible rows in order. That distinction matters. A filter can change which records are visible, and the visible rows can be separated by hidden rows, so pasting a consecutive block can put values against the wrong records or alter hidden records.
- Values tied to records: Use a stable identifier, such as an order number or employee ID, to match each value to its record. Add the values in a helper table and use a lookup or another controlled matching process, then check the results before replacing original data.
- Values intended for consecutive worksheet rows: Clear the filter, paste into the exact contiguous range, then reapply the filter. This is appropriate only when the source and destination rows correspond in the unfiltered order.
- A short visible-only update: Enter values individually in the displayed cells, checking the row identifier as you go. This is slower but reduces the risk of shifting values to the wrong records.
A helper column is often the safest option for a large update. Place the new values beside a unique record key in a separate range, match them to the table records, and review the matched results. After confirming the mapping, copy the results and use Paste Special > Values if you need fixed values rather than formulas. This approach makes the relationship between each new value and its record explicit instead of relying on visible row order.
When clearing the filter is safer
If the destination is a normal continuous range and you know exactly which worksheet rows should receive the data, clearing the filter can make pasting simpler. Before doing so, note the filtered records or preserve a copy of the workbook. Clear the filter, identify the intended rows using a unique key or another reliable check, paste into the corresponding cells, and apply the filter again.
Do not simply paste a list sized to the number of currently visible rows into the top of the unfiltered column. Hidden records occupy rows between visible records, so the pasted values may land on different records than intended. For instance, if the visible rows are worksheet rows 4, 9, and 12, a three-cell paste into rows 4 through 6 does not target all three displayed records. The rows’ worksheet positions, not their screen order alone, determine where a contiguous paste goes.
For a one-time change to a small number of records, editing individual visible cells may be the clearest route. For repeated updates, a key-based helper table is usually easier to audit and repeat.
Common problems and how to avoid them
- Hidden rows changed too: You likely selected the full range but did not apply Visible cells only before editing. Undo, make the selection again, and confirm the visible-only command.
- Excel will not paste into the selection: The destination may be a multiple-area selection. Ctrl+V is not a dependable way to distribute a rectangular block of different values across those areas. Use Ctrl+Enter for one repeated entry or choose a helper-column or unfiltered-range method.
- The header changed: The selection included the table header or a visible title row. Undo and select only the data cells. In an Excel table, avoid selecting the entire column if that includes the header.
- Values went to the wrong records: The pasted list was aligned by visible position rather than by a unique identifier. Undo if possible and remap the values by record key.
- The filter results changed during editing: If the edited column is itself filtered, changing its values can make rows appear or disappear as the filter recalculates. Record the target identifiers first, or update a different column and verify the final records.
- Formatting changed unexpectedly: A regular paste carries more than values in some situations. If you only need the contents, use Paste Special and choose Values where appropriate; check that the selected destination is still the intended range.
Before a bulk edit, consider saving a separate copy of the workbook or using Undo as soon as you notice an error. Undo is useful for ordinary cell edits, but it is not a substitute for checking that the selection and row-to-record mapping are correct.
Frequently Asked Questions
Can I paste into visible cells only with Alt+;?
Alt+; selects visible cells only on many Windows versions of Excel. After selecting the destination, use it before the paste or entry. For one repeated value, type the value and press Ctrl+Enter; a multi-cell block of different values may not paste correctly into the resulting separate areas.
How do I paste the same value into filtered rows?
Select the target range, choose Home > Find & Select > Go To Special > Visible cells only, type the value, and press Ctrl+Enter. Check that the header was not part of the selection.
Can I paste different values into filtered rows in order?
Not reliably with a standard paste when the visible destinations are separated by hidden rows. Use a helper list matched by a unique record key, edit the visible cells individually, or clear the filter and paste only after confirming the exact worksheet rows and record order.
Does filtering delete or move hidden rows?
No. Filtering hides records that do not meet the criteria; their rows remain in the worksheet. This is why a range that looks continuous on screen may contain hidden cells between its visible cells.
How do I copy only filtered results to another sheet?
Select the source range, choose Go To Special > Visible cells only, and copy. Paste into the destination, then check whether the output is laid out as needed. If you require a compact, continuous list or need to preserve row-to-record alignment, verify the result rather than assuming a multi-area selection will paste as a simple block.
A quick decision guide
Use Visible cells only followed by Ctrl+Enter when every displayed target cell needs the same entry. Use Visible cells only before copying when hidden source rows must be excluded. For different values matched to different records, prefer a helper table and a unique identifier. Clear the filter for a contiguous paste only when you have verified the exact destination rows in the unfiltered list. These distinctions prevent the most common mistake: treating filtered rows as if hidden records had been removed from the worksheet.
Related
- Excel File Too Big? How to Reduce Workbook File Size Safely
- Excel File Too Large for No Reason? Find the Hidden Data
- Excel File Large for No Reason? Causes and Fixes to Try
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Google Sheets: How to Add Up a Column of NumbersIf your numbers are in B2:B10, enter =SUM(B2:B10) in an empty cell to add them; Google Sheets displays…
- Excel Time Table: Create a Clear, Working ScheduleAn Excel time table is a worksheet that lays out activities against days and times. To make one,…
- Delete a Page in Word: Can You Remove One?Yes. In Word for Microsoft 365, you can select the contents of a page and delete them, but…
- Excel Shortcut to Go to a Specific Column in SecondsIn Excel for Microsoft 365 on Windows, press Ctrl+G or F5, type a cell reference in the column…
- Excel Row Formatting: How to Format and Manage RowsYes. In Excel for Microsoft 365 on Windows, select a row by clicking its number at the left…
- Filter Sort in Google Sheets: Sort Data Without Losing RowsTo filter and sort in Google Sheets, select your table, choose Data > Create a filter, then open…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.