Get the free quote template word form

Video instructions and help with filling out and completing quote template word

Instructions and Help about editable quotation form

Today we're going to take a look at a couple of things that you can do with an Excel hopefully you learn a couple tips things you didn't know before we're going to do is we're going to look at a quote form and price sheet a very, very simple example that I've created, and I'm going to show you kind of how I put this thing together one of the first things you're going to notice here is that I don't see like any grid lines I mean this looks very different from what you'll typically see in Excel and if I want to like to modify this if I go double click it's going to tell me that it's protected well how do you protect things a lot of people don't know that first thing I'm going to do is I'm unlock this you can kind of get a picture for how I've set up the sheet and I can choose to protect the sheet itself these are sheets or the entire book I'm just going to go ahead and unprotected password, and then I'm going to show you a couple of things I've done here first on the view you'll see that I have grid lines if I want to see the grid lines or if I don't do I want to see the headings right or the column and the row headings in do I want to see the formula bar which is where I will create formulas and the content of my form alright so for design you know I'm going to probably put those in here one of the things you're going to notice here is I've got these I've got a couple cells here that are colored now this one here happens to be just colored like if I right-click go into format cells you're going to see that the fill on this cell is red like I just made it red if I go in here and look at the fill on that cell you're going to see there's no fill so why is it red what I've done here is I've set up a conditional rule this is called conditional formatting I've done it on these fields as well so if I come in here, and I look at conditional formatting I can go to manage rules and what I've done is I've said is if this cell or any of the cells I've selected our blank then we'll go ahead and edit the rule if that cell happens to be blank it's going to make the fill read and highlight that okay, so that's just one way there are ways you can do all kinds of different conditional formatting these are things people really don't know how to do within here so what happens if as is it's not blank if I pick a value this one happens to be a drop-down value it's going to change it from red oil there we go now where are these values coming from you know I've got a drop-down list a lot of people don't know how to create a drop-down list so these if we go to data okay we're thinking about the data behind this field or the cell is I'm doing data validation okay if I click on data validation this one happens to be a list type, so I'm validating that it is a value as part of a list and then defining where does that list exist then you can see this is actually going to a different tab this is going to my price sheet okay and so these are the values that I'm using within...