Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

problem copying formulas in excel

Copper Contributor

When i try to copy a monthly budget formula to a new month, it only copies as numbers. The formulas do not transfer. I only have one paste option. Is there a way to restore paste optiton I need?

1 Reply

@Jodi_Cox_Jodi_Cox 

If you are experiencing issues with copying formulas in Excel and only getting the values copied, it's likely related to the paste options. Here are a few steps you can take to troubleshoot and resolve the problem:

1. Check Paste Options:

After copying the cells with formulas, right-click on the destination cells where you want to paste the formulas.

Check the available paste options in the context menu. Look for "Formulas" or "Paste Formulas" option. If it's not there, it might be hidden.

2. Use Keyboard Shortcuts:

Instead of using the right-click context menu, you can try using keyboard shortcuts.

Copy: Ctrl + C

Paste: Ctrl + V

After pasting, you can use the shortcut Ctrl + Alt + V (in sequence, not simultaneously) to open the Paste Special menu, where you can choose to paste formulas.

3. Paste Special:

After copying, right-click on the destination cells, choose "Paste Special," and then select "Formulas."

Alternatively, you can use the keyboard shortcut Ctrl + Alt + V, and then press F for Formulas.

4. Check Cell Format:

Ensure that the destination cells have the correct format for formulas. If the cells are formatted as text, Excel might paste them as values.

Right-click on the destination cells, choose "Format Cells," and make sure the format is set to "General" or the appropriate number format.

5. Check Excel Options:

Go to "File" > "Options" > "Advanced."

Scroll down to the "Cut, copy, and paste" section.

Ensure that the "Cut, copy, and sort inserted objects with their parent cells" option is checked.

6. Reset Excel Preferences:

In some cases, Excel preferences might be causing issues. You can try resetting Excel preferences to default settings.

This can be done through Excel Options > Advanced > "At the bottom of the Advanced tab, click 'Reset.'"

Keep in mind that this will reset other Excel preferences as well.

After trying these steps, you should be able to copy and paste formulas without issues. If the problem persists, there might be specific details about your Excel version and/or settings that require further investigation. The text and steps were edited with the help of AI.

 

My answers are voluntary and without guarantee!

 

Hope this will help you.

Was the answer useful? Mark as best response and Like it!

This will help all forum participants.