Here we have a set of sales data that spans 2 years, broken down by month. Generally, the fastest way to create a named range is to use the name box. Just make a selection and punch in a valid name. To see a list of existing names, use Control + F3. On a Mac, add the function key. Names also appear in the name box drop down. In this case, the names come from the Top Row....
you could find a list of available number formats on the home tab of the ribbon. Seven of these number formats have dedicated shortcuts, and they all begin with Control + Shift.
Abstract Transcript In this video, we’ll review shortcuts and commands for Paste Special. As you might already know, Paste special is a gateway to many powerful operations in Excel. In Windows, you might pop in a letter to select options. On the Mac, you’ll need to punch in the Command key plus a letter. I’ll run through a few examples. This table is a mix of regular data and formulas, along with various formatting....
These selections do not need to be next to one another. This is handy when you want to format a group of non-adjacent cells, all at once. To get out of this mode, just press the Escape key or perform an action. Using this shortcut again will go for the entire worksheet. These shortcuts work also when multiple cells are selected as. On Macs without an End key, use Fn + Control + right arrow....
Abstract Transcript Excel has many useful shortcuts for selecting cells. This includes shortcuts for selecting rows, columns, groups of cells, and even the entire worksheet. Let’s take a look. When you’re selecting individual cells, you could use the arrow keys to move the selection around. To select an entire column, press control + spacebar. To select an entire row, press shift + spacebar. When you are inside a group of cells, control + A will choose the entire group....
Control-semicolon will enter the current date; control-shift-semicolon will enter the current time. Let’s take a look. To enter the current date in Excel, use the shortcut control-semicolon. To enter the current time, use the shortcut control-shift-semicolon.
To paste, use Control + V on Windows and Command + V on the Mac. Note that when formulas are copied, relative cell references will update automatically. Use cut when you want to actually move data or formulas from one location to another. The shortcut is Control + X on Windows, and Command + X on the Mac. When you use cut, relative cell references will not change. The contents of the cells are moved from one location to another....
Abstract Transcript In this video, we’ll look at shortcuts for entering data. Before we start, I want to show you an option related to cursor movement in Excel. On Windows, press Alt + F, then T for Options, and A for Advanced. On a Mac, jot down command + comma to go to Preference, then click Edit. I’ll leave this alone for now, but I want to check that you know it’s there....
Control F also works on a Mac. After you run a find, and the Find dialog is closed. This is a handy way to step through matches without the find dialog blocking your view. To do a find and replace, use Control + H on both Windows and Mac. Excel will open up the Replace dialog with the replace field visible and in focus. Here’s a couple more quick tips on Find and Replace....
In this worksheet, we have some basic data subtotaled by region and quarter. There, you’ve got the option to tell Excel to group either Rows or Columns. you’re free to speed things up by selecting entire rows or columns before you group. With entire rows or columns selected, you might group in one step. To ungroup, use the shortcut Alt Shift left arrow in Windows and Command Shift J on a Mac....
To hide columns, use Control + 0. you might also work with multiple columns at the same time. To unhide columns again, make a selection that spans the hidden columns, and use Control Shift 0. To hide rows, use Control + 9. Again, you’ll see a visual indication in row numbers to indicate that rows are hidden. To unhide rows again, make a selection that spans hidden rows, and use Control Shift 9....
you could select an entire row with shift and the spacebar. This shortcut is the same for inserting columns. To select an entire column, Use control + spacebar. Then insert with Control shift + in Windows, Control + I on a Mac. you might insert multiple columns and rows as well, just begin with more than one cell selected. The logic for deleting rows and columns is the same. The shortcut is Control -....
If you extend this selection in any direction, you’ll see that the active cell doesn’t change. Only the selection changes. However, when you make a new selection, the active cell will update. To move the active cell right, use tab. And to move the active cell left, use shift + tab. you might rotate the active cell through the 4 corners of your selection using Control + period. This is a handy shortcut, as we’ll see in a minute....
