ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Insert Copied Cells? (https://www.excelbanter.com/excel-discussion-misc-queries/72160-insert-copied-cells.html)

HockeyFan

Insert Copied Cells?
 
I have a spreadsheet that I share between my desktop PC and my PocketPC.
It's a gas mileage calculator and log that keeps the most recent fuel purchase at the top, just below the headings.
Typically, what I do is copy the top-most row and then do an "Insert Copied Cells", which gives me a row just above that, with all the formulas. Then I just change the date and other values, giving me the fuel cost per gallon, the beginning and ending odometer readings (bringing forward the ending from the previous row, to the beginning odometer reading on the new row).
Anyway, this works fine. However, there doesn't seem to be an "Insert Copied Cells" feature in the version of Excel that I have on the PocketPC.
So I'm hoping an expert can tell me how to achieve this functionality.

exceluserforeman

Insert Copied Cells?
 
Can you not just use the Paste button?


"HockeyFan" wrote:


I have a spreadsheet that I share between my desktop PC and my
PocketPC.
It's a gas mileage calculator and log that keeps the most recent fuel
purchase at the top, just below the headings.
Typically, what I do is copy the top-most row and then do an "Insert
Copied Cells", which gives me a row just above that, with all the
formulas. Then I just change the date and other values, giving me the
fuel cost per gallon, the beginning and ending odometer readings
(bringing forward the ending from the previous row, to the beginning
odometer reading on the new row).
Anyway, this works fine. However, there doesn't seem to be an "Insert
Copied Cells" feature in the version of Excel that I have on the
PocketPC.
So I'm hoping an expert can tell me how to achieve this functionality.


--
HockeyFan


HockeyFan

Quote:

Originally Posted by exceluserforeman
Can you not just use the Paste button?

Maybe. In the desktop version, that doesn't bring the formulas over the way the Insert Copied Cells does. In fact, I'm not sure that it brings over the formulas at all. I'll try on the mobile though.


All times are GMT +1. The time now is 09:56 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com