To duplicate a text box in Excel for Microsoft 365 on Windows, click its outer border so the handles appear, press Ctrl+C, then press Ctrl+V. Drag the new box into place. This copies the text box and its formatting, leaving the original in place. If you cannot select it easily, use the Selection Pane to locate it.
What You’ll Need
- A workbook containing the text box you want to copy. If you are starting from scratch, create one with Insert > Text Box, then click and drag on the worksheet.
- Excel for Microsoft 365 on Windows for the main steps below. Excel for Mac has equivalent copy-and-paste commands, with different keyboard keys; Excel for the web may have fewer options for selecting and arranging objects.
- A little clear space on the worksheet for the duplicate. If the destination is crowded, you can move it after pasting or use the Selection Pane to select it.
Step-by-Step
- Save the workbook if needed. Duplicating a text box is not usually risky, but saving first gives you a safe point if you move or edit the wrong object. If the workbook is shared, consider whether other people are editing the same sheet before rearranging objects.
- Select the text box itself. Click the text box’s outer edge, not the words inside it. When the object is selected, small handles appear around its border. If you see a blinking text cursor, Excel is in text-editing mode instead; press Esc, then click the border. Pressing Esc once often exits text editing, and pressing it again can help if the object remains selected in a different mode.
- Copy the selected box. On Windows, press Ctrl+C. You can also use Home > Copy on the ribbon or right-click the selected border and choose Copy. Check that the selection handles are still around the object before copying. If you selected only some of the text, the clipboard will contain text rather than the whole box.
- Paste the duplicate. Press Ctrl+V, or choose Home > Paste. Excel places a second text box on the sheet, usually slightly offset from the original. Both boxes should remain visible, though the new one can overlap the first until you move it. The duplicate normally carries over the text, fill, outline, font, alignment, and other formatting.
- Move the new box. Click its border and drag it to the desired location. Keep the pointer on the border rather than a handle, because dragging a handle resizes the box. For a small adjustment, select the object and press an arrow key to nudge it. Zoom in if the boxes are close together, so you can distinguish the duplicate from the original.
- Change the duplicate’s text or appearance if necessary. Double-click inside the new text box, or click inside it after selecting the border, and edit the words. Use the Home tab for text formatting. To change the object’s fill or outline, select its edge and use the Shape Format tab, then choose options such as Shape Fill or Shape Outline. Editing ordinary text in the duplicate does not change the original text.
- Confirm the duplicate is independent and in the right place. Click each box separately and check that the selection handles surround only the intended object. Make any final changes to size, position, or text. If the box must stay aligned with nearby cells, compare its edges with the row or column boundaries at the worksheet’s current zoom level.
You can also duplicate by holding Ctrl while dragging the selected text box on Windows. This makes a copy as you drag, which can be quicker when placing several boxes in a row. Use the copy-and-paste method if you want a more controlled process or find it hard to keep the original stationary. On a Mac, the usual equivalent for copying and pasting is Command+C and Command+V; Option-drag may also copy a selected object. If a shortcut behaves differently in your Excel version, use the ribbon commands instead.
Common Mistakes
Copying the words instead of the object: If the insertion cursor is visible inside the text, Ctrl+C copies selected characters, not the complete text box. Exit text editing and click the outer edge until the handles appear. Copying the object is what preserves its size, fill, border, and placement as a separate shape.
Dragging a handle and changing the size: The small squares or circles on the selected border are resize handles. Start a move from the middle of an edge, where the pointer indicates that the object can be dragged. If you accidentally resize the original, use Ctrl+Z immediately, then select the border and try again.
Pasting over the original and assuming nothing happened: A pasted box can land almost on top of its source. Look for a small offset, move the new box away temporarily, or open the Selection Pane to see the objects listed separately. Avoid deleting either one until you have confirmed which is which.
Expecting a linked text box to become independent: A text box can display a value linked to a worksheet cell. When you duplicate a cell-linked box, the copy may continue to reference the same cell, so the two boxes show the same value. If you want different displayed values, select the copy and inspect its formula-bar entry; update the cell reference or replace the link with ordinary text as appropriate.
Using Ctrl+D without checking what is selected: Ctrl+D is commonly used to fill cells down, so it is not the dependable general-purpose way to duplicate a text box. Select the object and use Ctrl+C followed by Ctrl+V, or Ctrl-drag the object. This avoids accidentally filling cells in a worksheet selection.
Tips
Use the Selection Pane for crowded sheets. Choose Home > Find & Select > Selection Pane. The pane lists objects on the worksheet, including text boxes, and lets you select one by name even when it is hidden behind another shape. You can rename objects there to names such as Instructions copy or Note for Q2, which makes later editing easier. The pane is particularly useful when two boxes overlap or when a box is behind a chart.
Make a neat series of copies. After pasting a box, move it to its new position and repeat the copy-and-paste process from the original. This helps keep each copy’s formatting consistent. If you copy a previous duplicate instead, first check that it has not acquired an unintended size or style change. For rows or columns of boxes, use the worksheet grid and zoom controls to help align them visually.
Keep the same dimensions when positioning. Drag from the border, not from a sizing handle. If exact placement matters, use the arrow keys for small movements after selecting the box. Holding Shift while pressing an arrow key is not required for ordinary nudging; it may behave differently depending on the selected object and Excel version, so use it only if you have confirmed the result on your sheet.
Understand how the object interacts with cells. A text box is a floating object on the worksheet, not text typed into a cell. It can cover cell contents, and moving rows or columns may affect its position depending on its object properties. To inspect those properties, right-click the text box border, choose Format Shape, and look for Size & Properties. Review the placement options if the box needs to move or resize with cells.
Use consistent naming and content. If your sheet has multiple copies, change the words in each duplicate soon after pasting, and give important objects descriptive names in the Selection Pane. That makes it less likely that a later edit will change the wrong note or label. When a box contains an instruction that must appear on several sheets, remember that copying it creates another object on the current sheet; it does not automatically update all other copies.
Troubleshooting
Ctrl+C copies text rather than the box: Press Esc to leave text editing, then click the border. Confirm that handles appear around all sides before copying. If the box is difficult to target, open Home > Find & Select > Selection Pane and click its entry there. Once selected as an object, copy and paste again.
The duplicate is not visible: It may be directly on top of the original, outside the visible worksheet area, or behind another object. Try moving the selected object with an arrow key, or use the Selection Pane to select and rename each item. You can also zoom out to inspect the surrounding sheet. If necessary, use Bring Forward from the Shape Format tab’s Arrange controls to change its stacking order.
The text box will not select: A protected worksheet may restrict editing of objects. Check the Review tab for protection controls; if you have permission, unprotect the sheet before copying. In a shared or restricted workbook, you may need the owner to allow object editing. Also check whether another shape or chart is covering the box; selecting it in the Selection Pane can bypass that obstacle.
Paste does not work in Excel for the web: Web capabilities and keyboard behavior can vary, particularly when a workbook contains drawing objects. Try the Home ribbon’s Copy and Paste commands and make sure the box is selected by its edge. If you cannot select, move, or format the object in the browser, open the workbook in the Excel desktop app and duplicate it there. Your changes can then be saved back to the workbook.
The copied box shows the wrong value: Select the duplicate and look at the formula bar. If it contains a cell reference, the box is linked to that cell rather than holding independent text. Change the reference to the intended cell, or remove the link and type static text. If the formula bar does not show a reference, edit the text inside the box directly.
The original changed when you meant to edit the copy: Undo with Ctrl+Z if the change was recent. Then select the copy through the Selection Pane, move it away from the original, and edit its text or formatting. When objects overlap, selecting by name is safer than clicking the worksheet area.
Frequently Asked Questions
Does duplicating a text box copy its formatting?
Yes. Copying the selected object and pasting it normally carries over its text, size, font, alignment, fill, outline, and other formatting. You can then change the duplicate without changing the original’s ordinary text or shape styling.
Can I duplicate a text box with a keyboard shortcut?
On Windows, select the box border and press Ctrl+C, then Ctrl+V. On Mac, use Command+C and Command+V. Ctrl-drag on Windows can also create a copy while moving it. Shortcuts can vary by selection context, so check that the object handles are visible first.
How do I duplicate a text box without changing its position?
Copy and paste the selected box, then leave the pasted copy in place. It may sit slightly offset, depending on Excel’s placement behavior. If the duplicate overlaps the original, use the Selection Pane to identify it before moving it or changing its stacking order.
Can I copy a text box to another worksheet?
Yes. Select its border, copy it, switch to the destination worksheet, and paste. The new object is placed on that sheet, and you can drag it into position. If it is linked to a cell, inspect the formula-bar reference afterward because the link may not point to the cell you intend on the destination sheet.
Can I duplicate several text boxes at once?
Yes, if you can select them together. Use the Selection Pane to select objects, or hold Ctrl while clicking object borders to add objects to the selection. Then copy and paste the selection. Check the result carefully, since nearby charts, shapes, or other objects can also become part of a multi-selection.
Will changing the duplicate’s text change the original?
For ordinary text typed into the boxes, no: the duplicate is a separate object. However, if both boxes are linked to the same worksheet cell, they will both display that cell’s value. Change the duplicate’s reference or make it static text if it needs to show something different.
Related
- How to Delete Only Filtered Rows in Excel Without Errors
- How to Delete Just One Cell in Excel
- How to Delete in Excel Using the Keyboard
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Databricks Notebook: How to Split a CellTo split a Databricks notebook cell, place the editing cursor where you want the break, then choose Edit…
- Power Query Get Current Year: M Code and Refresh TipsTo get the current year in Power Query, use Date.Year(DateTime.LocalNow()); it returns the year as a whole number,…
- How to Work Out Percentages in Google Sheets EasilyTo work out a percentage in Google Sheets, divide the part by the total, then format the result…
- Google Wedding Budget Spreadsheet: Setup and TrackingA Google wedding budget spreadsheet is a Google Sheets file for listing estimated costs, vendor quotes, final prices,…
- Insert a Square Checkbox in Word: Symbol or Clickable BoxTo insert a square checkbox in Word, use Insert > Symbol > More Symbols, select Segoe UI Symbol,…
- Freeze Panes in Excel: Lock the First Column and Header RowTo keep column A visible while you scroll in Excel for Microsoft 365 on Windows, select View >…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.