Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
Copy; Paste; Paste Special are disabled | Excel Discussion (Misc queries) | |||
'paste special', 'paste link' formatting transfer | Excel Discussion (Misc queries) | |||
In Excel: add a Paste-Special Option to paste IN REVERSE ORDER. | Excel Worksheet Functions | |||
Paste and Paste Special command are not enabled in Excel | Excel Worksheet Functions |