{"id":2293,"date":"2024-03-05T10:30:00","date_gmt":"2024-03-05T10:30:00","guid":{"rendered":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/?p=2293"},"modified":"2025-01-07T11:27:52","modified_gmt":"2025-01-07T11:27:52","slug":"tipdigi-24-gwneud-defnyddio-excel-yn-haws-drwy-rewi-colofnau-a-rhesi-%f0%9f%93%8a","status":"publish","type":"post","link":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/cy\/2024\/03\/05\/tipdigi-24-gwneud-defnyddio-excel-yn-haws-drwy-rewi-colofnau-a-rhesi-%f0%9f%93%8a\/","title":{"rendered":"TipDigidol 24: Gwneud defnyddio Excel yn haws drwy rewi colofnau a rhesi \ud83d\udcca"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"241\" src=\"http:\/\/wordpress.aber.ac.uk\/digital-capabilities\/files\/2023\/08\/digitips-banner_61877145-2-1024x241.png\" alt=\"\" class=\"wp-image-1463\" srcset=\"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/files\/2023\/08\/digitips-banner_61877145-2-1024x241.png 1024w, https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/files\/2023\/08\/digitips-banner_61877145-2-300x71.png 300w, https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/files\/2023\/08\/digitips-banner_61877145-2-768x181.png 768w, https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/files\/2023\/08\/digitips-banner_61877145-2-1536x362.png 1536w, https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/files\/2023\/08\/digitips-banner_61877145-2-2048x482.png 2048w, https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/files\/2023\/08\/digitips-banner_61877145-2-712x168.png 712w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div style=\"height:8px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Ydych chi erioed wedi gweithio ar ddogfen Excel fawr ac wedi sgrolio i lawr i ddod o hyd i ffigur, ond wedyn wedi gorfod sgrolio\u2019n \u00f4l i fyny i\u2019r brig eto i\u2019ch atgoffa\u2019ch hun beth oedd pennawd y golofn honno?!<\/p>\n\n\n\n<p>Mae nodwedd hynod o ddefnyddiol yn Excel a all eich helpu gyda hyn, sy\u2019n galluogi i chi rewi un neu fwy o resi a cholofnau. Gallwch ddefnyddio\u2019r nodwedd yn Excel drwy glicio ar <strong>Gweld &gt; Rhewi\u2019r Cwareli<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"285\" src=\"http:\/\/wordpress.aber.ac.uk\/digital-capabilities\/files\/2023\/12\/Excel-Freeze-1024x285.png\" alt=\"\" class=\"wp-image-2268\" srcset=\"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/files\/2023\/12\/Excel-Freeze-1024x285.png 1024w, https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/files\/2023\/12\/Excel-Freeze-300x84.png 300w, https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/files\/2023\/12\/Excel-Freeze-768x214.png 768w, https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/files\/2023\/12\/Excel-Freeze-712x198.png 712w, https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/files\/2023\/12\/Excel-Freeze.png 1146w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\" \/>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Gwyliwch y fideo isod i ddysgu sut mae rhewi colofnau a rhesi:<\/strong><\/h4>\n\n\n\n<figure class=\"wp-block-video\"><video height=\"1080\" style=\"aspect-ratio: 1920 \/ 1080;\" width=\"1920\" controls loop muted poster=\"http:\/\/wordpress.aber.ac.uk\/digital-capabilities\/files\/2023\/12\/TipDigi-24.png\" src=\"http:\/\/wordpress.aber.ac.uk\/digital-capabilities\/files\/2023\/12\/Copy-of-TipDigi-24-_-DigiTip-24-Made-with-Clipchamp.mp4\"><\/video><\/figure>\n\n\n\n<div style=\"height:26px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-white-color has-text-color has-background\" style=\"background:linear-gradient(339deg,rgb(254,205,165) 0%,rgb(254,45,45) 17%,rgb(107,0,62) 37%,rgb(171,85,85) 91%);font-size:18px\">I ddilyn ein TipiauDigi, tanysgrifiwch i\u2019n <a rel=\"noreferrer noopener\" href=\"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/cy\/\" target=\"_blank\"><strong>Blog Sgiliau Digidol<\/strong><\/a>. Neu, gallwch hefyd <a rel=\"noreferrer noopener\" href=\"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/cy\/category\/tipiaudigi\/\" target=\"_blank\"><strong>ddilyn y dudalen hon<\/strong><\/a>, lle bydd TipDigi newydd yn cael ei ychwanegu bob wythnos!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ydych chi erioed wedi gweithio ar ddogfen Excel fawr ac wedi sgrolio i lawr i ddod o hyd i ffigur, ond wedyn wedi gorfod sgrolio\u2019n \u00f4l i fyny i\u2019r brig eto i\u2019ch atgoffa\u2019ch hun beth oedd pennawd y golofn honno?! Mae nodwedd hynod o ddefnyddiol yn Excel a all eich helpu gyda hyn, sy\u2019n galluogi [&hellip;]<\/p>\n","protected":false},"author":15501,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[404,58,138,396,207],"tags":[213],"class_list":["post-2293","post","type-post","status-publish","format-standard","hentry","category-cymorth-microsoft","category-hyfedredd-mewn-tgch","category-llythrennedd-gwybodaeth","category-microsoft-excel-cy","category-tipiaudigi","tag-tipiaudigipa-digitipsau"],"jetpack_featured_media_url":"","jetpack_likes_enabled":true,"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/posts\/2293","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/users\/15501"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/comments?post=2293"}],"version-history":[{"count":2,"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/posts\/2293\/revisions"}],"predecessor-version":[{"id":2442,"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/posts\/2293\/revisions\/2442"}],"wp:attachment":[{"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/media?parent=2293"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/categories?post=2293"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wordpress.aber.ac.uk\/digital-capabilities\/wp-json\/wp\/v2\/tags?post=2293"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}