Excel Tips Easily paste special values Hidden Menu

Hi. Trying to add "formulas and number formats" to the paste special menu. Any ideas?

Thanks

Hi All:

Can someone tell me if the Paste Special pop up menu can be altered?

I am sure this is not the correct terminology... I am referring to the options that are available when you select Paste Special.

I want to change it so that the only option under Paste is Values. Can this be altered via VBA or is there an option somewhere within Excel to alter this menu. Hope this makes sense to whomever is reading it...

THANKS,
Mark

Good Evening --

I have Office XP - I use Paste Special frequently.
Paste Special is in my Drop Down Edit Menu but is NOT in my Right Click Pop up Munu. Just "Paste" Appears there.

A Friend also has Office XP and His is in the right click Menu. It was on the computer when he bought it and had no idea how / why paste special is in the Right Click Menu - He has always just taken in for granted.

I have read the Paste Special Threads here - and Searched Excel Help and find no reference to my quest.

Does Anyone know how to put it there ?


Thanks

Hi everyone,

I'm trying to get some VBA code to work to make my Excel 2000 spreadsheet paste values like Excel 2003, but so far it hasn't been working. Any suggestions?...

I recorded the following macro in Excel 2003:

Code:

Range("A1").Select
    Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
        xlNone, SkipBlanks:=False, Transpose:=False
    Range("A1").Select

Fantastic! Now to imitate this task in Excel 2000, I tried the following, which didn't even come close to working...:

Code:

Range("A1").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
        SkipBlanks:=False, Transpose:=False
    Range("A1").Select

What am I doing wrong? Can I even do this in Excel 2000 using VBA?

Hi,

I am completely new to excel programming. I have a SQL DTS which
creates an excel file and exports data into it. The created excel file
could have variable number of work sheets.

Text data in the excel file had a leading single quote character and
spaces before the data. I can get rid of these by copying entire sheet
and paste special--values into a new sheet.

Would some one tell me how to automate to create a new excel file and
copy and paste special (with values option) all the work sheets into
the new file? I appreciate any help.

Is there any shortcut or quick command to paste special values?



Thanks,
Jared

I want to add Paste Values to the right click menu in Excel 2007. Can this be done without recording a separate macro to run it? What I mean is If I add the command itself to the right click menu, can it run of of the standard RightClick -> Paste Special -> Values option, or must I record a macro that does those steps each time?

I recently started at a new company and notice a wierd issue ith Excel 2003.

When I first go into the edit menu after copying something, instead of paste special being there, I instead have paste picture link. if i leave and go back to the edit menu the paste special option reappears.

This is more than mildly annoying as I have Alt+E ,S,V/T/F hardwired into my brain, and it fails to work, due to this.

If anyone knows how to fix this I'd really appreciate it.

(and yes customized menus are disabled)

Hi all,

This had me scratching my head: at work, we're using a large-ish .xlsx file, with about 20K rows, with a lot of look-ups and so on. A messy job, but it's being kept in use due to, well, user reluctance to switch to an Access solution. You know the drill.

There is a manual operation where cells from one tab are copied and then Paste/Special/Values into another tab of the same workbook. There are three columns and about 20 thousand rows involved.

Until recently, we were using Excel 2007 and, on a stock PC, it took about 10-15 seconds for the paste operation to complete. Automatic recalculation is turned off, as there is a LOT of VLOOKUPs -- about 25 columns times 20 thousand rows.

Anyway, since our company upgraded to Excel 2010, the same paste operation now takes anywhere between 40 and 60 MINUTES. Automatic calculation is still turned off. I have no clue why is this happening. The same file, on a slower machine (2-year old HP Mini) under Excel 2007, performs the same operation in about 10 seconds.

Any clues? I am truly lost for ideas.

Cheers!

Hello

This is probably relatively easy but I can't find the relevant instructions on the net, can't even get past assigning macros to buttons as there is no 'assign macro' option when I right click on the command button (editing enabled).

Anyway... I am looking to make a button that when pressed will select the data in a range of cells, copy it, and then paste special > values that data into the same range.

If I can, I'd like help making one button which, when pressed, selects the data to the right of the highlighted cell. If this is too difficult, a button for each row would suffice.

If anyone can point me in the right direction it would be much appreciated. The most I've worked out is a macro that, when run, copies and pastes the data in a specific range... but this isn't based on what cell is selected.

The purpose of this is to make data entry easier, I'm creating a data entry sheet for traffic surveys and having to copy a range of cells, then paste special values it back into the same range might be beyond some of those who will use the data entry sheet, and so a button to do this would make life easier.

Attached are the 2 data entry sheets we currently have finished.

Thanks in advance for any pointers, I'll keep googling in the mean time and trying to learn the basics of VBA.