how to get rid of paste options in excel 2016

Pretty easy right? What I like about this method is that it’s also really easy to delete rows that only have one column with blank values rather than the entire row being blank. So just sort again by column A to get the original order back. Once you delete the rows, now you can probably see why we added the column with the numbers? Before sorting, the order was “Cat, Dog, Pig, etc.” and now it’s “Bear, Cat, Cow, etc…”. As you can see, it’s easy to delete the blank rows because they are all at the bottom: Now your data should look like this below. If more than one column has blank values, just pick one.

Note that you want to sort the column that have the blank values in it. Then click on the Sort button on the Data tab.įor Sort By, choose Column B and then click OK. Now select both columns and click on the Data ribbon in Excel. Here’s what the sheet should look like before we sort the animal name column: You might ask why we would want to do this? Well, if the order of the rows matters, when we sort Column A to get rid of the blank lines, there will be no way to get the rows back in the order they were before sorting. The first thing we’ll do is insert a column and number it consecutively. Let’s say we have the following set of data in Excel and we want to get rid of the blank lines: Luckily, there is a simple and very effective way to delete blank lines without any macros. Note that these methods will work for any version of Excel, from Excel 2003 all the way to Excel 2016 and beyond. In this article, I’ll show you a couple of ways you can delete blank rows in Excel and the advantages and disadvantages for each method. Also, if it doesn’t work properly, you may have no idea how to change the macro for your particular Excel file.

On the Edit tab, remove the check marks from ‘Show Paste Options buttons’ and ‘Show Insert Options buttons’.However, if you’re not familiar with macros, this method can be difficult to implement.

To turn off the buttons in Excel 2003 and earlier:

Click Advanced, and in the Cut, Copy and Paste section, remove the check marks from ‘Show Paste Options buttons’ and ‘Show Insert Options buttons’.

Click the Office Button, then click Excel Options.

Here’s a video I created while changing the Paste/AutoFill options. I’m also testing the latest version of Camtasia Studio, and it has some settings that I need to adjust too. Now it’s time to fix them on the new laptop. For example, on my other machines I’ve changed the settings so those annoying Paste Options and AutoFill Options buttons don’t appear.

It’s nice to have a new laptop, but it’s amazing how many options and settings need to be adjusted.

How to get rid of paste options in excel 2016