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
Posting as :
works at
You are currently posting as works at

Sounds like you want a comment?

In Excel’s Data Validation function you can add an Input Mesage that will appear whenever someone clicks on a specific cell.

Another is to add a Comment which will popup when you click on the cell or can be made to always be displayed.

like

Related Posts

Is Bloodline on Netflix worth watching? Watched the first episode last night and it intrigued me, but wary of the reviews for the following seasons.

like

BE WARY OF FAKE SPRING, NEW CHICAGOANS

likefunny

What can I do with a communication degree and a minor in human Resources

Can you transfer H1B to a different employer? How does it work? Would you have to do the entire process again, including getting your case selected in the H1B cap lottery?

Edward Jones advisor with 30 million AUM and roughly 250k gross production. Been there for almost 4 years. Got an offer at Merrill Lynch to take over a 100 million dollar retirement transition plan in 5 years, or to join a 5 person Merrill Lynch team that manages a lot.

Pros to EJ: Have my own office, a year or two away from partnership, great office setting and client satisfaction.

Pros to Merrill: Bump in compensation, additional tools and services w banking, ability to take over assets.

likehelpful

I find overpositive colleagues so condescending. Is that bad?

like

Anyone on unemployment?

like

Do you expect a salary bump when changing careers? I know the usual suggestion is 20% but that’s often not available when going from Fed consulting -> finance

like

Can someone walk me through the Do's and Don't's of AA miles? I think they're a joke.

I have 65k miles and I could only pay for a one-way ticket from PHX-JFK. I had to book 1 leg with miles and the 1 with cash, but booking the other leg in cash was about 80% of the round trip in cash.

My mom has 12k miles that expire soon, transferring them would cost me $450. I can pay for a round trip with that cash but I can only pay for a trip to my kitchen with those 12k miles.

What am I doing wrong? 😂

like
like

Anyone have multiple FT jobs? I'm looking about to land a new primary FT job, as my current job is very very slow, doesn't really have any projects for me, and could end at any time (with a 30 day notice).
Where there any legal issues? (The two companies area in different industries so no competition). How did you manage both? The new company knows I'm still employed, should I quit the first or keep it as long as I can manage both? Any bad vibes or feelings of unprofessionalism? TIA

like

Looking at fee increases for 2021 tax compliance and probably going for 10% increase with most clients to account for increases to wage levels this year. I’m expecting to negotiate down to 5-8% on some clients. With producer price index at 8.6% I’m hoping to successfully sell clients on the reality of higher fees. Those that want to fire me over fees I feel ok losing clients with decreasing profitability that can be replaced within a year. What kind of increase are you pursuing?

like

Can someone send me the invite for Accounting fishbowl?

like

How is the lay-off outlook for A&C (R&IA) in USDC

like

Are BB also hiring like crazy right now, or is it just M? And if I started at my current place like 3 months ago and let's say I get an offer from a MBB, would pivoting be frowned upon or be considered "burning bridges"?

like

Hi, I recently applied to a salesforce company and was selected for an interview. I had interviews with a recruiter, department manager and hiring manager and did well in them all. My final interview was with the CEO which lasted for about 10 minutes. He said he has read the notes from the previous interviews and the recruiter will get in touch with you. What are the chances I do not get this job given that I did well in all 3 interviews leading to the final interview with the CEO?

like

Long, yes... but it's a riot! 😁
Title: © Datarooms Are Paradise 🧾

likehelpfulfunny

Little brother is graduating undergrad with plans to go to grad school. What’s an appropriate cash gift amount?

like

Big 4 Directors (or equivalent): what are typical hours you’re working these days? Currently at mid-tier and contemplating a switch, but generally working 45-55 a week, which isn’t too bad.

like

Do people not like Tumi because they are too expensive or too stereotypical?

Additional Posts in Excel Genius

Our system is really lacking and we do a lot of work outside of it to track data. Currently I’m using Excel to track data from multiple resources, however, it’s so manual and prone to error. Any suggestions to keep the data clean when I have to pull info from multiple places? I’m constantly auditing and we won’t even look at getting a new system until next year :(

Last cell question. Some of my simple models are massive in file size because every tab has a last cell of ~XFD65. But I’m not using anything past ~U100. Continued.

like

Hey, tips for where to look for good excel cheat sheets online? :)

Just created my first macro! Super proud of myself! #humblebrag

likeuplifting

If you follow him on LinkedIn you probably already saw this! Lol 😆 but I totally resonate with the post... 🤣

Post Photo
funnylike

What are the most typical models you all build

likehelpful

I’m trying to go back to the basics. How do you guys structure thoughts around identifying the correlation between 2 variables? A basic example: the number of steps I take in a day and the hours of sleep I got that night.

like

Hi team i have a bit of doubt.
I have an excel sheet where column A is the order numbers. I want to add comments in column G.
There are many repetitions in order numbers but they are all sorted in ascending so all the repetitions are below one another.

If i have a comment, how can i automatically paste that same comment in all the repetitions of that order numbers if i write it in the 1st instance.

Thanks in advance

like

Please help. I was recently hired by a Venture Capital firm that uses MacBooks instead of PCs. I’m extremely efficient with Excel on PCs and am struggling with the transition to Mac. Do any Mac users have a list of keyboard shortcuts that they use frequently, or any other tips/tricks?

likefunny

Can I write a macro that will fill out a table of information based on cells that have comments on them? For example, if G12 has a comment, I want to pull text from that comment + data in A12.

like

How do I stop excel from changing the cell reference to a different column each time I refresh the data pull?
The spreadsheet is connected to an API data pull. Each time I refresh the data it changes the cell reference (SCD_0010) to a different cell e.g. (SCD_0127). How can I stop this?

Post Photo
like

Why when I refresh a query, the table where the query is loaded to just gets duplicate rows? Same with the pivot table that feeds off of that query?

like

Does anyone know how I can conditionally format a table with a sliding scale? I have a value that is supposed to fit in a range. I need the first possible range the number can fit in to be formatted. Thanks

likehelpful

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

like

I have a field in excel that represents the GSID, that I want to concatenate to create a link. Example field GSID is 123-west and the link needs to be www.website/123_west.html for some reason using concatenate with left & right formulas to switch - to _ results in the field throwing an error. Anyone knows of a way to make this work?

like

Any recommend courses (coursera, edx, etc.) people would recommend for user with intermediate experience with excel?

like

Is Macabacus or any other add-in actually worth it for Excel & PPT? In LMM - MM M&A roles.

likehelpful

Google Sheets vs Excel - pros? cons? differences?

likefunnysmarthelpful

At my old firms when I would be using excel and modeling using the font schemes (blue, green, black for hardcode, link, and formula) I could use the “control shift ;” to shift through the schemes. My new firm doesn’t do this. Does anyone know why the shortcut would be different and how I can add it back?

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