If you look at the screen, red velvet, TWICE by girl group, Contains photos of Black Pink's members. In this lesson, we are not inserting multiple photos one by one, I'm going to find out all of them by inserting, aligning, and aligning them all at once. In this lesson, we will also learn how to easily enter the file name. If you are curious, please take a look. The example file used in this lesson You can download it for free from the Oppa Homepage. Click the link below to download the example file I think it would be nice if we could proceed together. If you download the example file, one Excel file and Each girl group has an image file that contains member photos. First, go to the Excel file, and check the file. You can see that the name of each member is not entered for each girl group. So, by referring to each name of this picture file We will see how to easily enter each cell. In the previous lesson, through Data-Import Data-From File-From Folder We looked at how to easily get the name of each file. In this lesson, I will use notepad Let's see how to get the name of each file. If you are curious how to use the data import function Please refer to the previous lecture on the upper right. I'll run Notepad. I'll enter dir. dir is a directory, a window statement This statement prints a list of files in a folder. Enter a space. Please enter /b /a-d. Where /b is the additional information of the file in the folder, For example, the size of a file or the last modification date of a file. This property removes unnecessary information and outputs only the file name. /a-d does not print the subfolders of the current folder, It will be outputting only the file list. Separate spaces and type >. Separate spaces and enter the file name to save with Notepad. Please enter the file name extraction.txt. Choose File-Save. Enter the file name as'File Extraction.bat'. Please be careful to change the encoding format from UTF-8 to ANSI. After saving, exit Notepad. When you move to the folder, a Windows batch file called File Extraction has been created. When you run the file, a notepad called File Name Extraction is created. Each picture file has been printed. After selecting only the values we need, Copy to CTRL + C and go to Excel. Move down and paste with CTRL + V. There is an unnecessary value of .JPG after the member name. Delete unnecessary value called JPG. In this lesson, we will use the text break function. After selecting a range, click Data-Text Break. The standard we will share is'.(dot)'. Check that it is separated by a separator. The separator is a dot (.), not a tab. After checking the guitar, go to the guitar. Enter You can see the name of each member and JPG are separated. Next, select Finish. Text is separated. Since JPG is an unnecessary value, I will delete it. I will choose the name of Red Velvet. Copy to CTLR + C. I'll go up and select the first cell for each member's name. Right-click and click Paste Special. Or go to CTRL + ALT + V. Paste the matrix in the form of a value. If you click OK, the name of each member has been entered. After selecting and pasting as before, Paste the matrix in the form of a value. After copying TWICE, let's do it with a shortcut this time. Select the first cell, then enter CTRL + ALT+ V. Next to each format is the alphabet. If you press V, E, it becomes a row change in the form of a value and is pasted. Each member's name has been entered. Now I'm going to put a picture for each member. Select the first cell, then go to Insert-Picture-this device. Select the red velvet member photo and insert it. The first picture is inserted at the bottom, and the last picture is inserted at the top. After selecting the last photo, cut it with CTLR + X. Paste CTRL + V into the last cell. Hold down the ALT key on the keyboard and resize the picture The picture is resized to fit each cell. Right-click on the picture and go to Picture Format. You can check the height and width of the current picture in Size and Properties. Please remember the two values. Choose Home-Find & Select-Select Objects. After selecting all the pictures you just put in, Uncheck'Fix aspect ratio' in size and properties. Change the height and width to the values you saw previously. All pictures have been resized at once. Now select Format Picture-Fit-Space equally. Align-If you select Align Top, all pictures are aligned at once. Simple. Shall we try it again? This time, I'm going to put a picture photo of TWICE member. Select the first cell. Insert-Picture-Select this device. This time, we will select TWICE member picture. After selecting the first picture, hold down the SHFIT key on your keyboard If you select the last picture, you can select all pictures at once. If you select Insert, the picture is inserted. Cut the last picture and paste it into the last cell. Hold down the ALT key on the keyboard to change the picture size. I will select all the pictures one by one while holding down the SHIFT key on the keyboard. As before, uncheck the fixed aspect ratio and adjust the height and width. Picture Format-'Same horizontal spacing' in alignment, If you select'Fit Top', the pictures of all members are easily aligned. Please leave any questions you may have during this lecture in the comments below. If you liked this lesson, please subscribe and like it. I'll see you in the next lecture. Good-bye!
