Position your cursor over the fill handle, and then press and hold theShiftkey on your keyboard. As you do this, the cursor will change to two bars with arrows, indicating that you can insert a column. While still holding theShiftkey, left-click and drag the fill handle to the right to...
If you want to move the column left, you can select the column and drag it with Shift key to the left of the column you want to left to it.Move row up/down To move row up or down, you just need to do as follow. 1. Select the whole row you want to move, and put the ...
This chart is an arrow chart that has horizontal and vertical lines, positive arrows are green and negative arrows are red. How to build an arrow chart I am going to use a scatter chart to plot these lines, I will have two different series, one for the green arrows and one chart serie...
This is handy, and although you can do more things here to do with looking at the whole document, you can’t immediately refine your search to whole words only, match case, etc. But you can get to that familiar dialogue box. Click the down arrow next to the search box and you’ll ...
Using our change log template helps you identify and follow the change as it moves through your project. This makes sure nothing falls through the cracks, and gives you the tools you need to control and manage that change. The change log provides visibility into the process. You assign someon...
When VLOOKUP finds the "Lollipops" value in our table B2:D7, it moves over 2 columns and pulls our unit sales number: 25,000,000. We've just successfully created a simple lookup formula! How is this useful in practice? VLOOKUP can be used with cell references to create a dynamic data...
While I’ve covered self-formatting as one of the basic Excel skills, you can achieve a whole lot more by learning how to create custom cell formats in the format cells dialog box properly.Below are some examples of things you can achieve using custom cell formatting:...
Shfit+F10 activates the right-click menu [note] when you use the shortcut key to activate the menu, you can use the up and down arrow keys to move in the menu bar. For the submenu, you can move the arrow with the left and right arrow. When you move to the menu command you want...
Note that while Half Leaves are counted as .5 leaves in the total count, in the leave break-up, it is counted as whole numbers. For example, 2 half leaves would lead to 1 leave count, but you’ll see two half leaves in the leave breakup. I have created this leave/attendance ...
11. Use dollar signs to keep one cell's formula the same regardless of where it moves. Have you ever seen a dollar sign in an Excel formula? When used in a formula, it doesn't represent an American dollar; instead, it ensures that the exact column and row are held the same even if...