Discover the Best Google Sheets Invoice Template Free for Technical Support

Google sheets invoice template free for Technical Support

Bismillah Rahman Rahim will discuss in today's class how you can create invoice bill format in sheet. In today's class we will discuss the complete process . If you are first on the channel then please subscribe the channel and like the video. So let's start. How can you create billon wise format in C sheet? So first of all we will type the name of the company on the top, here I type AR Computer Guide and below we will type the address of the company. I copied the address here, I paste the same and after that below we will type the mobile number of the company and after that below we will type billon vice and after that below we will create a table in which we will type serial number product name. First type red price, next type serial number, next type product name and after that next time type rate, next time type quantity and next time type price, then after this we will enter some areas as far as you want to create new format. And if we create a table on top of that, then set this area here and click on the three dot and here we will click on the table and click on all the borders, our table has been created here and Below we will type the total price, how much it has been made and after that below we will type what percentage of GST is to be applied. Here we will type GST 9 and after that below we will type the grand total and slide it also. And on top of this we will also fill the border, here we will click on the three dot and click on the border, here we will click on the border and after that below we will type note and after that below we will type something for the note. If we want to create a line, then on this line we will press D button along with shift. Here you can put a line and after that below we will type Signature of Manager. On top of this, if you want to create a border, then here we will select this cell. We will select and go to the Border section and select Top Border, then the line above it will be placed here, then we will come on top of the top. Here we make some setting of this format. Here first of all we give the name of the company. We will select this till here and merge it, here we will click on merge and click on merge and then slide the line below and merge this too and similarly the mobile number will also be merged and We will merge this also here and after that we will slide the billon below or type it here and merge it too. Now from here we will select the stacks and will make it in the center line and the heading which is coming on top. We will select it here which is its size and here we will increase it and here we will make it bold and here we will change the text size here and we will make it center line here and we will make it middle line here and after that the row below. We will select this also, we will make this also bold, we will also make the mobile number bold and after that, the invoice bill coming below, we will make this also bold and its text size will be changed here and after that the serial number below. Number will come and will be sorted and the table given below will also be sorted till here and here we will center its alignment here and will do middle alignment and the heading which is coming will be slid and it will be bold. Now we have to fill the color here, so we will select the ding given at the top, here we will fill a good color, click on the fill color here and whatever color you like and you will select it from here. You can select and after this we will make the text color white here, the address given here below, we will select it and fill the color here , here we are taking light color and we will also give it dark color. Let's make it wide and below we will fill it with mobile number, we will fill it with color and after that below we will type the billon wise here, we will select it too and fill it with any color inside it too like this and its text color. And make it white here and select the ding given below and fill some color inside it too and after that come down, here the total GST and Grund will slide it also and here also we will fill some color. Let's fill it and make it bold, then after that this area that is left here, we will salad it and We will merge here and here we will type thank you and to create a new line in this cell we will press the enter button and here we will type happy shopping and select this cell and its alignment is here. We will center it and center it and fill some color inside it and make it bold. We will select this cell and apply border on it too. Here we will click on the border and below it will click on the signature of the manager. Typed this , will select it here and will make it bold and will also make the note bold here. Now we create any aqua here. First of all, the column of serial number which is coming, we will reduce its size from here. Here we will increase the size of the column. From here you can adjust the size of the column as per your requirement. Here you can make the size of the column bigger or smaller and to type the serial number here, first type We will press one and enter button, we will type two here, now we will select both the cells to drag this serial number below and bring the mouse over the dot here and we will draw it below, now here the names of Pat First of all we type LED and its rate on Y we type 5500 and its quantity on Y we type 10. Now its price is how much it is and not the quantity. So here But we will apply the formula , press the equal button, here we will click on the quantity key and multiply, press the enter button in red, now we will drag this formula down, press the control D button, our formula has been dragged down now. Here next we type the name of the product, here we type monitor, its price, here we type 4500 and quantity, we type 12 pieces, see the price, it comes automatically. And after that we type the next product, here we type the USB price and here we type the quantity and similarly new and similarly we type the name of the next product, here we type the keyboard and its price. Here we will type and type the quantity. See, we have typed the name of the product, after that we have typed the rate, type of quantity, after that the price, we have applied the formula here, which is our price and it has been created here. We will slide the area here and make this bold then after that the total is coming below. Here we have the formula of total and if we have to apply it here then first of all we will type equal and type sum then press button. And here we will select the range and press enter button, then our total which has come here is below, it is asking us for auto fill suggestion, so here we do not want auto fill, we have said here. If you want to calculate the General Tax, after that you want to calculate the Grund Deer, then here we will cross click it and after this, how will you calculate the GST on 9 below, press the Equal button and here select Total Price Divided by 100 and enter Multiply by 9. If you press the button, then how can you find out the total which is there after this? So for this we will type equal button, here it has automatically applied the formula of even, we press the enter button here, now our grand total is It has come here but it has its range or it has picked up automatically so how can you change it, we will press the button, it has its range and we will change its range and this will be ours. And we will press the enter button, here you can see that our grand total has come here, then after that we will also salad this grand total, here we will make it in the center line and make it bold and its text size is Here we will increase it a little , our invoice format is ready here, if you want to take a print of it then you can take the print also and after that if you want to uncheck the grid line then here we will see the view format. We will go to and here we will click on the show and then click on the grid lines, our grid lines will be removed here and after that if you want to take a print of it, then here we will press the control button from the keyboard. Will press and your print is visible here in the print preview. So friends, this was the format. You can create invoice bill invoice format in google2. Friends, if you liked this video then please like the video and also subscribe the channel. See you inshallah with some network. Allah Hafiz m.