Waxaan ahay isticmaale weyn oo Excel ah waxaana had iyo jeer iga yaabiya sida dad yar ay faallooyin ugu daraan xaashiyaha Excel^{(add comments to their Excel spreadsheets)} ! Ku darista iyo adeegsiga faallooyinka Excel waa hab fiican oo lagu sharxo qaaciidooyinka, unugyada, iyo xogta kale ee xaashida lafteeda, sidaas darteed waxay kuu badbaadinaysaa wakhtiga aad taleefanka kula qaadato asxaabtaada! Runtii way fududahay in faallooyinka lagu daro unugyada Excel waxaanan ku sharixi doonaa sida aad sidaas ugu samayn karto Excel XP/2003 , Excel 2007 , Excel 2010 iyo Excel 2013 .

Faallooyinku asal ahaan waa qoraallo la geliyo unug kasta oo Excel ah . Waxay faa'iido u leedahay xasuusinta, qoraallada kuwa kale, iyo tixraacidda buugaagta kale ee shaqada. Ogsoonow in noocyada cusub ee xafiiska ay leeyihiin ikhtiyaar la yiraahdo Show Ink in the toolbar-ka faallooyinka^(Comments) tanina waxay faa'iido u leedahay PC-yada tablet-ka. Sifada asal ahaan waxay kuu ogolaanaysaa inaad gacanta ku qorto faallo halkii aad ka qori lahayd mid. Kombiyuutarrada iyo laptop-yada, in kastoo, ay faa'iido u leedahay daawashada faallooyinka gacanta lagu qoray ee lagu sameeyay PC tablet-ka.

Sidoo kale, waxa jira waxyaabo kale oo badan oo aad ku samayn karto faallooyinka marka aad ku darto xaashida shaqada sida qaabaynta, beddelka qaabka, wax ka beddelka iyo wixii la mid ah. U dhaadhac^(Scroll) xagga hoose ee boostada talooyinkaas.

Ku dar faallooyinka unugga Excel 2013

Excel 2013 wuu ka yara duwan yahay 2010, laakiin guud ahaan waa isku mid. Si aad faallo ugu darto, dhagsii tabka dib u eegista oo guji Faalada ^(Review)Cusub^{(New Comment)} marka aad doorato unugga la rabo.

Hadda uun ku qor faallooyinkaaga oo marka aad ka guurto unuggaas, waxaad arki doontaa saddex xagal cas oo yar oo ku taal geeska sare ee midig ee unugga oo muujinaya in unugu faallo leeyahay.

Ku dar faallooyinka unugga Excel 2010

In Excel 2010 , ku darida faallooyinka waa mid aad u fudud oo la mid ah 2013. Kaliya^(Just) dhagsii tab dib u eegista^(Review) oo waxaad arki doontaa dhammaan qalabka faallooyinka. Guji^(Click) qolka aad rabto inaad ku darto faallooyinka ka dibna dhagsii faallo cusub^{(New Comment)} .

Daaqad yar oo wada hadal ayaa kuu soo baxaysa halkaas oo aad ka bilaabi karto ku qorida qoraalka. Waxa kale oo aad arki doontaa saddexagalka yar ee cas ee midigta sare ee unugga, kaas oo halkaas u yaal si loo muujiyo in unugu leeyahay faallo.

Waxaad si dhakhso ah u arki kartaa dhammaan faallooyinka xaashida shaqada adiga oo gujinaya badhanka Muuji Dhammaan Faallooyinka . ^{(Show All Comments)}Tani waxay ku imanaysaa anfaca haddii xaashida ay leedahay farabadan faallooyin ah. Waxa kale oo aad riixi kartaa kii hore^(Previous) iyo kan ku xiga^(Next) si aad ugu wareegtid dhammaan faallooyinka mid mid.

Ku dar faallooyinka unugga Excel 2007

Habka loo maro Excel 2007 waa mid la mid ah kuwa kore. Waxa ugu horreeya ee aad rabto inaad sameyso waa dhagsii unugga meesha aad rabto inaad geliso faallooyinka. Guji^(Click) tabka dib u  eegista^(Review) ee ku yaala bar ribbon si aad u aragto agabka tafatirka faallooyinka.

Kooxda Faallooyinka^(Comments) , ku dhufo Faallo Cusub^{(New Comment)} . Xaashida faafinta ee Excel sanduuqa qoraalka faallooyinka ayaa ka soo bixi doona meesha aad ku qori karto faalladaada cusub.

Ku qor faalladaada oo guji meel ka baxsan sanduuqa qoraalka markaad dhammayso. Waxaad ogaan doontaa inay jirto falaar yar oo guduudan oo ku taal dhanka midig ee sare ee unugga, taasoo muujineysa in unuggani uu leeyahay faallo. Gujista unugga waxay si toos ah u keenaysaa faallooyinka.

Ku dar faallooyinka^{(Add Comments)} unugga  Excel XP/2003 Cell

Excel 2003^{(Excel 2003)} iyo XP, waxaad haysataa dhowr ikhtiyaar oo dheeraad ah oo aad faallooyinka geliso unugga maadaama aysan jirin ribbon bar. Waxaad isticmaali kartaa menu-yada sare, menu-ka macnaha guud ee mouse-ka ama aaladda dib u eegista.

Ku dar faallooyinka Isticmaalka Menu Bar

Marka hore, waxaad u baahan tahay inaad gujiso unugga aad rabto inaad geliso faallooyinka. Markaas dhagsii ikhtiyaarka Gelida^(Insert) oo dooro Faallo^(Comment) .

Si la mid ah 2007dii, sanduuqa qoraalka ayaa kasoo muuqan doona agtiisa qolka aad ka geli karto faallooyinkaaga. Sidoo kale, saddex xagal cas ayaa ka muuqda geeska midig ee sare ee unugga.

Ku dar faallooyin Isticmaalka Mouse Context Menu^{(Add Comments Using Mouse Context Menu)}

Hab kale oo fudud, haddana qurux badan oo faallooyinka loo geliyo unugga Excel waa in si fudud loo riixo unugga oo dooro Geli Faallo^{(Insert Comment)} . Tani waxay dhab ahaantii ka shaqeysaa labada Excel 2007 iyo Excel 2003 .

Ku dar faallooyin^{(Add Comments)} addoo isticmaalaya Toolbar dib u eegista^(Reviewing)

Ugu dambeyntii, waxaad isticmaali kartaa qalabka dib u eegista^(Reviewing) ee Excel si aad ugu darto faallooyinka unugyada. Si aad u furto qalabka dib u eegista^(Reviewing) , aad View , Toolbars , oo dooro Dib u eegis^(Reviewing) .

Summada ugu horreysa ee bidixda fog waa badhanka Faallooyinka Cusub . ^{(New Comment)}Guji^(Click) oo sanduuq faallooyin cusub ayaa ka soo bixi doona unugga hadda la doortay.

Wax ka beddel faallada

Hadda aan ka hadalno laba shay oo aad ku samayn karto faallooyinka marka lagu daro. Marka hore, aynu si fudud u cabbirno faallada. Si aad taas u samayso, guji oo jiid mid ka mid ah gacan-qabsiga geesaha ama dhinacyada sanduuqa faallooyinka.

U qaabeeya Faallo

Sida caadiga ah, ma jiro qaabaynta faallooyinka, laakiin ka waran haddii aad rabto inaad bedesho fontka ama aad kordhiso cabbirka qoraalka? Si aad u qaabayso faallo, marka hore waxaad gujisaa unugga ka dibna dhagsii wax ka beddel faallooyinka^{(Edit Comment)} . Kadibna midig-guji meel kasta oo ku dhex jirta faallooyinka oo dooro Qaabka Faallaynta^{(Format Comment)} .

Waxaad hadda awoodi doontaa inaad bedesho qoyska farta, qaabka farta, cabbirka qoraalka, midabka qoraalka iyo saamaynta farta. Hadda waxaad xor u tahay inaad faallooyinkaaga ka dhigto mid fool xun ama qurux badan sidaad jeceshahay.

Beddel Qaabka Faallooyinka

Sida caadiga ah, sanduuqa faallooyinka waa leydi, laakiin dhab ahaantii waxaad bedeli kartaa qaabka faallooyinka. Way fiicnaan lahayd haddii ay ku dari lahaayeen doorashadaas qaybta faallooyinka^(Comments) ee tabka dib u eegista^(Review) , laakiin sababo jira awgeed halkaas maaha. Taa beddelkeeda waa inaad kudartaa badhanka qaabka aaladda gelida degdega ah.

Si tan loo sameeyo, dhagsii tabka Faylka^(File) ka dibna dhagsii Options .

Hadda waxaad u baahan tahay inaad marka hore gujiso Toolbar Helitaanka Degdegga^{(Quick Access Toolbar)} ah ee dhinaca bidixda ah marka hore. Xagga sare, waxaad arki doontaa amarrada ka dooro^{(Choose commands from)} hoos; Horey u soco oo ka dooro Dhammaan Amarada^{(All Commands from)} liiska. Hoos^(Scroll) u dhaadhac ilaa aad ka aragto Edit Shape , ku dhufo ka dibna dhagsii badhanka Add>> .

Si aad u bedesho qaabka faallooyinka,guji unugga oo dhagsii wax ka beddel faallooyinka marka^{(Edit Comment)} hore. Dabadeed dhagsii badhanka cusub ee wax ka beddelka^{(Edit Shape)} ee ku yaal aaladda gelida degdega ah waxaana lagu soo bandhigi doonaa qaabab kala duwan oo aad ka dooran karto.

Ku koobbi faallooyinka unugyo kala duwan

Haddii aad rabto in aad faallo ka koobiyayso hal unug oo aad u guurto mid kale, sidoo kale waa mid toosan-horumar leh. Kaliya^(Just) dooro unugga ka dibna taabo CTRL + C si aad u nuqul ka sameysid waxa ku jira. Marka xigta^(Next) , u gudub unugga kale, midig-guji oo dooro paste Special .

Ka dooro faallooyinka liiska oo kaliya faallooyinka ayaa la gelin doonaa unugga cusub. Wax kasta oo kale oo hadda ku jira qolka ayaa ahaan doona sidiisii.

Isticmaalaha Windows^{(Windows User)} u beddel magacaaga^(Own)

Waxaa laga yaabaa inaad ku aragtay sawirada kore in faallooyinka qaarkood ay ka bilowdaan "Isticmalaha Windows" taasina waa sababta oo ah nuqulka Xafiiska^(Office) ayaa ka diiwaan gashan magacaas si caadi ah. Waxaad tan ku bedeli kartaa adiga oo aadaya File , gujinaya Options ka dibna guji General .

Waad ku dhaafi kartaa faaruq haddii aanad doonayn in wax faallo ah ka soo bixin ama u beddelo qoraal kasta oo aad jeceshahay. Tani waxay ka soo muuqan doontaa xagga sare ee dhammaan faallooyinka sida caadiga ah.

Ka saar Tusiyaha Faallada Unugyada

Ugu dambeyntii, ka warran haddii aad rabto in aad qariso kuwa yar yar ee saddexagalka cas ee sare ee unugyada blocks xitaa haddii ay faallo ka jirto? Hagaag^(Well) , taasi sidoo kale waa sahlan tahay. Tag File , Options ka dibna Advanced .

Hoos ugu dhaadhac Bandhigga^(Display) ka dibna waxaad arki doontaa qayb la yiraahdo For cells with comments, show: oo halkan waxaad ka dooran kartaa saddex doorasho: No comment ama tilmaamayaasha^{(No comment or indicators)} , Indicators kaliya , iyo comments on hover^{(Indicators only, and comments on hover)} ama Comments iyo tilmaamayaasha^{(Comments and indicators)} .

Taasi waxay ku saabsan tahay waxa aad ku samayn karto faallooyinka Excel sidaa darteed waxaan rajaynaynaa inay tani kaa dhigi doonto inaad u ekaato pro Excel ee xafiiskaaga. Haddii aad qabto wax su'aalo ah, ku dheji faallo. Ku raaxayso

How to Add Comments to an Excel Worksheet Cell

I’m a big user of Excеl and it always amazes mе how fеw рeople add comments to their Excel spreadsheets! Adding and using comments in Excel is a great way to explain formulas, cells, and other data in the spreadsheet itself, thus saving you the time spent on the phone with colleagues! It’s really easy to add comments to cells in Excel and I’ll explain how you can do so in Excel XP/2003, Excel 2007, Excel 2010 and Excel 2013.

Comments are basically notes that can be inserted into any cell in Excel. It’s useful for reminders, notes for others, and for cross-referencing other workbooks. Note that newer versions of office have a option called Show Ink in the Comments toolbar and this is only useful for tablet PCs. The feature basically lets you handwrite a comment instead of typing one. On desktops and laptops, though, it’s only useful for viewing hand-written comments created on a tablet PC.

Also, there are a lot of other things you can do with comments once you add them to a worksheet like formatting, changing the shape, resizing and so on. Scroll to the bottom of the post for those tips.

Add Comments to an Excel 2013 Cell

Excel 2013 looks a bit different than 2010, but overall it’s pretty much the same. To add a comment, click on the Review tab and click on New Comment once you have selected the desired cell.

Now just type in your comment and when you navigate away from that cell, you’ll see a small red triangle in the upper right corner of the cell indicating that the cell has a comment.

Add Comments to an Excel 2010 Cell

In Excel 2010, adding a comment is super easy and the same as 2013. Just click on the Review tab and you’ll see all the commenting tools. Click on the cell you want to add the comment to and then click on New Comment.

A small dialog window will appear where you can begin typing in text. You’ll also notice the small little red triangle at the top right of the cell, which is there to indicate that cell has a comment.

You can quickly see all comments on a worksheet by clicking on the Show All Comments button. This comes in handy if the sheet has a bunch of comments. You can also click Previous and Next to cycle through all the comments one by one.

Add Comments to an Excel 2007 Cell

The procedure for Excel 2007 is the same as above. The first thing you’ll want to do is click on the cell where you want to insert the comment. Click on the Review tab in the ribbon bar to view the comment editing tools.

In the Comments group, click on New Comment. In the Excel spreadsheet a comment text box will appear where you can type in your new comment.

Type in your comment and click outside of the text box when you are done. You’ll notice that there is a small red arrow at the top right of the cell, indicating that this cell has a comment. Clicking on the cell automatically brings up the comment.

Add Comments to an Excel XP/2003 Cell

In Excel 2003 and XP, you have a couple of more options for inserting comments into a cell since there is no ribbon bar. You can use the menus at the top, the mouse context-menu or the reviewing toolbar.

Add Comments Using Menu Bar

First, you need to click on the cell that you want to insert the comment into. Then click on the Insert menu option and choose Comment.

Just like in 2007, a text box will appear next to the cell where you can enter your comment. Also, a red triangle appears at the upper right hand corner of the cell.

Add Comments Using Mouse Context Menu

Another simple, yet nifty way to insert a comment into an Excel cell is to simply right-click on the cell and choose Insert Comment. This actually works in both Excel 2007 and Excel 2003.

Add Comments Using Reviewing Toolbar

Finally, you can use the Reviewing toolbar in Excel to add comments to cells. To open the Reviewing toolbar, go to View, Toolbars, and choose Reviewing.

The first icon on the far left is the New Comment button. Click on it and a new comment box will appear in the currently selected cell.

Resize a Comment

Now let’s talk about a couple of things you can do with the comments once they have been added. Firstly, let’s just simply resize the comment. To do that, click and drag one of the handles on the corners or sides of the comment box.

Format a Comment

By default, there is no formatting on a comment, but what if you want to change the font or increase the size of the text? To format a comment, you first click on the cell and then click Edit Comment. Then you right-click anywhere inside the comment and choose Format Comment.

You’ll now be able to change the font family, font style, font size, font color and font effects. You are now free to make your comments look as ugly or beautiful as you like.

Change Shape of Comment

By default, the comment box is a rectangle, but you can actually change the shape of the comment. It would have been nice if they had added that option to the Comments section on the Review tab, but for some reason it’s not there. Instead you have to add the shape button to the quick access toolbar.

To do this, click on the File tab and then click on Options.

Now you need to click on Quick Access Toolbar on the left hand side first. At the top, you’ll see a Choose commands from drop down; go ahead and select All Commands from the list. Scroll down until you see Edit Shape, click on it and then click on the Add>> button.

To change the shape of the comment, click on the cell and click Edit Comment first. Then click on the new Edit Shape button in the quick access toolbar and you’ll be presented with a whole slew of shapes you can choose from.

Copy Comments to Different Cells

If you want to copy a comment from one cell to another, it’s also fairly-straight-forward. Just select the cell and then press CTRL + C to copy the contents. Next, go to the other cell, right-click and choose Paste Special.

Select Comments from the list and only the comments will be inserted into the new cell. Anything else currently residing in the cell will remain the same.

Change Windows User to Your Own Name

You may have noticed in the screenshots above that some of the comments start out with “Windows User” and that’s because the copy of Office is registered to that name by default. You can change this by going to File, clicking on Options and then clicking on General.

You can leave it blank if you want nothing to appear in the comment or change it to whatever text you like. This will appear at the top of all comments by default.

Remove Comment Indicator From Cells

Lastly, what if you want to hide those little red triangles from the top of the cells blocks even if a comment does exist? Well, that’s easy also. Go to File, Options and then Advanced.

Scroll down to Display and then you’ll see a section called For cells with comments, show: and here you can choose from three options: No comment or indicators, Indicators only, and comments on hover or Comments and indicators.

That’s about all there is you can do with comments in Excel so hopefully this will make you look like an Excel pro at your office. If you have any qestions, post a comment. Enjoy

Related posts

• Geli xaashida shaqada ee Excel Word Doc

• Sida loogu daro ama looga saaro faallooyinka Word

• Kudar Khadka Dib-u-Celinta Toosan ee Qorshaha Kala firdhisan ee Excel

• Sida loo sameeyo Histogram gudaha Excel

• Sida loo xafido erayga sirta ah ee Excel File

• 13 Tabaha OneNote & Tabaha loogu Abaabulayo Qoraaladaada si ka Wanagsan

• Isticmaal Hawlaha Kooban si aad u soo koobto Xogta ku jirta Excel

• Sida loo Helo Qiimaha Iswaafajinta gudaha Excel

• Adeegso Excel si aad u ogaato dulsaarka waxtarka leh ee ka imanaya heerka dulsaarka magaca ah

• Sida Loo Fahmo Maxaa-Haddii Falanqaynta Microsoft Excel

• Hagaha Dhammaan Kordhinta Faylka Excel & Waxa ay ula jeedaan

• 40 ka ugu wanaagsan ee Keyboard-ka Microsoft Excel

• Sida Taariikhaha Looga Jaro Excel

• Sida Loo Abuuro Liiska Qaybinta Muuqaalka

• Sida loo isticmaalo VLOOKUP gudaha Excel

• Sida loo Furo Tusaalooyin Badan oo Excel ah

• U qaabeeya Unugyada iyadoo la isticmaalayo Habaynta Shuruudaha ah ee Excel

• Isku xidh Unugyada u dhexeeya Xaashiyaha iyo Buugaagta Shaqada ee Excel

• Sida Loo Isticmaalo Shaqada YEARFRAC gudaha Excel

• Sida loo sameeyo garaafka fudud ama jaantuska gudaha Excel