How to Share Only One Tab in Google Sheets

[@EtimAntai-or2rs]

Thank you sir for this, it is indeed amazing, however, I would link to know if it is possible to share only a single sheet without changing the formatting of the original sheet

[@GustavoMontanha]

it does not copy the formatting - is there a way to also copy the looks and formatting of the original sheet?

[@Spitt94]

Copy everything from the tab, paste it (with looks & formatng), clear all the cells, then put the function on the A1 cell

[@monicaquinn2359]

This worked great for me except when I went to sort the new sheet by column A, it bumped all of the data down to row 324 leaving rows 1-323 empty. Any thoughts on that?

[@hardheadedparanoia]

hello, how can i make the shared sheets editable and will automatically update the original?

[@google_sheet]

You can't edit the shared sheet's imported data.

[@MaiToi100]

So this will allow shared user access as editor or veiwer only?

[@HeatherMorrow-x8x]

Question: When it imported into the new sheet, it only imported the cell data but none of the formula's, colors, etc. How do I make sure it copies the exact sheet?

[@matthewhay8141]

This would be great if both master and copy could be updated. I need my employees to be able to add information as they go but need each employee to be private. This only works with me sharing info with them not in reverse.

[@CictionalFharachter]

Is there a way around?

[@ryanshetler2692]

This works BUT, I can't add anything. If I add something everything disappears b/c it's not referenced correctly. How can someone share one tab and both people be able to work on it and change it?

[@AmirAkram-s3j]

*Is it possible to share only one tab of a google sheet with editing permission and not share the whole sheet?) (while staying in the same sheet)*

[@talhazahid5390]

If in new sheet we will add new subsheet it's also link with master sheet?

[@camilleorta7769]

How do I keep the sheets formatted like the original one when it is shared?

[@ModernSchoolBus]

If you are losing the formatting when you import the only way to format like the original may be to use the paint format tool to manually copy the formatting from the original to the new one.

[@cynthiabell1734]

@@ModernSchoolBus I need the same thing as this person, but I also need my validations and locks to copy over as well.

[@ashishtonger]

I want to share a single sheet, With a single editable cell (users can select from the drop down only )

[@AARONJMCDANIEL]

Is there two way editing on both the new sheet and the old sheet? I attempted to edit the new sheet, but it gave me an error?

[@ModernSchoolBus]

The new sheet is just imported so you would have to edit the original to change the new sheet. If you really want to edit them separately, you would just need to copy the new sheet and paste as value to remove the formulas so that they are no longer linked

[@a.bhoneshkumar9618]

Is it possible to share only one tab of parent sheet without creating child sheet....?

[@mohjimy6887]

This is what i need

[@ANNNYGREN]

Great video! Question---on the new sheet---will the person be able to make edits and will those be reflected back on the initial sheet with all of the tabs?

[@salahuddeengirei2213]

I tried to do this but it keep saying "You don't have permission to access that spreadsheet" i.e the primary spreadsheet. what should I do please??

[@ModernSchoolBus]

The section at 2:50 and the section at 3:19 in the video show allowing access to the sheets. I'm not sure which one will solve your issue.

[@AhmedShehata-ve3qw]

is there any way to make it directly with code?

[@ujsattar]

Great, Thanks, Realy a big help!

[@Jackjohn2000]

Hey, when you import it into a new sheet to share, but then you update the original, will it update the new sheet? thanks :)

[@ModernSchoolBus]

Yes, it will update in the new sheet if you make any changes to the original one.

[@mpom711]

What about in reverse? If the second sheet is updated, will the master be updated as well?

[@ModernSchoolBus]

@@mpom711 No. The second sheet is imported from the first. So changing the second sheet will never update the first.

[@jithinalunkal]

@@ModernSchoolBus When I use Importrage it shows I don't have access to the sheet instead of allowing access, where I am the owner for both files. how to provide that access

[@ModernSchoolBus]

@@jithinalunkal If you are the owner of both sheets you should be able to allow access just like in the video at 2:50. You will have to make sure you are the owner of both sheets in the same gmail account. I would double-check your spreadsheet URLs if this isn't working because it should work just like in the video

[@FranciscoEscofetVillalvazo]

Very Useful Muchas gracias!

[@sarcasticjas]

Thanks buddy ❤

[@ModernSchoolBus]

Glad you found it useful!

[@trainingagah]

Perfect. it worked.

[@namorcaz]

Thank you bro!

[@PosessedFurby]

you the man

[@zolalola90]

Thanks!

[@learnfootball9125]

Thank you

[@jendo6354]

But does the data update on the new sheet if you change it from the original?

[@google_sheet]

Yes, it will auto-update