Jump to content

Excel Hakkında Yardıma Yardıma Ihtiyacım Var...


marbletumbled
 Share

Recommended Posts

Excel bilgisi olan arkadaşlardan Excelde sayfa1,de yukarıdan aşağıya hücrelere yazdığım isim listesini sayfa2,de
belirleyeceğim yazdırma alanında zarf üzerine teker teker yazdıracak bir formül veya hazır bir tablo bu konuda bana yardımcı
olabilecek arkadaşlarıma şimdiden teşekkürü üzerime bir borç bilirim...

Örnek isim listem
Ali .......
Veli .............
Hasan ...
Hüseyin .....

Çıkmasını istediğim hali
Sayın; Ali .......
Sayın; Veli .............
Sayın; Hasan ...
Sayın; Hüseyin .....

Edited by marbletumbled
Link to comment
Share on other sites

Excel olarak mümkün ama neden uzun uzun uğraşalım ki ? Sırası ile yapılacak işlemleri anlatayım.

Excel ile listeyi oluşturun.  Oluşturma kriteri olarak ; Sıra No, Ad, Soyad, Adres girebilirsin. Ben şu şekilde bir liste hazırladım.

Spoiler

excel1.png

Daha sonra boş bir Word belgesi açın.  Sayfa Düzeni'nden zarf boyutlarını ve yazdırma yönünü vs ayarlayın.

Spoiler

word1.png

Yukarıdaki bölümden Postalar -> Alıcıları seç -> Varolan listeyi kullan yolunu izleyin ve oluşturduğunuz Excel dosyasını seçin. 

Spoiler

Please register to see this content.

Bu kutucuk geldiğinde, liste hangi sayfada ise onu seçin ve  "ilk satırdaki veriler sütun üstbilgileri içeriyor" kutucuğunu duruma göre kaldırın. (Benim listemde sıra no, ad, soyad gibi üstbilgiler mevcut olduğu için işaretledim)

Spoiler

word3.png

Zarfın üzerine yazılacan "SAYIN : " bölümünün yerini ayarlayın. Yukarıdan Postalar -> Birleştirme alanı ekle ile eklemek istediğimiz bölümleri seçin. (Ad, Soyad, Adres vs). Ancak aralarında boşluk olacak ise bu boşluğu space ile girmeyi unutmayın :D

Spoiler

word4.png

Bundan sonrası listeyi yazdırmaya geldi. Yada işi doğrulamak için en sondaki "Sonuçların ön izlemesi" ile teyidini yapabilirsiniz.

 

Haydi kolay gele !

 

  • Like 1
  • Thanks 1
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

  • Similar Content

    • By qxqx
      Coolutils Total Excel Converter 7.1.0.46 Multilingual

      Coolutils Total Excel Converter 7.1.0.46 Multilingual
      Total Excel Converter, her türlü tabloyu dönüştürmek için mükemmel bir seçimdir.
      Desteklenen giriş biçimleri arasında Excel ve Excel 2007, XLSM, XLT, XLTM'nin yanı sıra OpenOffice biçimleri ODS, XML, SQL, WK2, WKS, WAB, DBF, TEX ve DIF bulunur.
      Hedef biçimlerin listesi daha da kapsamlıdır: tablolu dosyalarınızı DOC, DOCX, PDF, HTML, Access, TXT, ODT, ODS, XML, SQL, CSV, Lotus, DBF, TEX, DIFF, SYLL ve LaTeX'e dönüştürün.
      Her dosya türü için çeşitli dönüştürücüler toplamaya çalışmak için saatler harcamak yerine, hepsini halledebilecek tek araç!
      Özellik
      Total Excel Converter ile her sayfayı yeni bir dosyaya dönüştürebilirsiniz.
      Excel'i PDF'ye dönüştürün ve kullanıcı izinlerini ayarlayın. Bu, PDF dosyalarınızı değiştirilmeye veya kopyalanmaya karşı koruyacaktır.
      Total Excel Converter, OpenOffice ODS dosyalarını kolayca Microsoft XLS belgelerine dönüştürebilir; farklı programlar tarafından üretilen spread sayfalarının görüntüleyicinizle uyumlu olmasını sağlar.
      Daha benzersiz seçenekler..
      Kaynak biçimleri: XLS, XLSX, CSV, TSV, XLSM, XLSB, XLT, XLTM, XLTX, XLK, XLW, OTS, PXL, QPW, WB2, WB1, WQ2, WQ1, SDC, VOR, DBF, SLK, UOS, UOF, WK1, WK2, WK3, WK4, WKS, WAB, DIF, ET, Clarion, DBISAM,
      Avantaj.
      Çıktı biçimleri: DOC, PDF, HTML, MHT, XHTML, CSV, TXT, TIFF, JPEG, SVG, RTF, XML, XLS, XLSX, ODS, ODT, Lotus, DIFF, SYLK, LATEX, SQL, DBF, Access.
      XLS'yi grafiklerle dönüştürür
      PDF dosyalarını imzalayabilir
      Excel 2019 dosyalarını destekler
      Sayfaya sığdır seçeneği sunar
      Dahili yeniden adlandırıcısı vardır
      Kullanıcı dostu GUI
      Komut satırı desteği
      ActiveX ve Server sürümü
      Total Excel Converter is the perfect choice to convert any type of table.

      Supported input formats include Excel and Excel 2007, XLSM, XLT, XLTM as well as OpenOffice formats ODS, XML, SQL, WK2, WKS, WAB, DBF, TEX, and DIF. The list of target formats is even more extensive: convert your tabled files into DOC, DOCX, PDF, HTML, Access, TXT, ODT, ODS, XML, SQL, CSV, Lotus, DBF, TEX, DIFF, SYLK, and LaTeX. Instead of spending hours trying to gather various converters for each file type, the one tool that can handle them all!
      Features
      With Total Excel Converter, you can convert each sheet into a new file.
      Convert Excel to PDF and set user permissions. This will protect your PDF files from being modified or copied.
      Total Excel Converter can easily convert OpenOffice ODS files to Microsoft XLS documents; making it so that spread sheets produced by different programs are compatible with your viewer. More unique options..
      Source formats: XLS, XLSX, CSV, TSV, XLSM, XLSB, XLT, XLTM, XLTX, XLK, XLW, OTS, PXL, QPW, WB2, WB1, WQ2, WQ1, SDC, VOR, DBF, SLK, UOS, UOF, WK1, WK2, WK3, WK4, WKS, WAB, DIF, ET, Clarion, DBISAM, Advantage.
      Output formats: DOC, PDF, HTML, MHT, XHTML, CSV, TXT, TIFF, JPEG, SVG, RTF, XML, XLS, XLSX, ODS, ODT, Lotus, DIFF, SYLK, LATEX, SQL, DBF, Access.
      Converts XLS with charts
      Can sign PDF files
      Supports Excel 2019 files
      Offerss Fit-to-page option
      Has built-in renamer
      User-friendly GUI
      Command line support
      ActiveX and Server version
      HOMEPAGE
      https://www.coolutils.com/

      CoolUtils Total Excel Converter v7.1.0.46 TEAM-Full.exe (27.67 MB)
    • By artae
      File size: 3.6 MB
      Excel Merger is a handy Excel file and workbook merging utility for Windows. It enables users to merge Excel XLS/XLSX and ODS/CSV/XML files into one single workbook file without installing Office or MS Excel. Excel Merger supports a variety of common worksheet output formats like XLSX (Latest Excel Format), XLS (Excel 2003 Format), ODS (Open Document Sheets), CSV (Comma-Separated Values file) and XML (eXtensible Markup Language file).

      In addition to merging multiple Excel files into one file, this brilliant merging tool could merge all workbooks in a file to one worksheet, or merge all workbooks in multiple files into one workbook in one single file. That would be very useful when you need to combine all documents, files, worksheets, tables and forms together. If you want to merge some sheets in a file only, the sheets range option allows you to merge only selected workbooks instead of the entire worksheet document.

      Besides merging files and workbooks, Excel Merger also allows you to merge rows and columns in dozens of table files or spreadsheets in bulk.

      Features:
      Combine Several Excel Files into One Single Excel File
      Batch Merge Wordbooks & Spreadsheets into One Worksheet
      Combine Multiple Excel Files and Spreadsheets to One Spreadsheet in One Excel File
      Join Parts of all Worksheets by setting a Range
      Merge Table Rows and Columns in Bulk Files
      Support Mixed Merging XLS, XLSX, ODS, CSV and XML Files
      Export to XLS, XLSX, ODS, CSV and XML Formats
      Combine Files & Workbooks in Ultra-fast Mode
      Not Require Office or MS Excel Installed

      Software Languages: English, French, German, Dutch, Korean, Japanese, Russian, Simplified Chinese, Traditional Chinese, Spanish, Portuguese, Swedish, Greek, Polish, Italian.

      Whats New:
      Updates: official site does not provide any info about changes in this version
      DOWNLOAD
      (Buy premium account for maximum speed and resuming ability)


      http://nitroflare.com/view/9AD0DCB9E6FEEBF/iqqwf.Excel.Merger.Pro.1.4.1.Multilingual.rar



      https://rapidgator.net/file/7a14672b79790086d05b5a8dfeb05406/iqqwf.Excel.Merger.Pro.1.4.1.Multilingual.rar


    • By artae
      PassFab for Excel 8.5.11.2 Multilingual + Portable | 32.7/36.4 Mb
      Excel Password Recovery. Instantly recover or remove password in Excel Workbook with GPU Acceleration. Unprotect encrypted Excel workbooks, spreadsheets or cells with a single click regardless of the password complexity.

      Simplest Method to Decrypt Excel Workbook
      Unprotect encrypted Excel workbooks, spreadsheets or cells with a single click regardless of the password complexity.
      3 Powerful Attack Types Wrapped in Excel Password Recovery:
      Brute-force Attack
      It attempts all possible combinations of passwords until the correct Password (If need) found. The password recovery engine is highly optimized, thus short password can be recovered immediately.
      Brute-force with Mask Attack
      If you remember the password partially, you can set a mask with the mask symbols for those parts you can't remember, it will help you effectively shorten the recovery time compared with brute-force attack.
      Dictionary Attack
      Since many people use regular words or phrases for password, perform a dictionary attack by trying each word from the dictionary will save your precious time.
      Fast & Effective Multi-Core CPU and GPU Acceleration
      Support multi-core CPU and GPU acceleration technology to speed up the recovery process efficiently. The more CPU cores you have, the faster recovery speed you will enjoy.
      System Requirements:
      - Windows 11, 10, 8.1, 8, 7, Vista, XP(32-bit/64-bit) , Windows Server 2019/2016/2012/2011/2008, etc.
      - 1GHz (32 bit or 64 bit)
      - 256 MB or more of RAM (1024MB Recommended)
      - 200 MB free space and above
      - VIDIA G80+ (GT8600 to GTX1080 TI)
      - Excel 2021, 2019, 2016, 2013, 2010, 2007, 2003, XP, 2000 and 97
      Home Page -https://www.passfab.com/
      DOWNLOAD
      (Buy premium account for maximum speed and resuming ability)


      https://nitroflare.com/view/A43ED9AB4326071/hktfy.PassFabforExcel8.5.11.12.rar
      https://nitroflare.com/view/BB1E5281A94D8CB/hktfy.PassFabforExcelPortable.8.5.11.12.rar



      https://rapidgator.net/file/bc291b7e920e623547ab8c5408a42748/hktfy.PassFabforExcel8.5.11.12.rar
      https://rapidgator.net/file/96ed0f4cc5296e0971aaad902f9f7eb9/hktfy.PassFabforExcelPortable.8.5.11.12.rar


    • By artae
      PassFab for Excel 8.5.10.7 Multilingual
      File size: 32.6 MB

      Excel Password Recovery. Instantly recover or remove password in Excel Workbook with GPU Acceleration. Unprotect encrypted Excel workbooks, spreadsheets or cells with a single click regardless of the password complexity.

      Simplest Method to Decrypt Excel Workbook
      Unprotect encrypted Excel workbooks, spreadsheets or cells with a single click regardless of the password complexity.

      3 Powerful Attack Types Wrapped in Excel Password Recovery:

      Brute-force Attack
      It attempts all possible combinations of passwords until the correct password is found. The password recovery engine is highly optimized, thus short password can be recovered immediately.

      Brute-force with Mask Attack
      If you remember the password partially, you can set a mask with the mask symbols for those parts you can't remember, it will help you effectively shorten the recovery time compared with brute-force attack.

      Dictionary Attack
      Since many people use regular words or phrases for password, perform a dictionary attack by trying each word from the dictionary will save your precious time.

      Fast & Effective Multi-Core CPU and GPU Acceleration
      Support multi-core CPU and GPU acceleration technology to speed up the recovery process efficiently. The more CPU cores you have, the faster recovery speed you will enjoy.

      System Requirements:
      - Windows 10 / Windows 8.1 / Windows 8 / Windows 7 / Vista / Windows XP (32-bit/64-bit)
      - 1GHz (32 bit or 64 bit)
      - 256 MB or more of RAM (1024MB Recommended)
      - 200 MB free space and above
      - VIDIA G80+ (GT8600 to GTX1080 TI)
      - Excel 2016, 2013, 2010, 2007, 2003, XP, 2000 and 97

      RELEASE NOTES:
      - Release notes were unavailable when this listing was updated.
      DOWNLOAD
      (Buy premium account for maximum speed and resuming ability)


      https://nitroflare.com/view/2CF1CD2114363A0/w88gq.PassFab.for.Excel.8.5.10.7.Multilingual.rar



      https://rapidgator.net/file/c8be5d070fcb93ea56967894f47d9d43/w88gq.PassFab.for.Excel.8.5.10.7.Multilingual.rar


    • By artae
      File size: 90 MB

      Total Excel Converter is the perfect choice to convert any type of table.

      Supported input formats include Excel and Excel 2007, XLSM, XLT, XLTM as well as OpenOffice formats ODS, XML, SQL, WK2, WKS, WAB, DBF, TEX, and DIF. The list of target formats is even more extensive: convert your tabled files into DOC, DOCX, PDF, HTML, Access, TXT, ODT, ODS, XML, SQL, CSV, Lotus, DBF, TEX, DIFF, SYLK, and LaTeX. Instead of spending hours trying to gather various converters for each file type, the one tool that can handle them all!
      Features
      With Total Excel Converter, you can convert each sheet into a new file.
      Convert Excel to PDF and set user permissions. This will protect your PDF files from being modified or copied.
      Total Excel Converter can easily convert OpenOffice ODS files to Microsoft XLS documents; making it so that spread sheets produced by different programs are compatible with your viewer. More unique options..
      Source formats: XLS, XLSX, CSV, TSV, XLSM, XLSB, XLT, XLTM, XLTX, XLK, XLW, OTS, PXL, QPW, WB2, WB1, WQ2, WQ1, SDC, VOR, DBF, SLK, UOS, UOF, WK1, WK2, WK3, WK4, WKS, WAB, DIF, ET, Clarion, DBISAM, Advantage.
      Output formats: DOC, PDF, HTML, MHT, XHTML, CSV, TXT, TIFF, JPEG, SVG, RTF, XML, XLS, XLSX, ODS, ODT, Lotus, DIFF, SYLK, LATEX, SQL, DBF, Access.
      Converts XLS with charts
      Can sign PDF files
      Supports Excel 2019 files
      Offerss Fit-to-page option
      Has built-in renamer
      User-friendly GUI
      Command line support
      ActiveX and Server version
      Whats New
      Updates: official site does not provide any info about changes in this version.
      DOWNLOAD
      (Buy premium account for maximum speed and resuming ability)


      https://nitroflare.com/view/A5DA331F3E10F7E/h3ztk.Coolutils.Total.Excel.Converter.7.1.0.42.Multilingual.Portable.rar



      https://rapidgator.net/file/980bb1ea2e433e54b62298b05db7102f/h3ztk.Coolutils.Total.Excel.Converter.7.1.0.42.Multilingual.Portable.rar


  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...