I have a large dataset and when I filter, I keep getting up pop ups that say “fixed objects will move”. How do I get this to stop?

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

From The Google. Looks like you probably have something like a comment in one of your cells that's causing grief.

Post Photo
like

For some reason, someone, somewhere, decided it was a good idea to insert a fixed object in your dataset

Use the go to (F5), special, objects and either delete or unfix those objects. Cell comments are not objects, so use the review tab to show all and exlcude/unfix those as well.

P.s.: I've seen a vba code to clear those, but I don't think I've saved those - quick Google search should give u this, if I'm not mistaken

like

I’ll take a look for a vba code

Related Posts

How long is an acceptable amount of time to read a 10-Q to “familiarize myself with the client”? Partner said, don’t worry about how much I’m billing but then “but don’t make a career out of it”. Do I just ask?

like

Applied for a position in PWC UK and status shows as 'interviewin' on workday. Does this mean I'm selected for an Interview, or that the position itself is now in the interviewing process.

Hi Fishes,

Any one looking for any job change as a SCM business Consultant

Required YOE : min 3 years
Role: SCM business Consultant
Skill set required: sql (oracle prefered), basic idea about enterprise systems, inventory management.

If any one intrested kindly ldm me for referal.

like

Admitted folks going this fall. Anyone else having cold feet?

like

Searching for an analyst position. I have 3YOE in statistical modeling and machine learning. I have all my experience in academia in developing end to end models.
Can anyone help to find a position in India?

like

Is there any coding program requires MS degree so I can use mine and get hired quick?

like

Dear fishes,
I need 11 hearts/likes to enable the chatting option..Thanks for your help..

like

How much salary can we expect from Apple India for SAP functional consultant with 15 YOE? Do they offer based on CCTC or their own salary standards for specific role? Please let me know your observations or experience with Apple India offices?

like

Unassigned tomorrow through Friday. Guess I’m being coached out. Saves me a busy season🤷🏼‍♂️🤷🏼‍♂️🤷🏼‍♂️

like

A friendly reminder to LGA folk — that stupid on-ramp adds 15-20m to your travel time. T minus 45 so here’s hoping the TSA haven’t messed up CLEAR and precheck.

likehelpful

Where’s the line between giving your leaders the benefit of the doubt vs this pattern is pretty dang toxic? I don’t want to leave but I’m so exhausted by the gate-keeping, the self-interest of leaders lacking any kind of employee first mentality, and the lip service of “we want to make this the best place to work.” I’m being told I’m under-utilized but when I try to bring more to the table, I’m either given empty promises or immediately dismissed. - I’m severely burnt out on trust-fails.

likesmart

Hi All,

Greetings!

Can anyone please help me referring for Azure Data Engineer Role, YOE 3 years.

Reason: I am activity looking for a change as done with Firm Intiatives of Deloitte USI even they are not compulsory now.

Please drop your email ids in comment box (if comfortable) so i can share my profile with you.

Thanks in advance!

MBA in AML?? Can someone advice if I should pursue MBA? I’m currently working in AML, have 8years of banking experience. Will this help in any shape or form to progress in my career. Thanks!

I am currently seeking a role in Healthcare Policy Leadership in the DC Market, my experience has been in in the intersection of Healthcare & Social Services in both the Private and NonProfit sector. I have a BA in Forensic Psych, an MPA, an MPhil in Public Policy and currently in the last leg of my PH.D in Public Policy with a specialization in Health Policy.

I would appreciate any advice anyone could give that might point me in the direction of any open roles.

like
like

Is it a good time to switch jobs

like

Hi Team, I was part of the layoff at Elastic last week. Our whole midmarket AE department was eliminated.
Does someone hire for a midmarket/commercial AE position in The Netherlands?
I am a native German speaker. Of course I already applied via LinkedIn, but I urgently need a new job in January.
Thanks everyone!

like

Is anyone willing to provide a referral? My current contract is coming to an end in 2 months and I’ve had little luck securing another offer in the last few months I’ve been recruiting, even after a few final rounds. Would appreciate any help!

like

Left Accenture 10 years ago... can someone remind me what the ESPP offering period(s) were and when stock was purchased? Was it 1 or 2 offering periods per year? And what were the months of each?

like

Has anyone in PMO been able to shift into Product Management Operations aka Product Ops?

like

Additional Posts in Excel Genius

I want to do a vlookup on 2 tabs, but identifier is slightly different in some cases (I.e. an space after or a dash in between 2 words that is not in one of the tabs). What’s the best solution?

like

What's the equivalent to a sumifs formula but instead of #s I want to bring in names. For example, i want to return a client name but only if it meets two criteria.

like

Does anyone know of a good excel training online (pivot tables…filters…) ? (Preferably free)

like

Been in consulting for over a year and wondering what other formulas other than index/match and vmatch is useful.

Trying to count the maximum number of overlaps in at a given time in a series of date ranges. Finding an overlap is easy, but not sure how to cycle through date ranges while keeping a Max count

like

Right click menu. If you have a Logitech keyboard with no key to access the right click menu, press FN and F10 to pop open the menu. Very handy when you are trying to lose the mouse.

like

Alright. I am very much so not an Excel genius; I have the Excel skills of your 90 year old grandma who just owns a Jitterbug. Im semi-tech savvy (young millennial), but I’m new to corporate after transitioning into my role from the classroom. Among some skills I know I need, understanding basic Excel functionality is the most immediate. Does anyone have any recommendations for a very novice look into Excel? Thank you in advance!

like

Best pdf to excel converter?

like

To all heavy Excel users, what brand laptop are you using and how’s it working for you?

like

Anyone ever dealt with grouped rows / columns inexplicably stopping working? I have a big and pretty important model which uses grouped rows a lot (to click the plus and pop out more detail), and yesterday I opened it and it’s just all hidden instead of grouped. Any ideas how to fix?

like

Not Excel but Outlook: anyone know how to make it so others can’t recall messages from your inbox?

like

I’m looking to get a second laptop strictly for the use of excel & financial modelling. I currently have a Mac and would prefer to spend around $500 CAD. Any suggestions?

like

Feeling behind at work. I’m relatively new to data/financial modeling. Any advice on learning how to take a client data set, cleaning it up, and turning it into a model for analysis? I’m a new consultant at a boutique and I’ve basically received no training at my company on how to use Excel to do this. Additionally, is this fair game for a new analyst to understand how to do this without any prior training?

like

Any macro experts that can help changing this 3 generation family tree generator to a 6 generation one (template link provided in comment below)? Provided by Microsoft but I have no idea how to edit this macro to allow more generations, and this is the easiest to generate template I've seen unfortunately

like

Looking to use an XIRR formula with an “As of” date option (as of 12/31, 9/30, etc…) So it would essentially stop pulling dates and values once it hits the date in the “as of” date cell.

Any ideas? Much appreciated.

like

I know this is for excel, but any Tableau experts here can let me know how to present my mixed (countries, states, provinces) data on a map. I’ve tried dual axis but still not where I want it to be.

like

Does anyone have experience setting up automated queries on Excel for Mac? I am trying to automate a paid search pacing document but am running into an issue with the Excel Power Query not being able to log in to Search Ads 360.

like

Can anyone recommend good learning resources for excel? I’ve used it for years and am familiar with all the vlookups & index matches but would like to grow my skills beyond that... TIA

like

Does anyone know why negative IRR sometimes gives you a NUM error? A lot of googling and experimenting but cannot pin down what’s going on.

like

Would you rather use Excel versus CRM to store data and manage records? If so, why?

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