To give cells a white background and a single outline in Excel for Microsoft 365 on Windows, select the cells, choose Home > Fill Color and pick white, then open Home > Borders and choose Outside Borders. This keeps the selected area white and draws a border around its perimeter without adding lines between cells. If you mean one edge only, choose a specific border such as Bottom Border instead.
What You’ll Need
- An Excel workbook you can edit. If the file is read-only or protected, you may need permission or to unprotect the sheet before changing formatting.
- The cell or range you want to format. For a range, decide whether you want one outline around the whole selection or a border on each cell.
- Excel for Microsoft 365 on Windows for the steps below. Excel for Mac and Excel for the web have similar fill and border controls; differences are noted where they matter.
You do not need a formula, add-in, or special template. If you are unsure what the current formatting looks like, save a copy first or note the existing appearance so you can restore it if needed.
Step-by-Step
- Select the cells to format. Click a single cell, or click and drag across a range. To select a whole column or row, click its letter or number heading. For example, if you want a white area with a border around a small table, select the table cells but not the surrounding worksheet. Selecting the right range first prevents formatting unrelated cells.
- Open the fill-color menu. On the ribbon, select Home. In the Font group, click the arrow beside the paint-bucket-shaped Fill Color button. Clicking the main button applies the color currently shown on that button; use its arrow when you need to choose white or another color.
- Choose white as the fill. In the palette, click the white swatch under Theme Colors or Standard Colors. Hover over a swatch if you are uncertain: Excel displays a color name. The selected cells should appear white. On a white worksheet, the change may be hard to see, but the fill is still applied. It is a solid fill, not a transparent setting.
- Open the border options. Keep the same cells selected. On Home, in the Font group, click the arrow beside the Borders icon. The icon may show a small grid or a square outline. The dropdown contains choices for outlining the selection, adding individual edges, or placing borders between cells.
- Choose Outside Borders for one outline. Click Outside Borders in the menu. Excel draws a border around the outside edge of the selected cell or range. When you select several adjacent cells, this option gives the range one perimeter rather than putting a box around every cell. It does not remove internal borders that were already present, so inspect the result if the cells had earlier formatting.
- Check the border color and line style if needed. Excel applies the current border settings, which may be thin black lines by default. If you need a particular appearance, reopen the Borders dropdown and review Line Color and Line Style, where available, before applying the border. Pick the color and weight first, then choose Outside Borders again. A white border on a white sheet will be difficult to see, so use a contrasting color for a visible outline.
- Use a single edge instead when that is what you mean. To add only a bottom, top, left, or right line, select the target cell or range and choose the matching option, such as Bottom Border, from the Borders menu. For example, selecting B2:E2 and applying Bottom Border adds a line beneath those cells rather than an outline around all four sides. This is useful for a heading or subtotal row.
- Review the result at a useful zoom level. Click elsewhere or press an arrow key to move the selection outline, then look at the formatted cells. The green selection outline can overlap the visual border while the cells are selected. If necessary, use the zoom control on Excel’s status bar to check the range more clearly. Confirm that the fill is white and that the border is on the intended edge or perimeter.
- Adjust the fill or border without starting over. Reselect the cells and use the same Home ribbon controls to change the fill or apply a different border. Applying a new border option can add or replace specific edges depending on the option; it may not clear every previous line. To remove unwanted lines, use the Borders dropdown and choose No Border, then apply the desired border again. Be aware that No Border removes borders from the selected cells, including any you wanted to keep.
- Save and check the workbook where it will be used. Press Ctrl+S on Windows to save. If the cells need to look right when printed, open File > Print and inspect the preview. Worksheet gridlines and cell borders are different: gridlines are a worksheet display or print setting, while the border you applied is cell formatting. A white fill can also cover the visible gridlines behind the cells.
On Excel for Mac, select the cells and use the Home tab’s Fill Color and Borders menus in much the same way. The exact menu layout can vary slightly by Excel build. Command+1 opens Format Cells on Mac; on Windows, use Ctrl+1. In Excel for the web, select the cells and use the fill and border controls on the Home tab. Some advanced border styling options may be arranged differently or be more limited in the web version.
Common Mistakes
- Choosing All Borders when you want one outside outline. All Borders adds lines around individual cells, including internal dividers. For one perimeter around a selected block, choose Outside Borders. If the range already has internal lines, Outside Borders alone will not erase them.
- Clicking the fill button instead of its arrow. The main Fill Color button repeats the last-used color. If that color is not white, the selection may turn another color. Open the dropdown arrow and pick the white swatch explicitly.
- Assuming white means no fill. White is an actual cell fill. It can hide worksheet gridlines in the selected area and may print as a white block over a colored background. To remove a fill instead, use the fill menu’s No Fill option.
- Selecting too many or too few cells. Excel formats exactly what is selected. A border can appear to run across a wider or narrower area than expected if the range includes a neighboring column or misses the last row. Check the selection before applying formatting.
- Expecting an outside border to make every cell separate. Outside Borders outlines the whole selected block; it does not create internal separators. Use All Borders for a full cell grid, or choose only the internal border options you need.
- Confusing worksheet gridlines with borders. Gridlines are the faint guides between cells. They are not the same as a formatted border, and their visibility can depend on worksheet settings. Use an actual cell border when you need a line that remains part of the cell formatting.
Tips
- Choose the selection shape to match the job. Apply Outside Borders to a rectangular range when you want one frame around a section. For one line under a label or total, select the relevant cells and use a single-edge command instead.
- Set a readable border color. A black or dark gray line is usually easier to see on a white background than a pale gray or white line. If the workbook uses a particular palette, choose a color that fits the design but maintains enough contrast.
- Use Format Cells for more control. Press Ctrl+1 on Windows or Command+1 on Mac, then open the Border tab. You can select a line style and color and use the preview diagram to turn individual edges on or off. This is helpful when you need a custom combination rather than a preset border command.
- Copy formatting carefully. The Format Painter on the Home tab can copy a cell’s fill and borders to another area, but it may copy other formatting too, such as number formats or font styles. If you only want a white fill and border, applying those controls directly is often safer.
- Consider print appearance. A filled white area may look identical to the surrounding sheet on screen, but can conceal gridlines when printed. Use File > Print to check the page before distributing it, particularly if the border is meant to define a table or form field.
- Keep a consistent style across a table. Use the same border weight and color for comparable sections. For instance, a thin dark outline around each separate information block is usually clearer than mixing heavy and faint lines without a reason.
Troubleshooting
The cells still look unchanged after choosing white. If the worksheet itself is white, a white fill is almost indistinguishable from no fill. Select a cell and reopen the Fill Color menu to confirm the applied color, or temporarily use a pale color to verify that the correct range is selected, then choose white again. Also check whether conditional formatting is overriding the appearance: open Home > Conditional Formatting > Manage Rules and review rules that apply to the cells. Do not remove a rule unless you know it is no longer needed.
The border is missing or appears on the wrong cells. Select the intended range again and apply Outside Borders. Check for merged cells, which can make the visible outline behave differently from a regular cell range. If the sheet is protected, formatting may be blocked; use Review > Unprotect Sheet if you have authorization and the required password. Also check that the border color is not white or so faint that it blends into the background.
There are lines inside the range even though you chose Outside Borders. Those lines may be existing cell borders. Choose No Border for the selected range to clear its borders, then apply Outside Borders again. This clears all borders within that selection, so it can remove internal lines you meant to keep. If some internal lines are intentional, use Format Cells’ Border tab to remove only the unwanted edges, or reapply the needed internal borders afterward.
The fill or border changes more cells than intended. Press Ctrl+Z on Windows or Command+Z on Mac immediately to undo the last action, then make a more precise selection. If the formatting came from a table style or conditional formatting rule, the visible result may not be controlled by the ordinary fill command alone. Check the table style or applicable conditional formatting rules before applying more changes.
The border looks right on screen but not in print. Open File > Print and review the preview at the intended paper size. Confirm that the selected range is within the print area and that the border has enough contrast and weight. If you are relying on gridlines rather than a cell border, remember that gridlines have separate print settings; a formatted border is more dependable for outlining a specific range.
Frequently Asked Questions
How do I put a border around a range without lines between cells?
Select the range, then choose Home > Borders > Outside Borders. This puts a border around the range’s perimeter. Existing internal borders remain until you remove them.
How do I add only one border line in Excel?
Select the relevant cells, open the Borders dropdown on the Home tab, and choose a single edge such as Bottom Border or Top Border. For a line at the left or right of a range, use the matching edge option.
What is the difference between white fill and No Fill?
White fill paints the cell white and can cover worksheet gridlines or a background color. No Fill removes the cell’s fill formatting, allowing the worksheet background and gridlines to show as configured.
Can I make the border a different color or thickness?
Yes. Use the Borders dropdown’s line color and line style choices, or open Format Cells with Ctrl+1 on Windows or Command+1 on Mac and set the border on the Border tab. Then apply the chosen edge or outline.
Will the border appear when I print the worksheet?
A cell border is cell formatting and normally appears in print. Check File > Print to confirm the range, contrast, and line weight. Gridlines are separate and may not print unless their print setting is enabled.
Can I do this in Excel for the web?
Yes. Select the cells, then use the fill-color and border controls on the Home tab. If you need detailed control over line color, style, or individual edges and cannot find the relevant option in the web ribbon, open the workbook in the desktop app.
Related
- Home Clean List Excel: Build a Practical Checklist
- Guest List Excel Template: What to Include and How to Use
- Group Dates in Excel Filters: Steps, Fixes, and Tips
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Add a Subject Line to a Word Mail Merge EmailTo add a subject line to a Word email merge, finish preparing your message, then choose Mailings >…
- Excel Scatter Plot Labels: Add Names to PointsTo label points in an Excel scatter plot with names, select the chart, choose Chart Design > Add…
- Does Excel Have a Debt Payoff Template? What to KnowYes. Excel can provide debt payoff templates through its template gallery or online template sources, though one may…
- Excel Workbook Protection: What It Does and How to Use ItExcel workbook protection is a set of separate controls, not one all-purpose security switch. In Microsoft 365 for…
- Excel Row Limit: How Many Rows Can a Sheet Hold?A worksheet in current Microsoft Excel for Microsoft 365 can hold 1,048,576 rows, numbered 1 through 1,048,576. That…
- Google Sheets Filter Not Blank? Steps and FormulasTo show only rows with a nonblank cell in Google Sheets, select your table and choose Data >…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.