Köprü Eklemek ve Düzenlemek

WEBVTT 00:00:01.587 --> 00:00:06.151 Was bedeutet es, in Excel einen Link und eine Verknüpfung hinzuzufügen? 00:00:06.271 --> 00:00:09.835 Was bedeutet es, in Excel einen Link und eine Verknüpfung hinzuzufügen? 00:00:09.895 --> 00:00:16.300 Sie wissen bereits aus unseren anderen Microsoft Office-Arbeiten. 00:00:17.121 --> 00:00:19.283 Wenn wir von einem Link sprechen, meinen wir eine Verknüpfung. 00:00:19.544 --> 00:00:28.682 Das Hinzufügen eines Links zu Informationen, auf die wir aus dem Internet oder einer anderen Quelle zugreifen möchten. 00:00:28.922 --> 00:00:34.967 Dafür wählen wir erneut das Menü "Einfügen" und dann "Verknüpfung". 00:00:36.649 --> 00:00:43.635 Wenn wir "Verknüpfung" auswählen, arbeiten wir genau wie in Microsoft, PowerPoint und Word mit dem gleichen Fenster. 00:00:43.775 --> 00:00:58.441 Wenn wir eine Adresse auswählen möchten, z.B. wenn wir einen Internetlink einfügen, sagen wir, wir fügen Wikipedia ein, um Statistiken aus dem Internet zu erhalten. 00:01:00.041 --> 00:01:08.285 Wir möchten hier eine Quelle verwenden, die für Excel geeignet ist. 00:01:09.646 --> 00:01:10.026 Was habe ich gemacht? 00:01:10.126 --> 00:01:12.847 Ich habe die Adresse mit der Tastenkombination Strg+C kopiert. 00:01:14.248 --> 00:01:15.869 Ich bin zum Adressfeld gegangen. 00:01:15.929 --> 00:01:17.569 Sie sehen, hier steht die Adresse. 00:01:17.970 --> 00:01:22.796 Ich füge sie mit Strg+V ein. 00:01:23.417 --> 00:01:34.947 Wenn ich mit der linken Maustaste auf "OK" klicke, wird der Link hier platziert, und wenn Sie einmal auf den blau unterstrichenen Link klicken, sehen Sie, 00:01:34.988 --> 00:01:39.753 dass die Wikipedia-Statistikseite geöffnet wird. 00:01:50.066 --> 00:01:54.827 Im Bereich Hinzufügen, Bearbeiten und Entfernen von Brückenverbindungen. 00:01:54.907 --> 00:01:58.988 Wir hatten auch verschiedene Beispiele dafür durchgeführt, wenn Sie sich erinnern. 00:01:59.088 --> 00:02:02.429 Lassen Sie uns die Brücke, die wir gerade platziert haben, wieder aufrufen. 00:02:02.469 --> 00:02:08.330 Angenommen, unsere URL, also die Internetadresse hier, ist sehr lang. 00:02:08.410 --> 00:02:09.371 Was möchten wir tun? 00:02:11.851 --> 00:02:14.552 Wir haben mit der rechten Maustaste darauf geklickt. 00:02:16.411 --> 00:02:20.232 Klicken Sie einmal auf die Schaltfläche "Brücke bearbeiten". 00:02:21.672 --> 00:02:23.793 Wir sind zum Abschnitt "Angezeigter Text" gelangt. 00:02:25.713 --> 00:02:29.514 Ich bin mit der End-Taste ans Ende gekommen. 00:02:29.834 --> 00:02:38.517 Mit der Umschalt- und den Pfeiltasten nach oben oder "Pos1" oder "Home" auf meiner physischen Tastatur habe ich alles ausgewählt. 00:02:39.197 --> 00:02:40.997 Dann habe ich mit der Rücktaste gelöscht. 00:02:42.538 --> 00:02:43.798 Hierhin "Wiki". 00:02:47.250 --> 00:02:53.002 Ich habe "Internetseite" geschrieben. 00:02:53.844 --> 00:02:56.625 Mit der Eingabetaste habe ich bestätigt. 00:02:57.025 --> 00:02:59.846 Die Wikipedia-Internetseite wird hier angezeigt. 00:03:00.407 --> 00:03:02.587 Ich möchte, dass es in die Zelle passt. 00:03:02.708 --> 00:03:05.508 Eine Möglichkeit, dies zu tun, war das Verschieben des Textes. 00:03:05.609 --> 00:03:10.171 Die andere war die Befehle "Zusammenführen und zentrieren". 00:03:10.270 --> 00:03:12.252 Aber hier müssen wir das nicht tun. 00:03:12.572 --> 00:03:14.653 Ich werde Ihnen noch etwas anderes zeigen. 00:03:15.593 --> 00:03:33.970 Wenn Sie auf die Linie auf der rechten Seite der Spalte klicken, wie Sie auf dem Bildschirm sehen können, und in der Mitte der Linie das Mauszeigersymbol mit Pfeilen in beide Richtungen erscheint, wird die Spaltenbreite automatisch angepasst, wenn Sie doppelklicken. 00:03:33.990 --> 00:03:37.552 Die Spaltenbreite wird automatisch an die Breite des Textes angepasst. 00:03:37.732 --> 00:03:40.493 Das gilt auch für die Zeilen.

WEBVTT 00:00:01.587 --> 00:00:06.151 What does it mean to add a link and connection in Excel? 00:00:06.271 --> 00:00:09.835 What does it mean to add a link and connection in Excel? 00:00:09.895 --> 00:00:16.300 You already know this from our other Microsoft Office works. 00:00:17.121 --> 00:00:19.283 When we talk about a link, we mean a hyperlink. 00:00:19.544 --> 00:00:28.682 So, adding a link to the information we want to access from the internet or a different source. 00:00:28.922 --> 00:00:34.967 For this, as you can see when we go to the Insert menu, we have the option for a hyperlink. 00:00:36.649 --> 00:00:43.635 When we select the hyperlink, we work in the same window as in Microsoft, PowerPoint, and Word. 00:00:43.775 --> 00:00:58.441 When we want to select an address, for example, when we put an internet link, let's say we will put Wikipedia, let's write Wikipedia statistics on the internet. 00:01:00.041 --> 00:01:08.285 We want to use a source suitable for Excel's context here. 00:01:09.646 --> 00:01:10.026 What did I do? 00:01:10.126 --> 00:01:12.847 I copied it from the address bar with the Ctrl-C key. 00:01:14.248 --> 00:01:15.869 I came to the address field here. 00:01:15.929 --> 00:01:17.569 You see the address written here. 00:01:17.970 --> 00:01:22.796 I paste it with Ctrl-V. 00:01:23.417 --> 00:01:34.947 When I confirm it with the left mouse button, as you can see, the link is placed here, and when you click on the blue underlined 6 once, you see 00:01:34.988 --> 00:01:39.753 that the Wikipedia statistics internet page is opened. 00:01:50.066 --> 00:01:54.827 In the area of adding, editing, and removing bridge connections. 00:01:54.907 --> 00:01:58.988 We had performed various related examples if you remember. 00:01:59.088 --> 00:02:02.429 Let's bring back the bridge we just placed. 00:02:02.469 --> 00:02:08.330 So, let's say our URL, our internet address here, is very long. 00:02:08.410 --> 00:02:09.371 What do we want to do? 00:02:11.851 --> 00:02:14.552 We right-clicked on it with the right mouse button. 00:02:16.411 --> 00:02:20.232 We click once on the Edit Bridge command on the Toolbar. 00:02:21.672 --> 00:02:23.793 We have reached the Displayed Text section. 00:02:25.713 --> 00:02:29.514 I've reached the end with the End key. 00:02:29.834 --> 00:02:38.517 Using the Shift key, the Up arrow, and the Page Up or Home key shortcuts on my physical keyboard, I selected all of them. 00:02:39.197 --> 00:02:40.997 Then I deleted them with the backspace key. 00:02:42.538 --> 00:02:43.798 I wrote Wiki here. 00:02:47.250 --> 00:02:53.002 I wrote Internet Page of Wikipedia. 00:02:53.844 --> 00:02:56.625 I confirmed by pressing the Enter key. 00:02:57.025 --> 00:02:59.846 The Wikipedia internet page is displayed here. 00:03:00.407 --> 00:03:02.587 I want it to fit inside the cell. 00:03:02.708 --> 00:03:05.508 One way to do this is to scroll the text. 00:03:05.609 --> 00:03:10.171 The other is commands like merge and center align. 00:03:10.270 --> 00:03:12.252 But we don't need to do that here. 00:03:12.572 --> 00:03:14.653 I will show you something else. 00:03:15.593 --> 00:03:33.970 When the mouse pointer, which has a line in the middle with arrows in both directions as you see on the screen, reaches the line on the right side of the column, the width of the column is automatically adjusted to fit the width of the text when you double-click. 00:03:33.990 --> 00:03:37.552 Similarly, this applies to lines as well. 00:03:37.732 --> 00:03:40.493 The width of the column is automatically adjusted to fit the width of the text when you double-click on the mouse pointer, which has a line in the middle with arrows in both directions as you see on the screen.

WEBVTT 00:00:01.587 --> 00:00:06.151 Excel'de bir köprü ve bağlantı eklemek ne anlama gelir? 00:00:06.271 --> 00:00:09.835 Excel'de bir köprü eklemek ve bağlantı eklemek ne anlama gelir? 00:00:09.895 --> 00:00:16.300 Az önce bunu zaten diğer Microsoft Office çalışmalarımızdan biliyorsunuz. 00:00:17.121 --> 00:00:19.283 Köprüden bahsettiğimiz şey bir link. 00:00:19.544 --> 00:00:28.682 Yani internetten veya farklı bir kaynaktan Ulaşmak istediğimiz bilgiye bir köprü eklemek. 00:00:28.922 --> 00:00:34.967 Bunun için yine ekli menüsü üzerine gittiğimizde gördüğünüz gibi bağlantı. 00:00:36.649 --> 00:00:43.635 Bağlantıyı seçtiğimizde ise Microsoft, PowerPoint ve Worddeki ile birebir olarak aynı pencere ile çalışıyoruz. 00:00:43.775 --> 00:00:58.441 Adres seçmek istediğimizde ise mesela bir internet bağlantısı koyduğumuzda Diyelim ki wikipedi koyacağız, wikipedi istatistik yazalım internete. 00:01:00.041 --> 00:01:08.285 Excel konjunktürüne uygun bir kaynak kullanmak istiyoruz burada. 00:01:09.646 --> 00:01:10.026 Ne yaptım? 00:01:10.126 --> 00:01:12.847 Adres çubuğundan Ctrl-C tuşuyla kopyaladım. 00:01:14.248 --> 00:01:15.869 Buradaki adres alanına geldim. 00:01:15.929 --> 00:01:17.569 Görüyorsunuz burada adres yazıyor. 00:01:17.970 --> 00:01:22.796 Ctrl-V ile yapıştırıyorum. 00:01:23.417 --> 00:01:34.947 Sol fare düğmesiyle tamam koduyla onayladığımda gördüğünüz gibi köprü buraya yerleştirilmiş oldu ve mavi 6 çizili üzerine bir kez tıkladığınızda ise gördüğünüz 00:01:34.988 --> 00:01:39.753 gibi Wikipedia istatistik internet sayfası açılmış oldu. 00:01:50.066 --> 00:01:54.827 Köprü bağlantı ekleme köprüyü düzenleme ve kaldırma alanında. 00:01:54.907 --> 00:01:58.988 Bunun da ilgili çeşitli örnekler gerçekleştirmiştik hatırlarsanız. 00:01:59.088 --> 00:02:02.429 Az önce koyduğumuz köprüyü tekrar geri çağıralım. 00:02:02.469 --> 00:02:08.330 Peki diyelim ki bu buradaki bizim URL yani hani internet adresi çok uzun. 00:02:08.410 --> 00:02:09.371 Ne yapmak istiyoruz? 00:02:11.851 --> 00:02:14.552 Sağ fare düğmesiyle üzerine tıkladık. 00:02:16.411 --> 00:02:20.232 Köprü düzenle komutuna Sofaya düğmesine bir kez tıklıyoruz. 00:02:21.672 --> 00:02:23.793 Görüntülenecek Metin kısmına geldik. 00:02:25.713 --> 00:02:29.514 End yani son tuşuyla en sonuna geldim. 00:02:29.834 --> 00:02:38.517 Shift yani yukarı ve Post 1 veya Home tuşuyla kısa yol kullanarak fiziksel klavyemde hepsini seçtim. 00:02:39.197 --> 00:02:40.997 Daha sonra geri tuşuyla sildim. 00:02:42.538 --> 00:02:43.798 Buraya Wiki. 00:02:47.250 --> 00:02:53.002 Pedi İnternet Sayfası yazdım. 00:02:53.844 --> 00:02:56.625 Giriş yani enter tuşuyla onayladım. 00:02:57.025 --> 00:02:59.846 Wikipedia internet sayfası burada görüntülendi. 00:03:00.407 --> 00:03:02.587 Hücrenin içerisine sığmasını iyi istiyorum. 00:03:02.708 --> 00:03:05.508 Bunu yapmanın yollarından bir tanesi metni kaydırdı. 00:03:05.609 --> 00:03:10.171 Diğeri ise birleştir ve ortala yana birleştir gibi komutlardı. 00:03:10.270 --> 00:03:12.252 Ama burada bunu yapmamıza gerek yok. 00:03:12.572 --> 00:03:14.653 Ben size başka bir şey daha göstereceğim. 00:03:15.593 --> 00:03:33.970 Kolonun sağ tarafındaki çizgiye gelip Ekranda gördüğünüz gibi, ortasında çizgi, iki yönümde ok olan fare işaretçisi gözüktüğünde çift tıkladığınızda otomatik 00:03:33.990 --> 00:03:37.552 olarak kolon genişliği, metnin genişliğine uygun bir şekilde ayarlanır. 00:03:37.732 --> 00:03:40.493 Bu aynı şekilde satırlar içinde geçer.