Allow Signed Formula with airSlate SignNow

Allow signed formula

Today, we're going to talk about the hash reference in Excel. A common question I get is what is that hash sign I keep using in my videos when I'm referencing cells? Well, if you have Microsoft 365, you already have that hash sign and you should be using it because it's going to make your life a lot simpler. Let me show you how. Here I have some sample data which is not formatted as an Excel table. First of all, let me show you where you can't use the hash sign. So you can't just go typing in equals, reference A3, put in hash and expect your results to spill and pick up the range from A3 to D18, that's not going to happen. And the reason it doesn't happen is that this is not a spilled range. You can only use the hash sign when you reference a range that's spilling. Now, how do you recognize spilled range? Well, let me show you. First of all, let's create a spilled range. How do you do that? Well split ranges are generally created by using formulas that spill. So for example, if you use the sort function or the unique function, these are functions that spill. If you're curious to find out more about these functions, I have a separate video about this and I'm going to add the link to it to the description of this video. I also have a complete course that covers all the new functions in Excel 365. I'll add the link to that as well. The only thing we need for the unique function is our range. So let's say I want to get the unique combination for division and region, I'm going to reference this range, close bracket press Enter and this now is a spilled range. I wrote the formula once I press Enter and the result is spilled to the next cells. Now, here's how you can recognize spilled range. Number one, it has this automatic blue border so every time I click away, it's gone. Every time I click inside, it's there. And number two is that the formula is only living in the first cell. So that's the top left-hand corner. Take a look at the formula bar, the formula is dark here. When I go to the next cells, it's grayed out. This is how you can recognize the spilled range. Check this out. If I try to remove any part of this range so I'm just going to press Backspace here and press Enter, it doesn't let me do it. If I press Delete, it doesn't let me do it. The formula can only be removed here, here if I press Backspace and press Enter, my formula is gone. I'm going to press controls that to go back. Now instead of just removing it, if you type in something over this so let's say I type in subscribe which is a good time to let...