software

I have a user who claims she used to be able to copy from one cell, then
paste to another cell, then in each subsequent cell she could just hit the F4
key to keep pasting the same info into other cells. For some reason she
doesn't want to use the Ctrl V feature.

By default the F4 key cycles you through the 4 different type of cell
references; Absolute, Relative, Absolute Column-Relative Row and Relative
Column-Absolute Row. Without some kind of 3rd party utility or someone
writing code to remap the keyboard, I don't know of any other way to modify
the F4 assignment.
--
Kevin Backmannquot;donmortinquot; wrote:

gt; I have a user who claims she used to be able to copy from one cell, then
gt; paste to another cell, then in each subsequent cell she could just hit the F4
gt; key to keep pasting the same info into other cells. For some reason she
gt; doesn't want to use the Ctrl V feature.

Actually F4 is repeat previous action as well, it will only work as you
describe with formulas.
Put 1 in A1:10, select A1, press delete, select A2 and press F4. It's very
handy at times but also very dangerous if you don't pay attention--

Regards,

Peo Sjoblom

nwexcelsolutions.com
quot;Kevin Bquot; gt; wrote in message
...
gt; By default the F4 key cycles you through the 4 different type of cell
gt; references; Absolute, Relative, Absolute Column-Relative Row and Relative
gt; Column-Absolute Row. Without some kind of 3rd party utility or someone
gt; writing code to remap the keyboard, I don't know of any other way to
gt; modify
gt; the F4 assignment.
gt; --
gt; Kevin Backmann
gt;
gt;
gt; quot;donmortinquot; wrote:
gt;
gt;gt; I have a user who claims she used to be able to copy from one cell, then
gt;gt; paste to another cell, then in each subsequent cell she could just hit
gt;gt; the F4
gt;gt; key to keep pasting the same info into other cells. For some reason she
gt;gt; doesn't want to use the Ctrl V feature.
F4 repeats previous action so it's not the same as Ctrl V--

Regards,

Peo Sjoblom

nwexcelsolutions.comquot;donmortinquot; gt; wrote in message
news
gt;I have a user who claims she used to be able to copy from one cell, then
gt; paste to another cell, then in each subsequent cell she could just hit the
gt; F4
gt; key to keep pasting the same info into other cells. For some reason she
gt; doesn't want to use the Ctrl V feature.
quot;is repeatingquot;Peoquot;Peo Sjoblomquot; gt; wrote in message
...
gt; Actually F4 is repeat previous action as well, it will only work as you
gt; describe with formulas.
gt; Put 1 in A1:10, select A1, press delete, select A2 and press F4. It's very
gt; handy at times but also very dangerous if you don't pay attention
gt;
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; nwexcelsolutions.com
gt;
gt;
gt;
gt; quot;Kevin Bquot; gt; wrote in message
gt; ...
gt;gt; By default the F4 key cycles you through the 4 different type of cell
gt;gt; references; Absolute, Relative, Absolute Column-Relative Row and Relative
gt;gt; Column-Absolute Row. Without some kind of 3rd party utility or someone
gt;gt; writing code to remap the keyboard, I don't know of any other way to
gt;gt; modify
gt;gt; the F4 assignment.
gt;gt; --
gt;gt; Kevin Backmann
gt;gt;
gt;gt;
gt;gt; quot;donmortinquot; wrote:
gt;gt;
gt;gt;gt; I have a user who claims she used to be able to copy from one cell, then
gt;gt;gt; paste to another cell, then in each subsequent cell she could just hit
gt;gt;gt; the F4
gt;gt;gt; key to keep pasting the same info into other cells. For some reason she
gt;gt;gt; doesn't want to use the Ctrl V feature.
gt;
gt;

F4 just re-do the last action performed by the user. She could be right
if her last action was PASTE she can keep using last action as PASTE
(same thing) in different cells.
SA--
saziz
------------------------------------------------------------------------
saziz's Profile: www.excelforum.com/member.php...foamp;userid=6350
View this thread: www.excelforum.com/showthread...hreadid=529354