To fill blank cells with the value from the row above in Excel for Microsoft 365, select the list, choose Home > Find & Select > Go To Special > Blanks, type =, press the Up Arrow, and press Ctrl+Enter. Excel fills the selected empty cells with formulas that refer to the cell immediately above; copy the results and use Paste Special > Values if you want fixed entries instead of formulas.
Choose the right method for your list
The Go To Special method is usually the quickest way to fill genuine empty cells in an existing list. It is especially useful when a column contains category labels, dates, or group names only on the first row of each group, with the rows beneath left empty. The formula refers upward, so each blank inherits the nearest preceding value, including through runs of consecutive empty cells.
There are two common meanings of “fill in blank cells,” though. You might want to repeat the value above, or you might want to supply a particular value such as “Not provided.” The upward-reference method does the first. If you need a fixed default, enter that value into the selected blanks instead of entering a formula. Decide which meaning applies before filling; otherwise, you can overwrite useful distinctions in your data.
Fill blanks with the value above: steps
- Select only the relevant part of the list. Include the blank cells and the rows containing the values they should inherit. For example, if the list is in A1:A10 and A1 contains the first label, select A2:A10 to avoid changing the starting cell.
- On the ribbon, choose Home > Find & Select > Go To Special, select Blanks, and choose OK. Excel selects the empty cells within the selected range. You can also open Go To with Ctrl+G or F5 on Windows, choose Special, then select Blanks.
- Type
=, press the Up Arrow once, and press Ctrl+Enter. Do not click another cell between these actions. The Up Arrow adds a reference to the cell directly above the active blank, and Ctrl+Enter enters the formula in all selected blanks. - Check the results, especially at the start and end of the selected range. If you need ordinary values rather than formulas, copy the filled range, then choose Home > Paste > Paste Special > Values.
For example, with the list in A1:A6, A1 containing East, A2 and A3 empty, A4 containing West, and A5 and A6 empty, selecting A2:A6 and following the steps gives East in A2:A3 and West in A5:A6. The cells initially contain formulas, not typed copies. The formulas calculate to the value above, so they can change if the referenced source values change.
What the formula does
With the value East in A1 and a blank in A2, the formula entered in A2 is =A1. It displays the current content of A1. If A2 and A3 are both blank, filling them this way makes A2 refer to A1 and A3 refer to A2. The formulas therefore pass the value down the run of blanks. When the next nonblank entry appears, the following blank refers to that new entry instead.
This is a relative reference: it points one row up from the formula’s own position. That makes the method suitable for irregular groups without needing to know in advance how many rows each group contains. It also explains why selecting the correct range matters. If the first data row is blank and there is no valid value above it, the formula may return a blank or an unintended value. Start the selection below a known value, or handle the first row separately.
Use a helper-column formula when you want control
A helper column is useful when you want to preserve the source list while checking the completed result, or when you need a formula that handles both empty cells and formulas that display an empty string. With source data in A1:A10 and the first source value in A1, copy A1 into B1. Then, in B2, enter =IF(A2="",B1,A2) and fill it down through B10. In this layout, B2 shows the previous output when A2 is blank and otherwise shows A2.
For the example East, blank, blank, West, blank, the helper results are East, East, East, West, West. The first blank uses B1, which contains East; the next blank uses the prior helper result, also East. At the row containing West, the formula returns the source value, and the next blank carries West forward. Once you have checked the helper results, copy B1:B10 and paste values over A1:A10 if that is the desired final layout. Keep a copy of the original data if you may need to reverse the change.
The helper formula tests whether the source evaluates to an empty string. That includes a formula in the source cell that returns an empty string, unlike Go To Special, which selects cells with no contents. However, the test also treats a formula result of an empty string as empty by design. If distinguishing those cases matters, choose a test that matches the data rules rather than filling automatically.
True blanks, spaces, and zero-length results
A cell that looks empty is not always truly empty. It may contain one or more spaces, a formula returning an empty string, or another invisible character. Go To Special > Blanks finds cells with no contents; it does not treat a cell containing a space as blank. A formula returning an empty string also occupies the cell, so it is not selected by that command.
Before filling, click a questionable cell and inspect the formula bar. If it contains a space or a formula, decide whether that content should remain or be cleared. The Find and Replace feature can remove known unwanted spaces, but broad replacements can alter legitimate text, so test on a copy or a small sample first. Do not assume that a displayed blank and an actually empty cell are equivalent.
Also decide how to handle zero. A cell containing 0 is not blank, even if number formatting hides the zero. The fill operation leaves it alone. That is often correct: replacing zeros could erase meaningful measurements or counts. If you want zeros treated as missing, use a deliberate formula or cleanup rule rather than the blank-cell command.
Keep formulas or convert them to values?
Keeping formulas is helpful when the repeated labels should update whenever the original entries change. For instance, if a group heading is corrected later, formulas below it can reflect the revised heading. The trade-off is that the filled cells depend on other cells and may not behave like independent typed entries when the list is sorted, copied, or shared with another system.
Paste Special > Values replaces the formulas with their current displayed results. This makes the completed list static and easier to use as a self-contained data column. It also removes the link to the original cells, so a later edit to a heading will not update the filled values. Consider keeping an untouched copy of the source or saving a separate version before converting formulas.
If you need a quick audit, keep the helper column temporarily. Compare the output with the original list and spot-check every group boundary. Once satisfied, paste values and remove the helper column if it is no longer needed.
Common problems and safe checks
- The wrong value fills down: Check whether the range includes the intended source values and whether each group starts with a nonblank entry. The method carries the preceding value; it does not infer categories from other columns.
- The first blank has no useful value above it: Begin below a valid starting entry, or enter the correct value in the first row manually before filling the rest.
- Nothing happens in some cells: Inspect them for spaces, formulas, or hidden characters. Go To Special selects truly empty cells only.
- Formulas remain after filling: That is expected. Use Paste Special > Values if you need fixed text or numbers.
- The list is inside a filtered range: Be cautious. Selecting blanks across a filtered list can produce results that are difficult to verify, and hidden rows may affect the selection or operation. Clear the filter or work on a copy, then check the whole column.
- The range contains merged cells: Merged cells can make selection and filling behave unpredictably because they span multiple rows or columns. Unmerge the range where appropriate or use a separate helper column.
On Windows, Ctrl+G or F5 opens Go To, and Ctrl+Enter confirms the entry across the selected blanks. On a Mac, use the Go To command from Excel’s menu or ribbon if your keyboard mapping differs; Control+Return is the common equivalent for entering the same value or formula into a selection. Menu labels and shortcut behavior can vary with keyboard settings, so the ribbon route is the most dependable guide.
Alternatives for different fill rules
If every blank should receive the same fixed text, select the blanks with Go To Special, type the text, and use Ctrl+Enter on Windows. This enters that text in the selected cells rather than creating references. If the blanks should remain blank unless another condition is met, use a helper formula that explicitly tests that condition and review the results before replacing the original data.
For a small list, you can also type or copy values manually. That is slower for a long column but may be safer when only a few cells should change or when each blank needs an individually chosen entry. Avoid dragging the fill handle over a large irregular list without checking the result: ordinary fill operations may copy patterns or values in ways that do not match the intended group boundaries.
Excel’s Flash Fill is designed to recognize patterns in adjacent data, such as extracting parts of names. It is not the best choice for carrying group labels down through empty cells because the Go To Special method makes the blank-cell selection explicit. Choose a method based on the rule you want applied, not simply on which command is easiest to find.
Frequently Asked Questions
Can Excel fill blank cells with the value above automatically?
Yes. Select the range, use Go To Special to select Blanks, enter a reference to the cell above, and confirm with Ctrl+Enter on Windows. Review the result before converting formulas to values.
Does Ctrl+Enter fill every selected blank?
It enters the formula into the selected blank cells. With the upward-reference method, Excel adjusts the relative reference so each formula points to the row above its own cell. Check several consecutive blanks to confirm the expected carry-down.
How do I fill blanks with a word instead of the value above?
Select the blank cells with Go To Special, type the required word, and press Ctrl+Enter on Windows. This writes the same fixed text into the selected cells, rather than making formulas.
Why does Go To Special miss cells that look empty?
Those cells may contain spaces, a formula that displays an empty string, or another character. Go To Special > Blanks selects cells with no contents, not every cell that appears blank on screen.
Can I keep the filled results from changing?
Yes. Copy the completed cells and use Paste Special > Values. The formulas become their current results and no longer update when the original entries change.
Related
- Excel Flip Data Upside Down: Reverse Rows in Excel
- Excel Find Table Names: Where to Look and How
- Excel Find Shortcut Key: Search Cells Fast
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Conditional Formatting Dates in Excel: Rules and FormulasTo conditionally format dates in Excel for Microsoft 365 on Windows, select the date cells and choose Home…
- Excel Formula for the First 3 Digits: Text or Numbers?To return the first three characters from a value in cell A2, use =LEFT(A2,3). The result is text,…
- Minimum Sample Size Formula: How to Calculate ItThe minimum sample size depends on what you are estimating or testing. For a proportion in a large…
- How to Enable Filter in Excel: A Step-by-Step GuideTo enable filters in Excel for Microsoft 365 on Windows, click a cell in your data range, then…
- Excel Set Print Area: How to Print the Right CellsTo set a print area in Microsoft Excel for Microsoft 365 on Windows, select the cells you want…
- Excel Rank by Number: Formulas and Tie HandlingTo rank numbers in Excel, use RANK.EQ. With the value to rank in B2 and comparison values in…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.