How to prepare cells for input parameters in engineering calculations? Let’s open one empty excel file as shown bellow.
For entering input parameters we need to prepare in Microsoft Excel certain cells for input parameters where we will type these input parameters which we will later use in mathematical calculation.
Let’s create first header for input parameters. We will type here text for the header, then we will put border for it. For this purpose we need first to select these cells with the mouse.
How we can do this?
We click in the first cell and drag the mouse to the other cells containing the text, holding down the left mouse button – when the cells are selected we can release the left mouse button. Now we keep the mouse cursor inside the cells and right click the mouse button.
The popup menu and format toolbar appears
Cells for Input Parameters are Important
Now we need to select the border for these cells, I personally like the border as shown above, but you have a plenty of borders to choose.
After we selected the border for the cells, we can select a background for this header. For this purpose we select the cells and right click the selection on the same way as we did before and choose from the toolbar appropriate fill color as shown bellow
After we created the header for input parameters, we need to create cells for the first input parameter. For this purpose we type the name of input parameter, its value and description as it is shown below…
We want also to format the number value – for this purpose we need to right click over the number cell and choose format cells from the menu.