How do I leave certain cells in an Excel spreedsheet unlocked so that other users can modify them?

How do I leave certain cells in an Excel spreedsheet unlocked so that other users can modify them?
by

1 Answer

Answer :

I wonder if the fact that the cells I’m trying to leave unlocked are merged is part of what is creating this problem…?
by

Related questions

If your child had a ”gay gene”, or a sequence of genes leading to gayness, would you leave it unaltered if there was a way to eliminate, or modify it?

Description : If your child had a ”gay gene”, or a sequence of genes leading to gayness, would you leave it unaltered if there was a way to eliminate, or modify it?

Last Answer : I am not perfect and neither are my kids and I would not change a thing.

Ebay search question. Is it possible to search on ebay for all "except" certain items? eg: unlocked cell phones "except motorola"?

Description : Ebay search question. Is it possible to search on ebay for all "except" certain items? eg: unlocked cell phones "except motorola"?

Last Answer : I don’t think so. I would think that that would make motorola phones come up even more seeing as it searches mostly for the key words of the search.

Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet? 1) Use CTRL to select all three cells, then click the Paste Button image button on the Standard toolbar 2) Copy the selected cell, then select the other two cells, click Style on the Format menu, then click Modify 3) Click Format Painter Button image on the Formatting toolbar twice, then click in each cell you want to copy the formatting to 4) Use Alt to select all three cells, then click the Paste Button image button on the Standard toolbar

Description : Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet? 1) Use CTRL to select all three cells, then click the Paste Button image button ... ) Use Alt to select all three cells, then click the Paste Button image button on the Standard toolbar

Last Answer : 3) Click Format Painter Button image on the Formatting toolbar twice, then click in each cell you want to

In Excel“““.allows users to bring together copiesof work-books that otherusers have worked on independently. (A) Copying (B) Merging (C) Pasting (D) Compiling (E) None of these

Description : In Excel“““.allows users to bring together copiesof work-books that otherusers have worked on independently. (A) Copying (B) Merging (C) Pasting (D) Compiling (E) None of these

Last Answer : Merging

what is an Unlocked Iphone?

Description : what is an Unlocked Iphone?

Last Answer : I believe it is unlocked so you can use it with any provider. But it would have to be a provider that uses GSM.

Why can't I rename/modify photos/pictures on my PC?

Description : Why can't I rename/modify photos/pictures on my PC?

Last Answer : answer:Just a guess but are you possibly changing the file extension? So it's called zom.jpg and you're changing it to badass_zombie_chick319 but forgetting the .jpg? It's extra goofy because sometimes ... . The error message you're getting is probably the best guide if that doesn't sound right.

How do you replace or modify an application's icon in Ubuntu Linux, running GTK2 and Gnome?

Description : How do you replace or modify an application's icon in Ubuntu Linux, running GTK2 and Gnome?

Last Answer : I thought the icon would have to be in /usr/share/icons/Humanity/apps/ or something like that, but apparently it isn't. However, there is an Abiword icon in /usr/share/pixmaps, so you should be ... also drop yours in /usr/share/icons/Humanity/apps (and then in the folder for the correct sizes).

How to modify guest account properties?

Description : How to modify guest account properties?

Last Answer : In a not so related topic, I found this: Setting your account picture appears to update your address book card at the same time. This means the image is stored along with the rest of the address book ... your situation?- Brainfart! It's a guest account, so it couldn't apply to any name. Sorry!

How do I change/modify my Windows Vista task bar to look more like these:?

Description : How do I change/modify my Windows Vista task bar to look more like these:?

Last Answer : You can use Window Blinds to modify your taskbar,icons, desktop and explorer into literally any style you want. All you have to do is install Window Blinds and then download the appropriate themes from here .Also you can download their theme maker to make your own themes

I promise this will be the last question about blackberries!! If i get the unlocked blackberry pearl that comes with WIFI, and other features, Will i be able to use them all with AT&T?

Description : I promise this will be the last question about blackberries!! If i get the unlocked blackberry pearl that comes with WIFI, and other features, Will i be able to use them all with AT&T?

Last Answer : Mmmm. Blackberries and cream.

Is it true that if you don't log off from a site, you leave certain ports open allowing access to your 'puter?

Description : Is it true that if you don't log off from a site, you leave certain ports open allowing access to your 'puter?

Last Answer : My bank's website specifically warns you to not only log out, but to close the browser window due to possible security breaches. I always assumed it meant someone might access your records on that site, ... on sites with sensitive personal data on them (financial, medical, etc.). Perhaps I'm wrong?

A trader mixes Ariel detergent costing Rs. 64 per kg with “Surf excel” which costs Rs. 76per kg in the ratio 1:3. If the cost of Surf excel drops to Rs.74 per kg, then in what ratio should he mix the two to leave the cost of mixture unchanged? a) 1:9 b) 1:8 c) 9:1 d) 8:1

Description : A trader mixes Ariel detergent costing Rs. 64 per kg with “Surf excel” which costs Rs. 76per kg in the ratio 1:3. If the cost of Surf excel drops to Rs.74 per kg, then in what ratio should he mix the two to leave the cost of mixture unchanged? a) 1:9 b) 1:8 c) 9:1 d) 8:1

Last Answer : a) 1:9

Why do people look at me in such surprise when I tell them I know Word, Excel, Powerpoint, etc?

Description : Why do people look at me in such surprise when I tell them I know Word, Excel, Powerpoint, etc?

Last Answer : You could have written an IF function that automatically enters “Plastic” if it finds “BM”, “BR”, and “IB”, and then paste that function into every cell of the column.

Is there any software that would be able to extract email addresses and put them into an Excel spreadsheet?

Description : Is there any software that would be able to extract email addresses and put them into an Excel spreadsheet?

Last Answer : Yes, but the software would depend on where/how the email addresses are currently stored.

The primary task of a teacher is Options: A) to teach the prescribed curriculum B) to prepare students to pass their examination C) to make them a thinking people D) to modify their behaviour according to the needs of our society and country.

Description : The primary task of a teacher is Options: A) to teach the prescribed curriculum B) to prepare students to pass their examination C) to make them a thinking people D) to modify their behaviour according to the needs of our society and country.

Last Answer : D) to modify their behaviour according to the needs of our society and country. 

How do you paste information from Numbers (like Excel) into Pages (like Word) WITHOUT the grid --- so that just the text shows up, separated by tabs)?

Description : How do you paste information from Numbers (like Excel) into Pages (like Word) WITHOUT the grid --- so that just the text shows up, separated by tabs)?

Last Answer : answer:This is a really clunky solution. In numbers select File -> Export -> Save as PDF. Then you can open that PDF and copy and paste into Pages and it will lose the formating. I wish I knew of a better way. I have been trying for about 20 minutes and that is the best I could come up with.

Got a Sciphone i9++++, A) Does it need to be unlocked? B) If so, how do i unlock it? so that i can use it with my tmobile service?

Description : Got a Sciphone i9++++, A) Does it need to be unlocked? B) If so, how do i unlock it? so that i can use it with my tmobile service?

Last Answer : You can ask directly to a Chinese shop for this: SciPhone

So I'm thinking on getting an unlocked cell phone for my b-day, is this the best choice?,?

Description : So I'm thinking on getting an unlocked cell phone for my b-day, is this the best choice?,?

Last Answer : It depends on your usage and budget. Can't go past a BlackBerry if you can afford one. I use my constantly, for an old guy I do more texting and emailing than most kids. Than most younger ... for browsing, emailing, texting or IM messaging. Some of the other smartphones can bankrupt you. (iPhones.)

Suppose you want to send in the mail a valuable object to a friend. You have a box which is big enough to hold the object. The box has a locking ring which is large enough to have a lock attached and you have several locks with keys. However, your friend does not have the key to any lock that you have. You cannot send the key in an unlocked box since it may be stolen or copied. How do you send the valuable object, locked, to your friend - so it may be opened by your friend? -Riddles

Description : Suppose you want to send in the mail a valuable object to a friend. You have a box which is big enough to hold the object. The box has a locking ring which is large enough to have a lock attached ... you send the valuable object, locked, to your friend - so it may be opened by your friend? -Riddles

Last Answer : Send the box with a lock attached and locked. Your friend attaches his or her own lock and sends the box back to you. You remove your lock and send it back to your friend. Your friend may then remove the lock she or he put on and open the box.

Suppose you want to send in the mail a valuable object to a friend. You have a box which is big enough to hold the object. The box has a locking ring which is large enough to have a lock attached and you have several locks with keys. However, your friend does not have the key to any lock that you have. You cannot send the key in an unlocked box since it may be stolen or copied. How do you send the valuable object, locked, to your friend - so it may be opened by your friend? -Riddles

Description : Suppose you want to send in the mail a valuable object to a friend. You have a box which is big enough to hold the object. The box has a locking ring which is large enough to have a lock attached ... you send the valuable object, locked, to your friend - so it may be opened by your friend? -Riddles

Last Answer : Send the box with a lock attached and locked. Your friend attaches his or her own lock and sends the box back to you. You remove your lock and send it back to your friend. Your friend may then remove the lock she or he put on and open the box.

What's the best way to modify a golf cart so it can't be easily stolen.

Description : What's the best way to modify a golf cart so it can't be easily stolen.

Last Answer : Add a simple kill switch in series with the with the key. Only you will know it’s there.

How to modify car so it will play audio from a flash drive?

Description : How to modify car so it will play audio from a flash drive?

Last Answer : I have a small adapter that plugs into the lighter that accepts sd cards and usb. and plays them through the existing radio. It was relatively inexpensive and works ok although it assuredly produces sound of a lesser quality than one that is wired in directly.

How to modify the website so it ranks high on google?

Description : How to modify the website so it ranks high on google?

Last Answer : The BEST tool for this purpose is actually provided by google themselves. Sign up for webmaster tools, show you are the webmaster (I believe they still require this, but i could be wrong) and ... all the info you need including design guidelines as well as tools. http://www.google.com/webmasters/

Can one modify a for-MySpace graphic so it is visible in a Hotmail email?

Description : Can one modify a for-MySpace graphic so it is visible in a Hotmail email?

Last Answer : no one answered your question : ( Copy paste or save and then add attachment to email

Write the four ways of adding an impedance to an existing system so as to modify bus impedance matrix.

Description : Write the four ways of adding an impedance to an existing system so as to modify bus impedance matrix.

Last Answer : 1. Adding a branch of impedanceZb from a new bus p to the referance bus. 2. Adding a branch of impedance Zb from a new busp to an existing bus. 3. Adding a branch of impedance Zb from an existing busq to the referance bus. 4. Adding a branch of impedance Zb between two existing buses h and q.

Which of the following auditor concerns most likely could be so serious that the auditor concludes that a financial statement audit cannot be conducted? a. The entity has no formal written code of conduct b. The integrity of the entity’s management is suspect c. Procedures requiring segregation of duties are subject to management override d. Management fails to modify prescribed controls for changes in conditions

Description : Which of the following auditor concerns most likely could be so serious that the auditor concludes that a financial statement audit cannot be conducted? a. The entity has no formal written ... subject to management override d. Management fails to modify prescribed controls for changes in conditions

Last Answer : The integrity of the entity’s management is suspect

Would it be more effective to terraform other planets or to modify our own physiology?

Description : Would it be more effective to terraform other planets or to modify our own physiology?

Last Answer : well ethically, I think it would be better to terraform rather than to modify ourselves. I mean, there are ethical implications of terraforming a planet, but to genetically modify ourselves seems much ... , and therefore there are infinite other suitable planets, and you're just using one, hehe.

When the Exxon Valdez oil spill occurred, technologists "fertilized" the oil-soaked water with _____ to modify the environment and stimulate he growth of naturally occurring microorganisms. a. nitrogen sources (e.g., urea) b. phosphorus compounds c. other mineral nutrients d. A-C above are correct

Description : When the Exxon Valdez oil spill occurred, technologists "fertilized" the oil-soaked water with _____ to modify the environment and stimulate he growth of naturally occurring microorganisms. a. nitrogen sources (e.g., urea) b. phosphorus compounds c. other mineral nutrients d. A-C above are correct

Last Answer : d. A-C above are correct

Name the type of proteins that work to catalyze metabolic reactions or can modify other proteins to switch their activity on or off.

Description : Name the type of proteins that work to catalyze metabolic reactions or can modify other proteins to switch their activity on or off.

Last Answer : Enzymes

Google+ users: Will you leave Facebook? If not, why?

Description : Google+ users: Will you leave Facebook? If not, why?

Last Answer : I wouldn’t leave Facebook, I’d just post only on G+. But having a Facebook is still great for stalking connecting with those who don’t have a Google+ account.

How can I average non-adjacent cells in excel, excluding zero?

Description : How can I average non-adjacent cells in excel, excluding zero?

Last Answer : I copied your formula and it’s working for me in Excel 2007, =SUM(B2,D2,F2,H2,J2,L2,N2)/COUNTIF(B2:N2,”>0”)

Does Excel allow you to format cells to view in standard form?

Description : Does Excel allow you to format cells to view in standard form?

Last Answer : Change your settings (format->cells) to something that will display easier. It’s currently rounding. I’m not in front of my computer, but you can format the cells to show data any way you like.

Is there a shortcut to fill cells for excel for mac? I can't figure it out.

Description : Is there a shortcut to fill cells for excel for mac? I can't figure it out.

Last Answer : answer:In Excel 2004 it’s the same—I checked it out on my machine. I don’t have access to Office 2008, but I’m guessing it’s the same. Bonus: control-d is fill down and control-r is fill right.

Which of the following is not a term of MS-Excel? a. Cells b. Rows c. Columns d. Document

Description : Which of the following is not a term of MS-Excel? a. Cells b. Rows c. Columns d. Document

Last Answer : d. Document

Which of the following is not a term of MS-Excel? a. Cells b. Rows c. Columns d. Document

Description : Which of the following is not a term of MS-Excel? a. Cells b. Rows c. Columns d. Document

Last Answer : d. Document

In MS-Excel, which of the following keys helps you to selects all cells below the current selection, up to the edge of the current data region: a) Ctrl + Shift + Down Arrow Key b) Ctrl + Shift + Right Arrow Key c) Ctrl + Shift + D d) None of These

Description : In MS-Excel, which of the following keys helps you to selects all cells below the current selection, up to the edge of the current data region: a) Ctrl + Shift + Down Arrow Key b) Ctrl + Shift + Right Arrow Key c) Ctrl + Shift + D d) None of These

Last Answer : a) Ctrl + Shift + Down Arrow Key

Excel experts: how do I make this kind of a dropdown list (details inside)?

Description : Excel experts: how do I make this kind of a dropdown list (details inside)?

Last Answer : while in Excel, hit F1 key. Type in drop down. This is the MS help function to get you there

Help with an Excel question, I want to center the page on screen?

Description : Help with an Excel question, I want to center the page on screen?

Last Answer : Well, first, in the view tab, uncheck all of the grid lines, formula bars, ruler and headings. Is that more like what you're looking for? Protecting is kind of clunky. First highlight the cells you want to ... It should open up like that for people you send it to. You can practice on me if you want.

Why don't the links work in the Excel work book I emailed?

Description : Why don't the links work in the Excel work book I emailed?

Last Answer : They (links and macros) are on your hard-drive and not part of the attachment, you emailed .

Can you tell me how to do this in Excel?

Description : Can you tell me how to do this in Excel?

Last Answer : answer:Oh hail yes, I figured it out all by my self. Thanks for the HELP!

How can I make this conditional formatting rule in Excel?

Description : How can I make this conditional formatting rule in Excel?

Last Answer : answer:Conditional formatting isn't too difficult, but the interface is unusual (not like other Excel interfaces), so that takes some getting used to. Assuming you know how to access the commands via the menu, I'll ... to a number of cells in B:B. You'll get it if you just keep playing with it.

Is it true you can't send a single tab from excel in an email?

Description : Is it true you can't send a single tab from excel in an email?

Last Answer : I really think the easiest way would be to use a PDF printer driver like Cute PDF Writer to print that one sheet. By design, it really isn't any more of a hassle than printing it out ... different printer ), and partly for compatibility, as they work with any program that has a Print option.

Can you recommend a good book for learning Excel programming and macros?

Description : Can you recommend a good book for learning Excel programming and macros?

Last Answer : answer:Yes, (at least in Office 2010), VBA is still part of the installation package, and highly useful. I would suggest that you start to learn coding on your own, before buying a book ... advice about books, other websites, and even some of the Microsoft MVP websites that many of them maintain.

Do you have a solution for this problem concerning Excel?

Description : Do you have a solution for this problem concerning Excel?

Last Answer : answer:Use the same excel data base saved as a different file with the new year and simply have the person search for their name, and then mark an X in a new column titled Present 2013 ... of elimination) and also will identify anyone attending for the first time. Hope this is helpful somehow.

Is it possible to change the icon on a a saved Excel or Word file?

Description : Is it possible to change the icon on a a saved Excel or Word file?

Last Answer : answer:If you change the extension to something other than one that Windows knows and already associates with Excel, including: .xls .xlsx .xlsm .xlt & etc. then you'll have to make a manual association ... which recognizes the .dxls file type, and still tell it to open with Excel.) Just do it.

Do you know Excel?

Description : Do you know Excel?

Last Answer : Yes, I’ve regularly used Excel for many years. If you ask your question, I’ll be happy to try to answer it.

How else can you correlate data on Excel?

Description : How else can you correlate data on Excel?

Last Answer : Can the data be paired, as in, do you have readings from both machines on the same samples? If yes then yo can plot the dat using Y vs X where Y is the new machine and X is the old. For ... with smooth lines. You now have your chart. Now play with the other options to make it pretty. Good luck.

How do I set defaults in excel?

Description : How do I set defaults in excel?

Last Answer : answer:You can save your tweaked in chart as default chart type; you need to save it as a custom chart type. To do that, follow these steps: 1. Create the chart that you want to use (your tweaked ... this helps (since it's Excel 2003, otherwise you can refer to this post). And here is another link.

Can any of you tell me how to access the embedded games the good engineers at Microsoft insert into Excel?

Description : Can any of you tell me how to access the embedded games the good engineers at Microsoft insert into Excel?

Last Answer : From what I’ve gathered, Vista and 7 don’t have any.

How to export search results from Microsoft Excel?

Description : How to export search results from Microsoft Excel?

Last Answer : answer:If you highlight the labels at the top of each column, then click on the data tab, and the big filter button.. you'll be able to sort out which ones are from New Jersey. ( ... paste those into a new spreadsheet. Without actually seeing an example of your spreadsheet this is my best guess.