Here, for example, it would select the range A3:A4.īy the way, whenever you use the Go To dialog to select a new range, Excel sets up the range you’ve just left as the default range.
When you do so, Excel selects the range to which the reference points. Press Ctrl + V to paste your copied text into the Reference edit box of the Go To dialog. Press Ctrl + G or F5 to launch the Go To dialog.ĥ. In your formula bar, select the text that returns the reference you want to check, like this:Ģ. Press Ctrl + C to copy the selected text.ģ. …in a cell and you want to check that the OFFSET function really is returning the area you want to sum. To do so…ġ. And suppose you now want to check that the reference actually points to the area you think it does.įor example, suppose you enter this formula… Suppose you’ve written a formula that uses a range name that returns a cell reference, or a formula that uses a function that returns a cell reference (like the OFFSET or INDEX functions). Excel Shortcut to Check the Accuracy of a Range Name or Other Cell Reference Then type Ctrl + 1 to launch the Properties dialog for the selected object. So, if necessary, select any object in the chart, push the up or down arrow-or the left or right arrow for finer control-until you select the object you want to format.
This shortcut is particularly necessary in charts, when it’s sometimes difficult to right-click an object in order to launch its Properties dialog. To launch the Properties or the Format dialog for the selected object (a cell, a drawing object, a chart object, etc.), type: Ctrl + 1 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:
#Excel keyboard shortcuts protect sheet full#
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.
0 kommentar(er)
