• In cell A1 type a zero ( 0) and press the Enter key on the keyboard. • In cell A2 type a 1 and press the Enter key. • In cell A3 type the formula =A1 + A2 and press the Enter key. • Click on cell A3 to make it the. • Place the mouse pointer over the fill handle — the black dot in the bottom right corner of cell A3 — the pointer changes to a black plus sign ( + ) when it is over the fill handle. • Click and hold on the fill handle and drag the mouse pointer down to cell A19. • A31 should contain the number 2584.

In Excel, borders are lines added to the edges of a cell or group of cells. The line styles that can be used for borders include single, double, and broken lines. The thickness of the lines can vary, as well as the color.

Updated: by Computer Hope To create a named cell in Microsoft Excel select the you want to name and click the Name Box next to the, as shown in the image to the right. This bar has the current cell location printed in it. For example, if you're in cell A1, it should currently say A1 in the Name Box. Once in the Name Box, type the name you want to name this cell and press. Once a cell has been named, you can refer to this cell in a formula, chart, or anything else that uses cell references. For example, let's assume you named a cell 'profits' when creating a new formula you could type =sum(B10+profits) to add cell B10 plus the value in the profits cell. Tip: When naming a cell or range it can only be one word, in other words, no.

Tip: In Excel use the Ctrl+F3 to open the Name Manager. In the Name Manager, you can create, edit, and delete any Excel names. Once a name has been created you can use the shortcut key F3 to insert any name. Why is it beneficial to name cells in a spreadsheet?

It is much easier the name of a cell instead of the cell reference. For example, it's much easier to remember 'profits' (as mentioned earlier) instead of what cell contains the profits value.

Also, it allows you to add arrow or rectangle after taking the screenshot, which is helpful in making tutorial. Lightshot also works same like snipping tool, all you need to run the Lightshot software. Because Lightshot shows width X height while selecting any area of windows / Mac. Video capture software for mac. Take Screenshot using Lightshot.