Wadashaqeyntu waxay muhiim u tahay goobo badan oo shaqo. Maadaama mashaariicda intooda badani ay u baahan yihiin in faylal ay galaan isticmaaleyaal badan, habayn iskaashi ayaa noqday lama huraan.

Microsoft Excel waa mid ka mid ah barnaamijyada badan ee ay isticmaalaan shirkadaha adduunka oo dhan. Sidan oo kale, baahida buugaagta shaqada ee la wadaago waa muhiim.

Maqaalkan, waxaad ku baran doontaa sida adiga iyo kooxdaada aad u wada shaqayn kartaan adigoo isticmaalaya Excel 2016 iyo noocyada kale ee Excel online.

La wadaag faylalka Excel khadka tooska ah

Haddii aad leedahay isku xirka degaanka, dhammaan isticmaalayaasha shabakada waxay heli karaan fayl kasta. Taas oo keliya ma aha, isbedel kasta oo lagu sameeyo faylka waa lala socon karaa. Waxa kale oo aad dejin kartaa isticmaalayaasha geli kara faylka.

Ka bilow inaad ku kaydiso faylka meel uu geli karo qof kasta oo kooxdaada ah. Waxaad markaas u dejisan kartaa faylkaaga wadashaqeyn.

Ku-daridda Dib-u-eegista Buug-hawleedka La Wadaago

Isticmaalayaasha Xafiiska 365 waxay heli doonaan qaabka Buug-hawleedka La Wadaago^{(Shared Workbook)} oo qarsoodi ahaan u qarsoon. Tani waa sababta oo ah Microsoft waxay ku dhiirigelisaa isticmaalayaasha inay wadaagaan buugaagta shaqada ee internetka.

Waa kan sida aad awood ugu siiso sifada Haddii aad isticmaalayso noocii hore ee Excel , waxaad u gudbi kartaa qaybta ku xigta - Wadaagista Dukumentiga.^{(Sharing a Document.)}

• Tag File > Options > Quick Access Toolbar .

• Hoosta Dooro Amarada Laga soo bilaabo^{(Choose Commands From)} liiska hoos-u-hoosaadka, dooro Dhammaan amarrada^{(All Commands)} . Guji^(Scroll) liiska ilaa aad ka aragto Buug-hawleed Wadaag (Legacy)^{(Share Workbook (Legacy))} oo dooro shaygaas.

• Guji badhanka ku dar^(Add)
• Si la mid ah u samee amarada soo socda:

1. Lasoco Isbedelada (Dhaxalka)
2. Ilaali Wadaagista (Dhaxalka)
3. Is barbar dhig oo ku biir buugaagta shaqada

• Guji OK marka aad dhammayso

Wadaagista dukumeenti

• Tabka dib u eegista^(Review) , dhagsii badhanka Buuga Shaqada Wadaag^{(Share Workbook)} .

Kuwa raacay tillaabooyinka qaybta Tilmaamaha Buug-hawleedka La Wadaago ee La Wadaago^{(Adding Back Shared Workbook Feature)} waxay ka heli doonaan badhanka Buugga^{(Share Workbook)} Shaqada Wadaagga (oo ay la socdaan amarrada kale ee aad ku dartay) ee ku jira Toolbar Helitaanka Degdegga ah^{(Quick Access Toolbar)} .

• Tani waxay soo jeedin doontaa in sanduuqa wada hadalka uu soo baxo. Sax ikhtiyaarka awood u siinaya sifada buugaagta shaqada ee la wadaago.

• U gudub tab Advanced oo awood Track Changes iyo dejinta kale ee laga yaabo inaad rabto inaad shido.

Ilaali Galkaaga

Talaabooyinka kore waxay siinayaan qof walba marin u helka faylkaaga. Laakiin sidoo kale waxay siinaysaa qof walba marin u helitaan maamul si caadi ah. Ilaalinta faylkaaga macnaheedu waa gelitaanka faylka waa la xaddidi doonaa lana raad raaci doonaa.

• Tag tab dib u eegista^(Review) oo dhagsii Ilaalinta oo Wadaag^{(Protect and Share Workbook)} badhanka Buuga Shaqada.
• Ku sax Sanduuqa Saxeexa Wadaagista Isbeddellada Track^{(Sharing With Track Changes)} -ga .

• Waa inaad sidoo kale samaysaa furaha sirta ah haddii kale qof kastaa wuu ku celin karaa buug-gacmeedka goobtiisii ​​asalka ahayd.
• Badbaadada isbedeladaada oo bax

La wadaag faylalka Excel Online

Inta aad ka shaqaynayso qad la'aanta waa xal fiican, waxa kugu carqaladaynaya baahida loo qabo wadista deegaanka ee la wadaago. Ka shaqaynta khadka tooska ah ayaa cad inay tahay doorashada ugu fiican. Waa kan sida aad u sameyso

Isticmaalka OneDrive

• Fur faylka oo tag File > Share > Save to Cloud .

• Ku martiqaad dadka aad rabto inaad la shaqeyso adoo gelaya ciwaankooda iimaylka. Waxa kale oo aad dejin kartaa dejinta oggolaanshaha.
• Dhagsii Share marka aad dhameysato

Isticmaalka Google Drive

Google Drive malaha waa habka ugu fudud ee isku mar looga wada shaqeeyo mashruuca. Qof kasta oo leh koontada Google ayaa geli kara faylasha oo wax ka beddeli kara haddii loo baahdo.

• Gal akoonkaaga oo aad Google Drive .
• Markaad gudaha gasho, waxaad samayn kartaa fayl cusub ama aad soo geli kartaa mid jira.

• Marka dukumeentiga la sameeyo ama la soo geliyo, dhagsii badhanka Share ee ku yaal geeska sare ee midig ee xaashida shaqada.

Tani waxay ku siin doontaa ikhtiyaarka aad ku wadaagto xaashida xaashida adiga oo gelaya ciwaanka iimaylka ama adoo la wadaagaya xidhiidhka asxaabtaada.

Dhammaan isbeddellada si toos ah ayaa loola socdaa oo loo kaydiyaa Waxaad si wadajir ah uga wada shaqayn kartaan dukumeentiga wakhtiga dhabta ah taas oo ah mid aad u habboon.

How To Share An Excel File For Easy Collaboration

Collaboration is important in many work spaces. Since most projects require files to be accеssed by a lot of users, collaborative setups have becomе necessаry.

Microsoft Excel is one is just one of the many programs used by companies worldwide. As such, the need for shared workbooks is crucial.

In this post, you’ll learn how you and your team can collaborate using Excel 2016 and other versions of Excel online.

Share Excel Files Offline

If you have a local area connection, all users in the network can have access to any file. Not only that, any changes made to the file can be tracked. You can also set which users would have access to the file.

Start by saving the file in a location that can be accessed by everyone in your group. You can then set your file for collaboration.

Adding Back Shared Workbook Feature

Office 365 users will find the Shared Workbook feature hidden by default. This is because Microsoft encourages users to share workbooks online.

Here’s how you enable the feature. If you’re using an older version of Excel, you can skip to the succeeding section – Sharing a Document.

• Go to File > Options > Quick Access Toolbar.

• Under the Choose Commands From drop-down menu, select All Commands. Scroll through the list until you see Share Workbook (Legacy) and select that item.

• Click the Add button.
• Do the same for the following commands:

1. Track Changes (Legacy)
2. Protect Sharing (Legacy)
3. Compare and Merge Workbooks

• Click OK when you’re done.

Sharing a Document

• On the Review tab, click the Share Workbook button.

Those who followed the steps in the Adding Back Shared Workbook Feature section will find the Share Workbook button (along with the other commands you added) in the Quick Access Toolbar instead.

• This will prompt a dialog box to appear. Tick the option that enables the shared workbooks feature.

• Head over to the Advanced tab and enable Track Changes and other settings you might want to turn on.

Protect Your File

The steps above give everyone access to your file. But it also gives everyone administrative access by default. Protecting your file means access to the file will be limited and tracked.

• Go to the Review tab and click the Protect and Share Workbook button.
• Tick the Sharing With Track Changes check box.

• You should also create a password otherwise anyone can revert the workbook to its original settings.
• Save your changes and exit.

Share Excel Files Online

While working offline is a great solution, you’re hampered by the necessity for a shared local drive. Working online is clearly the better choice. Here’s how you do it.

Using OneDrive

• Open the file and go to File > Share > Save to Cloud.

• Invite people you’d want to collaborate with by entering their email address. You can also set the permission settings.
• Click Share when you’re finished.

Using Google Drive

Google Drive is probably the easiest way to work on a project simultaneously. Anyone with a Google account can access files and edit as needed.

• Log into your account and go to Google Drive.
• Once you’re in, you can create a new file or upload an existing one.

• Once your document has been created or uploaded, click the Share button on the upper-right corner of the worksheet.

This will give you the option to share the spreadsheet by entering an email address or by sharing a link to your colleagues.

All changes are automatically tracked and saved. You can work on the document together in real-time which is very convenient.

Related posts

• Sida loo tirtiro khadadka banaan ee Excel

• Sida loo Isticmaalo Tilmaamaha Unugyada Hadalka ee Excel

• Sida loo Geliyo Xaashida Shaqada ee Excel Word Doc

• Sida loo isticmaalo Excel's What-If Analysis

• Faylka Xogta Muuqaalka Lama Geli karo: 4 Hagaajin La Isku Dayo

• Sida Loo Abuuro VBA Macro Ama Script gudaha Excel

• Xarunta Xogta Xaashida Shaqada ee Excel si loo daabaco

• Sida Dhakhso Loo Geliyo Safaf Badan gudaha Excel

• Sida loo xisaabiyo Z-Score gudaha Excel

• Sida loo sameeyo shaxda Pie ee Excel

• U isticmaal Magacyada Range Dynamic ee Excel si aad u Dejiso Dabcida

• Adeegsiga Qalab Raadinta Hadafka ee Excel Maxaa-Haddii Falanqaynta

• Sida Loo Sameeyo Shaxda Pivot Fudud ee Excel

• 4 siyaabood oo Excel loogu badalo Google Sheets

• Safka Kooxda iyo Tiirarka ku jira xaashida shaqada ee Excel

• Sida looga saaro Gridlines gudaha Excel

• Hagaha VBA Sare ee MS Excel

• Sida Loo Isticmaalo Shaqada PMT ee Excel

• Waa maxay VBA Array ee Excel iyo Sida loo Barnaamijyo Mid

• Hal-Column iyo Xog-urur badan oo Aasaaska ah oo ku kala soocida xaashida faafinta ee Excel