projectbas.blogg.se - Mac excel hotkey for paste values

#MAC EXCEL HOTKEY FOR PASTE VALUES HOW TO#
#MAC EXCEL HOTKEY FOR PASTE VALUES FOR MAC#
#MAC EXCEL HOTKEY FOR PASTE VALUES PLUS#

You might under-shoot or over-shoot the last row of your data set because the scroll depends on how far down you are holding down your mouse.

You’re still using your mouse or trackpad.

Then you double-click and the formula for Revenue per passenger fills down to the last row in the data set (in this case row 281): Method 2: Drag-and-drop the formula until it reaches the last row of data setĮven less ideal, you can drag the bottom right corner of the cell down and basically wait until the window scrolls to the last row of the data set.

#MAC EXCEL HOTKEY FOR PASTE VALUES PLUS#

You basically hover your cursor over the bottom-right corner of the cell that contains the formula (in this case E2) and wait until your cursor turn into a black plus sign. This is how most people approach this problem, but the downside is that it requires you to use your mouse or trackpad. Method 1: Double-click the bottom-right of the cell If you want to try this exercise for yourself, see this Google Sheet and make a copy for yourself. This screenshot show the problem:Īs the text on the screenshot shows, the Revenue per passenger formula needs to be applied to all rows in the data set, but we don’t know where the data set ends. This spreadsheet tip is based on a question I get asked all the time when I teach (well taught) Excel at in-person classes: How do I fill a formula down to the last row of my data set without over-shooting the last row with keyboard shortcuts? This problem occurs with larger data sets where you have several hundred or thousands of rows and need to quickly apply a formula in a column for all these rows. resident? Don’t worry.Subscribe: Google Podcasts | Spotify | Stitcher | TuneIn | RSS or iPhone support, repair, training… or just want some questions answered? Call me at 31. Live in Los Angeles County and need Mac, iPad. Have a good week… This tip should shave hours off your day 🙂

#MAC EXCEL HOTKEY FOR PASTE VALUES HOW TO#

Your new shortcut will appear in the Current Keys box.Ĭongratulations, you now know how to create keystroke shortcuts in Excel.

It’s best if you create a keystroke shortcut, and the message says – Currently assigned to: Unassigned.

If you choose to ignore that message click Add.

If you choose a keystroke shortcut that is already in use, a message will appear below the input box – Currently assigned to: ABC.

Now, press the keys that you want to use as a shortcut for this command.

After selecting the command, move the cursor to the box labelled Press New Shortcut Key.I locate Paste Special… Values, by selecting Edit from the Categories list and Paste Special from the Commands list.The Current Key box may show that a shortcut already exists.Locate the Command you want to customize using the Categories and Command lists.

A dialog box opens showing Menu Bar Categories, Commands in each Category, and the Current Keys or Current Keystroke Shortcut.

Three steps too many if you use this command every day. Choose Values from the dialog box and click OK.To use the Menu Bar to access this command you need to copy a cell, then: When you copy a cell in Excel, you can paste it in a number of different ways you can paste the formula, the value, the formatting, the comments, etc., In this example, I’m going to make a shortcut for the command Paste Special… Values. If you use a command regularly and it has no keystroke shortcut… you can make your own. In the Menu Bar, you’ll find most commands have a keystroke shortcut shown in symbols.

#MAC EXCEL HOTKEY FOR PASTE VALUES FOR MAC#

Microsoft Excel for Mac 2011 has hundreds of command options.