Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-30-2016, 04:30 PM
aussiemight aussiemight is offline Which F-key in 2016 is now used for pasting? Windows 10 Which F-key in 2016 is now used for pasting? Office 2016
Novice
Which F-key in 2016 is now used for pasting?
 
Join Date: Dec 2016
Posts: 3
aussiemight is on a distinguished road
Default Which F-key in 2016 is now used for pasting?

The previous version of excel I was using had the the F3 key as a paste key. This key does not seem to work in excel 2016. I've tried it in combinations with shift, ctrl & alt to no avail. I've created a couple of lists that I have given a Named Range then when I go to Data/Data Validation & select Lists from the options I can't paste the list into the source section of the data validation selection.
Reply With Quote
  #2  
Old 12-31-2016, 01:09 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Which F-key in 2016 is now used for pasting? Windows 7 64bit Which F-key in 2016 is now used for pasting? Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,780
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Perhaps Ctrl+V or Shift+Ins ?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 12-31-2016, 06:09 AM
NoSparks NoSparks is offline Which F-key in 2016 is now used for pasting? Windows 7 64bit Which F-key in 2016 is now used for pasting? Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

@ Pecoflyer

That was my line of thought too, but from a search for Excel shortcuts, according to this ExcelJet page, under the FORMULAS part....

Quote:
Paste name into formula

When you're editing a complex formula, the last thing you need is to have to leave edit mode to go find the name of a named range or constant. With this shortcut F3 (no Mac equivalent so far as I know, sorry!) you don't need to. Just press F3 and Excel will open the named range dialog box so that you can paste in the name you need.
Reply With Quote
  #4  
Old 12-31-2016, 10:33 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Which F-key in 2016 is now used for pasting? Windows 7 64bit Which F-key in 2016 is now used for pasting? Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,780
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Interesting. Thanks and a Happy New Year
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #5  
Old 12-31-2016, 05:14 PM
Berny Berny is offline Which F-key in 2016 is now used for pasting? Windows 7 64bit Which F-key in 2016 is now used for pasting? Office 2007
Novice
 
Join Date: Dec 2016
Posts: 3
Berny is on a distinguished road
Default

I think you can use CTRL +V to paste, hope this works for you
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Which F-key in 2016 is now used for pasting? Visio 2016 diagrams embeded in word 2016 not drawing properly stubbo66 Visio 2 08-24-2016 05:58 PM
standalone access 2016 with bundled Office Family and Student 2016 EDa Office 3 06-30-2016 12:04 PM
Pasting problem Alec Word 1 11-09-2009 12:26 PM
Pasting from Word 07 gj0519 Word 1 11-03-2009 08:12 PM
Pasting numbers: Darren Word 0 04-01-2009 11:22 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:58 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft