How to Duplicate an Excel File Shortcut on Windows

How-to basics · Updated November 20, 2026

To duplicate a shortcut to an Excel workbook in Windows, select the shortcut in File Explorer or on your desktop, press Ctrl+C, then press Ctrl+V where you want the second shortcut. Both shortcuts will open the same workbook; this does not make another copy of the Excel file. If you do not have a shortcut yet, right-click the workbook in File Explorer and choose Show more options > Create shortcut.

What You’ll Need

  • A Windows 10 or Windows 11 computer with access to the Excel workbook or its existing shortcut.
  • Permission to create files in the folder where you want to put the new shortcut. To make a desktop shortcut, your Windows account must be able to save items on the desktop.
  • The workbook’s location, if you need to create a new shortcut rather than copy an existing one. The workbook may be stored on your computer, a network location, or a OneDrive-synced folder.

Excel does not need to be open while you make a shortcut. A shortcut is a small link to the workbook, not a copy of the workbook’s contents.

Step-by-Step

  1. Check whether you have a workbook or a shortcut. Find the item you plan to duplicate in File Explorer or on the desktop. A workbook usually has an Excel file extension such as .xlsx, .xlsm, or .xls. A Windows shortcut is a separate item that points to a file; its extension is .lnk, though Windows often hides that extension. If you copy the workbook itself, you are copying the spreadsheet, not just its shortcut.
  2. Choose where the second shortcut should go. Decide whether it belongs beside the original, in another folder, or on the desktop. If you simply want a second desktop icon, you can make the copy on the desktop. If you want a link in a project folder, open that folder first or copy the shortcut there afterward. The destination does not have to be the workbook’s folder.
  3. Select the existing shortcut. Click the shortcut once to highlight it. Do not double-click it, because that opens the workbook in Excel. If you cannot tell whether an item is a shortcut, right-click it and choose Properties. A shortcut’s Properties window has a Shortcut tab with a Target field. A workbook’s Properties window does not have that tab.
  4. Copy the shortcut. With the shortcut selected, press Ctrl+C. You can also right-click it and choose Copy. This places a copy of the shortcut on the Windows clipboard; it does not open or alter the workbook.
  5. Paste it in the destination. Open the folder where the new shortcut should appear, or click an empty area of the desktop. Press Ctrl+V, or right-click an empty area and choose Paste. Windows creates another shortcut that points to the same target as the original. If you paste into the same folder, Windows adds a name such as “- Copy” or a number to distinguish it.
  6. Give the new shortcut a useful name. Select the pasted item and press F2, or right-click it and choose Rename. Enter a name that helps you recognize what it opens, such as “April Sales Workbook” or “Sales Dashboard.” Press Enter to save the name. Renaming the shortcut does not rename the workbook it points to.
  7. Open the new shortcut to confirm it works. Double-click the new icon. Excel should open the workbook, or Windows may first ask which app to use if Excel is not set as the default for that file type. Close the workbook without making changes if you were only checking the shortcut.

To create a shortcut when you do not already have one: In File Explorer, browse to the .xlsx or other workbook file. Right-click it and choose Show more options > Create shortcut. On some Windows 10 computers, or in the older context menu on Windows 11, Create shortcut appears without Show more options. Windows usually creates the shortcut in the same folder and adds “- Shortcut” to its name. If Windows says it cannot create one there and asks whether to put it on the desktop instead, choose Yes if that location suits you. Otherwise, use the desktop method below.

To create a desktop shortcut directly: In File Explorer, right-click the workbook and choose Show more options > Send to > Desktop (create shortcut). In some versions of Windows, Send to is available directly in the first context menu. This creates a shortcut on the desktop without moving the workbook. If you already created a shortcut elsewhere, you can use the copy-and-paste steps above to put a second one on the desktop.

To copy a desktop shortcut to a folder: Click the desktop shortcut once, press Ctrl+C, open the destination folder in File Explorer, and press Ctrl+V. You can use the reverse process to copy a shortcut from a folder to the desktop: copy it, click an empty area of the desktop, then paste. Moving a shortcut is also possible, but copying is the safer choice when you want to keep the original where it is.

On a Mac: Windows .lnk shortcuts do not work as Mac shortcuts. In Finder, select the Excel workbook and choose File > Make Alias. Finder creates an alias that opens the original workbook. To duplicate an existing alias, select it, press Command+C, go to the destination, and press Command+V. On Mac, the alias is the equivalent of a Windows shortcut. In Excel for the web, there is no desktop .lnk shortcut created by the workbook page; use your browser’s bookmark feature for a quick link, or create a Windows or Mac shortcut to a locally synced file if you need a desktop icon.

Common Mistakes

  • Copying the workbook instead of the shortcut. If the selected item is a .xlsx file, Ctrl+C and Ctrl+V make another workbook file. That copy can be edited separately and will not automatically stay in sync with the original. Check Properties for a Shortcut tab, or inspect the icon and file type before copying.
  • Expecting the second shortcut to contain a separate spreadsheet. Duplicated shortcuts point to the same target. Edits made through either shortcut affect the same workbook. To create an independent workbook, use Excel’s Save As or Save a Copy option instead, and give the copy a distinct filename and location.
  • Renaming the source file after creating shortcuts. A shortcut points to a particular file path. If you move or rename the workbook, Windows may no longer find it at that path. Renaming the shortcut is fine; renaming or moving the target is what can break the link.
  • Deleting the original workbook while keeping its shortcuts. Shortcuts do not preserve the file. If the target is deleted, the shortcuts cannot open it. Check that the workbook is backed up or stored in the intended location before deleting or reorganizing files.
  • Confusing a OneDrive link with a local file. A workbook in a OneDrive-synced folder may be online-only or may need a working internet connection. A shortcut does not download the workbook or change its sharing permissions. Make sure the account that opens it has access.
  • Pasting into the wrong place. When the desktop or File Explorer is not the active window, Ctrl+V may paste somewhere unexpected or appear to do nothing. Open the destination first, click an empty area, and check the folder path in File Explorer before pasting.

Tips

  • Use a descriptive shortcut name to explain its purpose or location, especially when several workbooks have similar filenames. You can leave the actual workbook’s name unchanged.
  • Keep shortcuts in folders that match your workflow, such as a team project folder or a “Frequently used” folder. The shortcut can be in a different location from the workbook.
  • If you want to check where a shortcut leads, right-click it, select Properties, and read the Target field on the Shortcut tab. Choose Open File Location if that option is available and you want to view the target’s folder.
  • Windows may hide common file extensions. In File Explorer on Windows 11, choose View > Show > File name extensions to display them. On Windows 10, open the View tab and select File name extensions. Do not change an extension merely to make a shortcut work.
  • For a OneDrive workbook, use a shortcut to the synced file only if that is how you normally access it. If you need to share access with another person, share the workbook using OneDrive’s sharing controls rather than sending them a shortcut that may only work on your computer.
  • If you are uncertain whether you copied a link or a workbook, compare the items’ file types and sizes in Properties. A shortcut is very small; an Excel workbook is usually much larger. Size alone is not definitive, so check the Shortcut tab as well.

Troubleshooting

The pasted shortcut does not appear. Confirm that you selected the shortcut before copying and that the destination folder or desktop is active when you paste. Try right-clicking the destination’s empty space and choosing Paste. If Paste is unavailable, copy the shortcut again. Also check whether the destination is read-only or whether your account lacks permission to save there.

Windows says the shortcut target has changed or cannot be found. The workbook may have been moved, renamed, deleted, or placed on a drive that is not connected. Right-click the shortcut, choose Properties, and inspect the Target field. Browse to the workbook’s current location and create a fresh shortcut from that file. If it is on a network drive, reconnect to the network or confirm that the drive is mapped.

The shortcut opens the wrong workbook. Right-click it and check the Target field in Properties. If the target is not the workbook you intended, delete that shortcut and create a new one from the correct file. Be careful not to delete the workbook itself when removing a bad shortcut.

The shortcut opens Excel but not the workbook. Check that the target file still exists and has a supported file extension. If Excel displays a repair or file-access message, open the workbook directly from File Explorer to see whether the problem is with the file rather than the shortcut. For an online-only OneDrive file, check your connection and sign in to the correct Microsoft account.

You cannot see “Create shortcut” or “Send to.” On Windows 11, right-click the file and select Show more options to view the older context menu. You can also use the Windows search box to find the workbook, choose Open file location if offered, and make the shortcut from File Explorer. If the computer is managed by an organization, its settings or folder permissions may restrict file actions.

A shortcut works for you but not for someone else. The shortcut may point to a path on your computer or to a location the other person cannot access. A copied .lnk file does not package the workbook or grant permission to it. Share the workbook itself through an approved shared folder or OneDrive, then have the other person create their own shortcut to the shared location.

Frequently Asked Questions

Does duplicating an Excel shortcut duplicate the workbook?
No. It creates another link to the same workbook. To make a separate workbook that can be edited independently, use Save As or Save a Copy in Excel.

Can I put the duplicate shortcut on my desktop?
Yes. Copy the existing shortcut, click an empty area of the desktop, and press Ctrl+V. Or right-click the workbook in File Explorer and choose Show more options > Send to > Desktop (create shortcut).

Can the original shortcut and the duplicate have different names?
Yes. Select each shortcut and rename it separately. Changing a shortcut’s name does not change the workbook’s filename or its contents.

Will both shortcuts stay usable if I move the workbook?
Not necessarily. Windows shortcuts point to a target path, so moving or renaming the workbook can make them stop working. Create new shortcuts from the workbook at its new location if that happens.

Can I make a shortcut to an Excel file stored online?
You can make a shortcut to a locally synced OneDrive file, but it still depends on the account, file availability, and permissions. For a web-only workbook, bookmark its browser page or use OneDrive’s sharing link; a Windows desktop shortcut is not the same as a shareable link.

How do I tell a shortcut from the actual Excel file?
Right-click the item and choose Properties. A Windows shortcut has a Shortcut tab and a Target field. A workbook has file details but no Shortcut tab. You can also show file name extensions in File Explorer to see .lnk versus .xlsx or another workbook extension.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.