Monday, December 23, 2013

Tricks on How to Get Rid of MS Excel Auto Fill Options

MS Excel Auto Fill Options was primarily designed to help encoding repetitive data more easier and faster. However, some users are actually complaining about it because of the way it works in front of other entries. It becomes annoying in several point, right? Although it is helpful for some folks, blocking the view of other cells is a different story.

The first trick I know is to press the "Escape" key. But try to imagine the number of times you need to tap the upper-left corner key of your keyboard while working in huge of amount of data and values. On the other hand, you can actually disable the Auto Fill Options. But you need to sacrifice this helpful features for a while.

How to Get Rid of MS Excel Auto Fill Options

To disable MS Excel Auto Fill Options, see the following steps below:
  1. In the left pane of your window, click File tab and choose Options. This will only work in MS Excel 2007, 2010, and future versions. You do a different technique in Excel 2003 by choosing Options in Tools menu, and to be followed by Edit tab;
  2. You must choose Advanced in the leftmost pane;
  3. In the section of Cut, Copy, and Paste, just unchecked the "Show Paste Options Button When Content is Pasted"; and
  4. Click "OK" to proceed.
And that will disable the entire fill as well pastes options. The following figure demonstrate the above steps:

Disabling MS Excel Auto Fill Options

Susan Harkins of Tech Republic shared a helpful tips on how to get rid of Auto Fill Options. And that is to use our mouse through a simple right-clicking and dragging of entries.

In using a mouse, all you have to do is to double-click your selected row or column borders. And do not change the row height or width. Next, you must click the Zoom Out or Zoom In located at the lower right-corner or bottom of MS Excel Window.

That will automatically dismissed all the available lists. This trick will actually work at any sheet you are working with. Hopefully, this few healthy tips to avoid the annoyance of Auto Fill Options will be improved by any future more easier procedures.



Post a Comment