My excel columns have switched to numbers (so I know have numbers for columns and rows). This has also made all of my formulas incredibly confusing. Was this part of some update? How can I switch my columns back to letters?

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

Sounds like your preferences got switch to R1C1

like

If you navigate to excel options, and within the formulas tab, is the R1C1 option checked?

like

Yes, it was. THANK YOU!

like

Please tell me I can mess with someone using this

like

Yes

likeuplifting

What version are you using? Mine did not update

Related Posts

Please share HRBP Interview experience of L&T.Also, please share reference. Thanks!

like

Anyone get laid off while on a work visa during Covid? What did the days/weeks after look like for you? What did your agency do for you, if anything? A bit worried and trying to be prepared for the worst case.

like

So, if you’re an ACD in nyc and youre gonna move to the burbs w/ 2 toddlers and a CD husband...are there ANY shops in Westchester or CT? The commute with kids seems rough.

like

How much should a Risk management Associate be making in the Fund Manco UCITS/AIFM space in Europe, I feel I’m very underpaid earning well under 30 k a year

like

How do non-generalists roles at MBB compare with generalist/BA roles? Roles like digital/implementation/data /research analysts.

like

How easily can someone from Europe move to New York for work (in finance)?

like

I studied anthropology in college. Thinking of getting my SIE, series 7 and 63. Would this be a good advance my career or is there anything else you 🐟 would recommend? 1.5 YOE and trying to make moves

like

Has anyone ever started a REIT in Canada or a fund of some sort. For Rea estate investment

like

I really get irritated by the MNC's having aptitude/logical reasoning test before going for the interview. I am not good at Aptitude and LR, but i am good at my work. Since last two years, I have got outstanding rating with excellent communication skills twice.

What should i do on this aptitude and LR hurdle?

like

If you leave big 4 but come back, is paternity / maternity leave count your years of service prior to leaving? Or does the clock start fresh. Wondering if I would be eligible based on service prior to leaving.

like

Everyone on this website uses relatively acceptable punctuation. It’s oddly calming.

likefunny

The hardest part I'm having w/my FIRE Journey is sticking to the plan & not quitting my job now. I'd be ok if I did, but I want better than ok, + a cushion. Plus, I have 2 kids to put thru college.

like

Hey everyone! Receiving an offer this week (recruiter informed) and wanted to know if Google is already accounting for inflation in their offers?

like

Last week, I mentioned that I needed to take an appointment (my therapy appointment) this Wednesday at noon. I also mentioned that this is a medical appointment, and I don’t feel comfortable moving the appointment. I just received an email that I need to be available. How can I stick to my boundary?

Are there any good movies or novels that show skill development - like follow through? Self-management? Money management? I read a lot of self help books so I know a lot of the theory, and books peppered with examples help, but I feel like most 1 paragraph examples don’t five justice to how hard it may be to change a behavior.

like

Hi I am looking for job change , currently Working in Tata consultancy services Pvt Ltd with 1.10 years of experience.

I have experience in cloud domain with skill set consisting of - golang, kubernetes, docker, ci/cd methodology, slack , GitHub , linux , logDna , Sysdig . Do let me know if it's any vacant position matching my skill set or any suitable postions .

Thankyou

like

I have been applying to federal jobs for six months and have been rejected every time. Is it even possible for non-veterans to get federal jobs? Any tips?

like

Why’re all FSO practices hiring data and analytics people when FSO already have a DNA practice? Is DNA only a higher cost Cognizant or Tata?

like

Hi fishes. I am having 4 years of experience in Rpa UiPath. Coforge is paying me 21 lpa and 1.05 lpa variable and Ey GDS is paying 17 lpa fixed. Which one is better?

Hi Fishes,

My LWD is 14th March 2022. I work as a DevOps Engineer and got 2.10 month of experience. Currently looking out for referral. Please do let me know if any leads. Would be highly appreciated. Thanks :)
YOE - 2.10 years of Experience in AWS DevOps
Current location - Bangalore
(

like

Additional Posts in Excel Genius

How would I create subtotal rows in a table? A true table, I dont want to turn my table into a range because I need the other sorting features.

likehelpful

Hello Everyone,
I would like to create a schedule for all of my clients. Let’s say I have platinum, gold clients etc. What would be the best way for me to schedule a call for them based on their profile of gold or platinum? For example, I would start scheduling a call every month for my top clients, then a call every quarter for other categories… I need to track the data, and make sure employees are calling them… something that would alert my employees to call such clients. Thanks!

like

Help this is probably dumb. I have a workbook with 30 tabs. Is there a quick way to separate each in to its own book or should I copy one a time?

like

Anyone have thoughts on best VBA/macro training out there? I find there are so many things I could automate and need a good place to learn the basics (particularly for excel).

like

does anyone know what CVS medical excel assessment for finance analyst consist of? I have an interview in a few hours

like

Help, simple task can’t figure it or. List of user names in one sheet compare to another list on another sheet and highlight duplicates.

like

Does anyone know if Excel is compatable with Adobe Sign/PDF? I'm trying to automate data entry from Adobe sign/PDF to an Excel sheet. Adobe

like

My Goal: I have a drop down menu in a cell. I want it to sort conditionally based on what I select. Is that possible?
Ex: If the drop down ="done" it falls to the bottom of the list.

like

Is there any way to compare multiple index match formulas. Looking to find a match across three different tables on three different tabs. Most I’ve seen is using if error to compare 2.

like

Need to build a macro or python script to convert client spreadsheets to an import template. They are storing a process ID, metadata asset 1 (col B), metadata asset 1 attribute 1, asset 2 (col D), and asset 2 attribute on a single line. On our template, that should be 2 rows and then assign certain values based on the row being populated by col B/D. At a high level does this sound macro worthy or just start with python? I can give more details if needed.

like

I'd like to know if anyone has ever pressed the excel help key (f1) on purpose. It is literally the most useless and obnoxious shortcut for excel. I accidentally press it 5 times a day at least.

likefunny

Hi all!
I have a file that is full of hyperlinks to different files in another folder.
I moved the location of tbe original fil and hyperlinks stopped working.
Now I also want to move the location of the hyperlinks folder.
Is there a way of fixing the links? (File names are still the same)

like

Hi Geniuses. I’m needing to write some compounded if statements and use VSlookup to analyze, group and report based on data in a dataset. Anyone have a decent learning source? Google and YouTube have returned some hard to follow, bad results that miss the mark.

like

Does anyone here use ASAP Utilites as an Excel add-in? This thing is amazing.

like

How TF do I attach the SharePoint version of a slide deck in an email? Every time I try to share, it gives me the link in the email body instead of an actual attachment to open in app. PLEASE AND THANK YOU

like

Thoughts on creating a dynamic remove duplicates model, where someone can place raw data in one tab without having to manipulate? I've used if(index=min) which works but anyone have a better way..

like

I have to revert a scale of 1-13 to 1-5, any advice on how to do / automate this? TIA 🙌🏽

like

Is there a way to calculate the sum to $150. Sum if doesn’t work assuming Col A is only counted in 1 cell. Prefer not to change the layout of column A-C. . Thanks

Post Photo
like

Story time: I was on a trip about 15 years back, doing some Excel work on a ferry ride - your basic pseudo-database work that is so common. I started talking with the guy sitting next to me and after a while he commented on what I was doing, “You know, that’s really not what I designed that for…” (continued)

likefunny

Has anybody used the COM library and python to build reports? I'm looking for somebody to chat with about my project.

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

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

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