There has to be a way to restrict access on a worksheet so that only specific cells can be edited.

No matter how many times I’ve tried to automate and simplify generating reports to just inputting data into specific highlighted boxes, someone just have to try to edit a completely different cell then asking why the worksheet is “broken.”

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

If you turn on data validation in the non-highlighted fields, and then make the expected list entry N/A, you could create a validation message saying something like, “Data can only be entered in the highlighted cells, return to the spreadsheet and look for the highlighted cells”

like

You can lock cells with a password

like

Protect sheet and lock cells

like

Protect the whole sheet and then select cells that you want to be edited, format cells, protection tab, uncheck "Locked"

like

Related Posts

Unfortunately true 😔 I wish I wasn't this way

Post Photo
like

What is comicon all about?

like

Hi guys.. I wanted to know what should be the ideal number of ATL and BTL activities in year for a consumer durable company? Considering x as the number of product lines/sub brands.
TIA

like

As a junior, should we still be overworked and underpaid in 2020? But also given COVID, does it all come down to ‘take what you can get?’

like

As a production company, it must be difficult to base your series on books that have not been finished. Like the Game of Thrones saga (not the best example of success, tbh). Is it worth it to try to "invent" the outcome or is it better to go with stories that have a complete storyline?

like

Anyone Accenture UK fish know what happens to your health insurance after you quit? How long are you covered for by AXA?

like

Hello Everyone..Anyone who knows about the Salary range of Manager L2 in PWC AC Blore under Business Acumen team?

like

What is the monthly cost of living in Cardiff which includes rent for 1 bed room, council tax ,Utilities?

How many lbs were you up in weight around week 14?

like

Having trouble coming up with topics/agenda for 1:1s with my manager...

What do you talk about in yours?

like

Most cringeworthy pickup lines you’ve seen on dating apps?
I’ll start: “Are you my appendix cuz I want to take you out”

likefunny

Csn anyone tell where can we specify the FBP in IBM?

Does anyone have suggestions on resources to quickly get up to speed on the basics of a software license agreement?

like

Hii Sharks,
I'm a year old in this corporate world and I'm working in a non tech field.
I heard the rumours that growth is not a function of time in this field. You wont be paid much as compared to the techies.

Should i switch to tech and start learning coding?

Please help...

I am a Test automation Lead and have 13 years of experience in Software testing (zero job switch) and have been a consistent good/average performer. What shud be my bare minimum salary per annum?

like

How different is Consulting roles from Technology roles. Which is better?

I got Senior Associate Consultant Level 4a from Infy as a lateral with 4 years experience. How much can I ask during negotiation with HR?

like

Looking to broaden my knowledge and explore project management in near future. Should I go for MBA or Engineering management masters?

like

Hello guys. I am currently a Business analyst in the supply chain industry supporting operations. Currently graduating with my MBA this month with a GPA:3.92 and looking for entry position at the Big 4 or Big tech company and any references/referral would really be helpful. It’s been a lot applying and not so easy landing a position. Thanks

like

Additional Posts in Excel Genius

I can finally use index match. I feel like such a genius

likeupliftingfunny

I'm stumped!
Coworker creates "Sheet A" with invoice numbers
I use Monarch to extract invoice #'s and amounts from another report.
I do a pivot table to compile amounts by invoice. I copy those results to "Sheet Z".
I then do an @vlookup on Sheet A referencing Sheet Z (just the invoice # and amount).
It isn't working unless I go to Sheet Z and type over the invoice # (same number)! All invoice #'s are absolute and in the same font & alignment. Workbook has 10 yrs data. Has worked in past!

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

Hi, in my excel pivot table slicer I have my options and then (blanks) option , anyway to get rid of that?

I’m looking to make a supplier list where I can just filter on certain requirements to get a smaller list…currently creating as a pivot table but is there any other options that make sense?

Post Photo
like

Is there a way/shortcut, without using a mouse to drag cells down, to fill a range of data following a trend? I want a column with the first day of each month up to a certain date (row number). Thanks

How do you calculate the “rate of change” within excel? I am comparing the number of bugs from one week to another.

like

Anyone have good tips for automating presentations/data visualization in PPT? These charts/graphs are pretty elementary so I’d rather steer clear of Power BI/Tableau if i can (no idea how to use and don’t have time to learn now) - just want to avoid pasting in dozens of charts into a PPT over and over each month.

like

Hi! Disclaimer: not an excel genius…

I’m trying to use the lookup function to grab data from a worksheet within the same workbook. I want the column to reference the cost code in one worksheet, find the cost code in the other and display the billed to date associated with it. The problem is that it repeats an amount randomly. There will be multiples then a blank cell in one that I know has a cost associated with it.
Formula=LOOKUP(D3,!Sheet!$D:$D,!Sheet!$H:$H)

like

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

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

like

Matching Data into Same Row

This may be simple or complicated:
I have a data set that is divided into 6 columns. I need to combine some of the rows together based off matching data.

What needs to happen is everyone with the same Bus Driver, needs to populate into the same row. Instead of the same Bus Driver being listed twice in the column.

For The names I plan on labeling them Person 1 | Person 2 | Person 3 | Person 4 | Person 5

I attached a smaller data set for an example

Post Photo
likehelpful

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

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

Anyone know of an Excel plugin that acts as a reference calendar for Federal Reserve holidays (and those observed)?

like

Anyone kind enough to help me start a PE fund model with a waterfall.
Struggling to get started.

like

Does anyone have an excel test they can share (or point me to something online) that you use during the interviewing process to evaluate candidates? Not looking for an excel expert but definitely need someone who knows more than the sum function

like

I’m trying to consolidated planning of FTEs from weeks to fiscal periods in a new table. If my column heading in the original table is 1, 2, 3 etc and my new table is Period 1, Period 2 etc
What is the most efficient formula to do this? Just doing =sum(Hours!E7:H7) for each period will take forever… thank you!!

like

Any one good with Tableau I have a question

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

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

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