Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 124
Default Paste Special

I have created a lattitude/longitude spreadsheet, wherein I search the
lattitudes and longitudes of various cities in order to compute the distance
between them.

In my city "look-up" routines, I ALWAYS copy from cells H2 and I2 and paste
into cells B4 and B5.

I ALWAYS must use 'paste speciial' because I need to paste into B4 and B5
the VALUES of the cells in H2 and I2.

QUESTIONS:
1. Are there any keyboard strokes I can use to accomplish my copy and
paste?
and (like CTRL 'V' [except paste special]),
2. Are there any commands I can place in cells B4 and B5 which will
copy the 'value' of the 2 cells...H2 and I2?

Thank you,

FLKulchar
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't Copy and Paste or Paste Special between Excel Workbooks wllee Excel Discussion (Misc queries) 5 April 29th 23 03:43 AM
Copy; Paste; Paste Special are disabled Mack Neff[_3_] Excel Discussion (Misc queries) 0 April 28th 08 06:29 PM
'paste special', 'paste link' formatting transfer jrebello Excel Discussion (Misc queries) 2 July 25th 07 08:46 AM
In Excel: add a Paste-Special Option to paste IN REVERSE ORDER. stan-the-man Excel Worksheet Functions 7 June 14th 06 08:10 PM
Paste and Paste Special command are not enabled in Excel mcalder219 Excel Worksheet Functions 0 April 26th 06 06:57 PM


All times are GMT +1. The time now is 07:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"