SHORTCUT FOR FORMAT COPYING MAC EXCEL PLUS
SHORTCUT FOR FORMAT COPYING MAC EXCEL WINDOWS

You can apply it with Paint Format tool only once (2nd click) but with the shortcut as often as required. I cover all shortcuts for number formatting in a separate video.

To apply currency format, I'll use control + shift +. The shortcut Repeat Action, which is F4 or Control Y on Windows, Command Y on a Mac is a handy way to apply the same fill in this case. If you copy a text format/style with cmd shift C ( or with the 1st click on Paint Format tool!) it will remain in the 'format/style pasteboard' until you copy another text format/style or quit Word. These shortcuts toggle formatting on and off.

Choosing some formatted text and double-clicking Paint Format tool and formatting several other text parts afterwards equals cmd shift C and several cmd shift V.

Choosing another part of the text ('2nd click') equals choosing some text and cmd shift V (paste format) - the Paint Format tool button is resetted afterwards!.

Choosing some formatted text and clicking Paint Format tool (1st click) equals cmd shift C (copy format).

The logic behind the Paint Format tool button compared to the default shortcuts works like this: It's not necessary to set up a custom shortcut for Word's Paint Format tool double click. If you set up a 'concurrent' shortcut it may also occur in Services, Screenshot etc.Īlso check the app's preferences whether you set up custom shortcuts which override the app's default shortcuts. as mentioned in the help text/manual) check whether you configured the same shortcut as global shortcut in System Preferences > Keyboard > Shortcuts. When they can be applied, they are typically the fastest solution.If a shortcut doesn't work as expected (i.e. I call it “double-click dynamite” because the results are “explosive.”Ĭtrl+D, Ctrl+R, Ctrl+Enter and Autofill are “niche” shortcuts worth adding to you arsenal. I have a post on double-click shortcuts here. It keeps going until it encounters an empty adjacent cell. If the adjacent cells are occupied, Excel copies or “shoots” down the cell contents. In the second, not shown, you just double-click on the fill handle. In the first, shown above, you simply grab the fill handle and drag down or across. Once they are all selected, type the cell contents.Įxcel completes the entry in the cell you are typing into and immediately copies it into all of the other cells you selected.Īnother way to look at Ctrl+Enter is that Excel enters the contents into all cells simultaneously. The key is this: you must select all cells at once. I have a separate Ctrl+Enter post here, but here’s a brief summary. You can also copy and paste multiple cells at the same time. The range you copy into must be in the same column/row as the cell you’re copying.Ĭtrl+D and Ctrl+R work on formulas, values and formatting.

The first cell in your selection must be either the cell you are copying or the one just below / to the right of it. Second, if you include the cell you’re copying in your selection, then you can copy it down to an entire column of cells that you select - and there can even be gaps in the column that you select.Ĭtrl+R does the same thing except it goes to the right instead of down. There are two possible scenarios, and they are illustrated in the magic show above:įirst, if you select only the cell below the one you want to copy, it will copy down that cell’s value or formula. But when they do fit, they’re lightning fast.īelow is a magic show - and after that the magic tricks are discussed.Ĭtrl+D copies and pastes downward in one quick shortcut. These magic tricks don’t fit every situation.

SHORTCUT FOR FORMAT COPYING MAC EXCEL PLUS

Note: If a shortcut requires pressing two or more keys at the same time, this topic separates the keys with a plus sign (+).

SHORTCUT FOR FORMAT COPYING MAC EXCEL WINDOWS

Just use Ctrl+D, Ctrl+R, Ctrl+Enter or Autofill. Many of the shortcuts that use the Ctrl key on a Windows keyboard also work with the Control key in Office 2016 for Mac. Did you know you can copy and paste simultaneously in Excel?

Shortcut for format copying mac excel