

This is the second of my two favorite shortcuts… Excel Shortcut to Format the Selected Object Together, these two shortcuts give you a very quick way to remove old borders and add new ones with a quick command from your keyboard. Second, to apply an outside border to the selected area(s) of your worksheet, press: Excel Shortcuts to Change Cell BordersĮxcel offers two related keyboard shortcuts that are extremely useful for working with cell borders.įirst, to remove all borders from the selected area(s), of your worksheet, press: And also, if we click on the Help on this function link in the bottom-left corner, Excel will launch the full help topic about the function. In addition to telling us about the argument for the active edit box in the dialog, it tells us in this case that OFFSET is a volatile function. When I did so, Excel displayed the Function Arguments dialog: …I clicked on the OFFSET function, and then I clicked the Insert Function button. In your formula bar, click on the function you want to check. This shortcut offers an easy way to check any functions in the formula in your active cell. So, perhaps, one of its functions isn’t doing what you think it does. Suppose your workbook has a formula that doesn’t seem to be working how you think it should. Excel Shortcut to Get Help in a Worksheet Formula If you want more extensive help about the function, click the hyperlinked “Help on this function” text, as shown in the following shortcut. The dialog also provides short help for the function and for each argument.

This dialog gives you a form that you can fill in for each argument. Press Ctrl+a or click the icon where the red arrow points to launch the Function Arguments dialog for the function. …in your formula bar, you’ll see something like this: Suppose you need to read the help topic for a worksheet function, say the MATCH function. Excel Shortcut to Get Help for a Worksheet Function I think you’ll find them worth remembering: 1. Here are five of them that aren’t as well-known, and that I use almost daily. However, Excel offers other shortcuts that are nearly as useful. Most Excel users use some of Excel’s shortcuts frequently, like F9, Ctrl + C and Ctrl + V.
