ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   copy window in the way (https://www.excelbanter.com/new-users-excel/97333-copy-window-way.html)

Dave

copy window in the way
 
Hi quick question:

When i copy a cell into a row or colum by clicking and dragging the black
plus sign, a little window pops up that gives me Auto fill options. is there
a way to stop it without copying another cell? i have tried a bunch of
things but no success.

Elkar

copy window in the way
 
Try this:

TOOLS
OPTIONS
EDIT Tab
Uncheck "Show Paste Options Button"
OK

HTH,
Elkar


"Dave" wrote:

Hi quick question:

When i copy a cell into a row or colum by clicking and dragging the black
plus sign, a little window pops up that gives me Auto fill options. is there
a way to stop it without copying another cell? i have tried a bunch of
things but no success.


Dave

copy window in the way
 
Dear Elkar,

Thank you very much! ive been in that box like 5 times but never clicked
that one! doh!

thanks again for your help,
dave



"Elkar" wrote:

Try this:

TOOLS
OPTIONS
EDIT Tab
Uncheck "Show Paste Options Button"
OK

HTH,
Elkar


"Dave" wrote:

Hi quick question:

When i copy a cell into a row or colum by clicking and dragging the black
plus sign, a little window pops up that gives me Auto fill options. is there
a way to stop it without copying another cell? i have tried a bunch of
things but no success.



All times are GMT +1. The time now is 08:34 AM.

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