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 quot;Insert Copied Cellsquot;, 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 quot;Insert Copied Cellsquot; 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.
Can you not just use the Paste button?quot;HockeyFanquot; wrote:
gt;
gt; I have a spreadsheet that I share between my desktop PC and my
gt; PocketPC.
gt; It's a gas mileage calculator and log that keeps the most recent fuel
gt; purchase at the top, just below the headings.
gt; Typically, what I do is copy the top-most row and then do an quot;Insert
gt; Copied Cellsquot;, which gives me a row just above that, with all the
gt; formulas. Then I just change the date and other values, giving me the
gt; fuel cost per gallon, the beginning and ending odometer readings
gt; (bringing forward the ending from the previous row, to the beginning
gt; odometer reading on the new row).
gt; Anyway, this works fine. However, there doesn't seem to be an quot;Insert
gt; Copied Cellsquot; feature in the version of Excel that I have on the
gt; PocketPC.
gt; So I'm hoping an expert can tell me how to achieve this functionality.
gt;
gt;
gt; --
gt; HockeyFan
gt;
Originally Posted by exceluserforemanCan 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.
- Nov 03 Mon 2008 20:47
Insert Copied Cells?
close
全站熱搜
留言列表
發表留言
留言列表

