How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

like
Posting as :
works at
You are currently posting as works at

Ctrl+C, then in sequence press ALT, E, S, F to paste special: formulas

like

You can also you paste special to paste values only, or formats, column widths from copied cells. Pressing ALT, E, S will bring up all the options for paste special

It's because you're using absolute/partial references (e.g., $a$1, a$1) or you're referencing the sheet that the formula cell is in (e.g., Sheet1!a$1). You never need the sheet reference for the cell you're in, it messes up your ability to sort. If you need the absolute/partial references on the new sheet, just Ctrl+h and replace the sheet reference (e.g.,Sheet1!) with nothing (e.g., ) after you paste it over.

like

You can also copy formulas in notepad, select all and paste in new sheet/workbook

like

Control + F. Make sure you’re searching for formulas on sheet, and then do replace all for the “[SHEET NAME]” with “”. This essentially removes the reference to old sheet.
I’ve done this before when format is exactly the same as old sheet.

Related Posts

What’s a recent achievement (personal or professional) that you’ve experienced?

like

I am on bench from 1 nov 2022. I am PA.

like

Hi Fishes, Great to Connect! Can anyone tell me what are the chances for a contractor to convert into a full-time employee in Google India? Does Google convert any of 3rd party payroll contractors into full-time employees?

like

Looking for female flatmates for 2bhk flat nearby Bangerghatta Road, New Gurappanapalya-BTM Layout 1st Stage, Bangalore - 560029.

Please DM soon.

like

Hi,
Only hdfc bank accounts can be given as salary account in Pwc AC ? Is it like that?
I have Axis Bank account.

like

When choosing the city to immigrate to Australia, to continue your career as leader coach in IT, which city do you consider has the biggest opportunities?

like

Is it just me or are behavioral questions really stupid? I always feel like they're either way too open ended or they're asking about something that's never happened to me

like

My friend and I (both Asian and gay) were seating at the cafe on the 2nd floor of Saks Fifth Ave today waiting for our table for the restaurant on the 9th floor. A lady came and asked where are we from, and “why are you two men in this mall? This is for female only”. I said this mall sells products for all genders. She said she has walked all floors and never saw a thing for men. Then she threw curse at me. I stood up and asked her to repeat what she said. She pulled her phone and called 911

like

Hii fishes, i am starting to interview at jpm, can anyone guide me on the process and what should be my salary expectations be for Software Engineer python, yoe 1.5+ at mumbai

like

Just curious are there any EAs in the Las Vegas, NV area and what are your salaries?

like

What is the total compensation for Associate in D&I at Alvarez and Marsal?

like

What is the longest deposition you’ve sat through? …..I’m currently in one thats been going for 10 hours. 🙃

likefunny

Partners: we've heard a bit about your income. Can we talk penalties: internal review failure, PCAOB failure, massive losses, lost clients, ethics issues ... How do the firms handle these?

likefunny

Any tips for how to maximize property damage insurance claim?

I'm 1st time landlord and my single tenant in Seattle unfortunately overdosed on cocaine+pills 5 days before found in kitchen. :( Extensive damage.

Seeking tips - ex. contractor validating damage was on highest cost cabinets & flooring, replace all tile/grout, contractors upbid damage value (within reason).

Too many are advising being bold w insurance companies we all pay for most our lives, but open to all advice.

like

I wish I was overemployed. Searching for gigs, but nothing yet. Any tips on how to get one or more extra jobs?

Anyone ever asked to sign an NDA prior to interviewing? Just had a DocuSign sent over for a phone interview I have next week

I am currently a 5th grade math/science teacher and have an opportunity to move up to a middle school science and technology position. Anyone here move from elementary to middle school? What are some key things I should know if I take this position?

like

My bf has asked me to help him quit the ecigs and told me he’ll probably hide them from me but he wants me to take them. So I have for the past week. He really only keeps them in his pocket, 1 drawer

Have any of you moved to PE for a slight pay decrease from the crazy banking comps last year?

Additional Posts in Excel Genius

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

like

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

like

Is it possible to round a number (say rounding $98 to $100) without losing precision in following calcs? So I only want to round visually and I want the calcs from that cell to remain off the $98 not $100

likehelpful

How long did it take you to become good at excel? Like fast?

like

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

likehelpful

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

like

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

like

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

like

Would anyone be willing to teach me vlookup?

like

Does 2-finger touchpad scroll not work on Excel sheets anymore? I used to be able to swipe quickly on my laptop's touchpad to navigate sheets but now it doesn't work. Based on the handful of posts I've read online about it, the problem seems unresolved. Has anyone dealt with the same issue and fixed it?

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

like

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

What’s the symbol that you can type in a cell so you can input a text, but that text would not appear in the spreadsheet? I want to describe the formula without using a text box, which uses more space.

The equivalent of this is in SQL, you can use the apostrophe in the beginning of and end of a text. That text will not affect the function of the query, but that text can be seen if you proofread the query.

like

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

helpful

Hi excel geniuses, how do I quickly copy info from one cell to blanks for same if. Semi below I have products and names, for the blank fields w same product how do I quickly copy for the rest of the blank cells?

Post Photo

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

Best websites to get more of a handle on Excel as a beginner-intermediate?

like

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

like

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal