ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I turn off the autofill option button that comes on? (https://www.excelbanter.com/excel-discussion-misc-queries/108896-how-do-i-turn-off-autofill-option-button-comes.html)

lar.ridge

How do I turn off the autofill option button that comes on?
 
Whenever I do an autofill of formulae, this annoying little square come on my
spreadsheet. It adds no value to what I am doing and does not give me an
option of it not displaying. Is there a way to stop it?

RagDyeR

How do I turn off the autofill option button that comes on?
 
Try this:

<Tools <Options <Edit tab,

And *UNCHECK*

"Show Paste Options"

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"lar.ridge" wrote in message
...
Whenever I do an autofill of formulae, this annoying little square come on
my
spreadsheet. It adds no value to what I am doing and does not give me an
option of it not displaying. Is there a way to stop it?



lar.ridge

How do I turn off the autofill option button that comes on?
 
That worked, I thought I had tried. Thanks

"RagDyeR" wrote:

Try this:

<Tools <Options <Edit tab,

And *UNCHECK*

"Show Paste Options"

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"lar.ridge" wrote in message
...
Whenever I do an autofill of formulae, this annoying little square come on
my
spreadsheet. It adds no value to what I am doing and does not give me an
option of it not displaying. Is there a way to stop it?




sjk153

How do I turn off the autofill option button that comes on?
 
Go to the Tools menu, select Options, go to the Edit tab
1) Unselect the box for 'Show Paste Options Buttons' and
2) Unselect the box for 'Show Insert Options Buttons'

"lar.ridge" wrote:

Whenever I do an autofill of formulae, this annoying little square come on my
spreadsheet. It adds no value to what I am doing and does not give me an
option of it not displaying. Is there a way to stop it?



All times are GMT +1. The time now is 12:37 AM.

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