This removes all borders but it doesn’t affect any content or other formatting. In Windows, Clear Formats is Alt H, EF. On a Mac, there are a number of dedicated shortcuts for borders. I don’t think this is very useful myself, because you might’t control the line width or color. Again, you don’t have control over line thickness and color. And once you’ve used Alt, you don’t have to keep using it....
This setting controls the default for all new charts in all workbooks. Then Excel will only plot the data you’ve selected. When you select a chart, you could use arrow keys to select various elements in the chart. The up and down arrow keys will select groups of elements. Groups have names like Chart Area, Plot Area, Legend, and so on. you’re able to see the full list in a drop down on the ribbon....
When the cursor changes, you’re able to drag the selection to a new location. With this method, drag and drop is equivalent to cut and paste. The content of selected cells is moved, and the selection you drag will completely overwrite the destination cells. it’s possible for you to hold down the shift key to drag and insert. You’ll see the cursor change into a plus (+) symbol. When you release the mouse, a copy of the cells will be placed at the destination....
Abstract Transcript In this video, we’ll look at shortcuts for editing cells. With Excel’s default tweaks, this will put your cursor directly in the cell, ready to edit. you’ve got the option to also double-click a cell to edit. In Windows, use Alt F to get into the File menu, then T to access options. However, pressing F2 (or Control U on a Mac) takes me directly to the formula bar....
Excel has a large number dialog boxes that you will use frequently. First, to allow you to access all dialog controls, you should probably enable a preference. Go to System Preferences > then Keyboard > and to the shortcuts tab. Then confirm “All controls” is selected in the Full Keyboard Access area. This will let you tab and shift tab to select all dialog box controls. To reverse direction and go left, just add the shift key....
Excel has many dialog boxes that you will use frequently. All of these dialogs support common features that let you drive them from the keyboard. To switch tabs, you might use Control + tab to move right though the tabs. And, too reverse direction, just add the shift key. Controls in dialogs are highlighted subtly when active. Here you’re free to see a dotted line. To step through available controls, use the Tab key....
Excel Tables are one of Excel’s most powerful features for working with data. To toggle filters, use Ctrl-Shift-L in Windows, and use Command-Shift-F on a mac. A number of shortcuts for selecting cells take advantage of the table structure. you’re able to a select table row, using Shift + Space. And a table column, with Control Space. Both shortcuts work with multiple cells selected. Insert rows and columns with control-shift + in Windows, Control-I on a Mac....
The most basic way to extend a selection is to use the shift key + any arrow key. From a single cell, this lets you add additional cells in any direction. If you begin with a larger selection, shift will let you extend the edges of that selection. This works with entire rows and columns, too. If I select a row, I can use shift to select additional rows above or below....
To pull up the Excel help system, use F1 on Windows, Command + / on a Mac. Remember that when you do a Save As, you’re working on the new file. The original file is no longer open. To print, use Control + P on Windows; Command + P on a Mac. Confirm an option with Enter, or Tab. To close a file in Excel, use Control F4 or Control + W on Windows....
There’s very little formatting, so I’ll use a number of shortcuts to clean thing up. First, I’ll turn off gridlines to make borders easier to see. I want to change all text to a dark gray to match the chart. SO I’ll select all, then use Format Cells. Also, the Format Cells dialog lets you format almost anything in Excel, including charts and other objects. Next, I’ll add borders. For the headings, Center Across Selection is a nice trick that avoids problems that come with merging cells....
Abstract Transcript In this video, we’ll look at shortcuts for working with formulas. This means we have to lock both the column and row references to double-check they don’t change. Use the same shortcut again to turn off formulas. Whenever you better enter the same formula in multiple cells, you have several options. you might double-grab the fill handle after you’ve entered the first formula. you’ve got the option to enter the first formula and the use Control D to fill down....
Excel contains over 400 built-in functions, and a number of related shortcuts. To start off, there’s a shortcut for the Autosum feature, which automatically enters the SUM function. it’s possible for you to use this for both rows and columns. you might even Autosum an entire table. When you’re entering a function, you’re free to use autocomplete. Start typing the function name, then use TAB to complete a match. On a Mac, you’ll need to use the down arrow key to grab the best match first....
Excel provides a dedicated dialog box to access special groups of cells, called “Go To Special”. There you’ll find a large list of options. So, let’s go through these options. In cases where there is a dedicated shortcut, I’ll use that. Otherwise, I’ll use the Go To Special dialog. you’ve got the option to form example select all formulas that return a text result. it’s possible for you to deselect with escape....
