How to disable cut, copy and paste functions in Excel?
Supposing you have a workbook with important data which you need to protect from being cut, copied and pasted. How to achieve it? This article provides a VBA method for you to disable the cut, copy and paste functions at the same time in an Excel workbook.
Recommended Excel Productivity Tools
Bring tabbed editing and browsing to Office (include Excel), much more powerful than the browser's tabs. Free Download..
More than300 powerful advanced features for Excel, designed for1500 work scenarios, save70% time for you. Free Download..
Disable cut, copy and paste functions with VBA code
Amazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari!
Save 50% of your time, and reduce thousands of mouse clicks for you every day!
Please do as follows to disable the cut, copy and paste functions in an Excel workbook.
1. In the workbook you need to disable the cut, copy and paste functions, please press the Alt + F11 keys simultaneously to open the Microsoft Visual Basic for Applications window.
2. In the Microsoft Visual Basic for Applications window, please double click ThisWorkbook in the left Project pane, and then copy and paste the below VBA code into the ThisWorkbook (Code) window. See screenshot:
VBA code: Disable the cut, copy and paste functions at the same time in Excel
3. Then please press the Alt + Q keys to exit the Microsoft Visual Basic for Applications window.
Now you can’t cut or copy data from this workbook, meanwhile, data you have copied from other sheets or workbooks cannot be pasted into this workbook.
Note: The drag and drop function is also disabled after running the above VBA code.
Related articles:
Recommended Productivity Tools for Excel
Kutools for Excel Helps You Always Finish Work Ahead of Time, and Stand Out From Crowd
- More than300 powerful advanced features, designed for1500 work scenarios, increasing productivity by70%, give you more time to take care of family and enjoy life.
- No longer need memorizing formulas and VBA codes, give your brain a rest from now on.
- Become an Excel expert in 3 minutes, Complicated and repeated operations can be done in seconds,
- Reduce thousands of keyboard & mouse operations every day, say goodbye to occupational diseases now.
- 110,000 highly effective people and 300+ world-renowned companies' choice.
- 60-day full features free trial. 60-day money back guarantees. 2 years of free upgrade and support.
Brings Tabbed Browsing and Editing to Microsoft Office, Far More Powerful Than The Browser's Tabs
- Office Tab is designed for Word, Excel, PowerPoint and Other Office Applications: Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by50%, and reduces hundreds of mouse clicks for you every day!
or post as a guest, but your post won't be published automatically.
Loading comment.. The comment will be refreshed after 00:00.
- THANKS SIR
- To post as a guest, your comment is unpublished.Thanks it works perfect ..can it be applied on a range only somehow?
- Good day,
Sorry can't help you with that. Welcome to post any question in our forum: https://www.extendoffice.com/forum.html. Thank you for your comment.
- To post as a guest, your comment is unpublished.It really works well, thanks a lot.
- To post as a guest, your comment is unpublished.Hi, the code works well thanks.
However, the read only option was enabled. (if you don't want to modify). If I set .File, save as, tools, general options, read only recommended. then the code does not work.
Thanks in advance. - To post as a guest, your comment is unpublished.Thank your for your direction.I am Trying in office 2013 ,but nothing changed.
When trying to paste data into Excel, you may run across this error. The most likely cause is that you have selected a group of cells to copy and then when you want to paste, you have selected another group of cells that are not the same cell size. Usually you can get past this error by selecting only a single cell and pasting to that cell. The cell you selected will act as the top-left most cell in the pasted selection, or the top most cell if it's only a single column of data. However, there is another cause for this error that can be elusive.
Check to make sure that you have not grouped your sheets. There are a couple of ways to tell. First, ungrouped sheets are a different color than the selected, active sheet. In the screenshot below, notice the different color between Sheet1 and the other sheets.
In a grouped set of sheets, notice they are all the same color.
One other way to tell is to look to the top of your workbook. If you see [Group] beside the workbook name, then you know you have grouped sheets. You can't copy a single cell from a group of sheets and paste to a workbook cell with non grouped sheets. What Excel is trying to do is copy the cells you selected from not one workbook, but from all of the grouped workbooks, as if they were stacked. Then when you select a single cell in an ungrouped workbook, Excel determines that you are trying to paste the grouped cells into a single cell on a single worksheet and says 'Nope, can't fit all of that there!' Imagine trying to fit a single stack of 100 folded towels into a small suitcase and close the lid. It would be impossible.
To group worksheets, select a worksheet and then hold the SHIFT key down and select another worksheet. You can also hold down the CTRL key to do a relative selection (you can pick and choose). When multiple sheets are selected in this manner, the sheets are automatically grouped and the [Group] warning appears at the top of the workbook. You can ungroup the sheets by selecting only one of the worksheets in a grouping and the rest will turn the darker color. You can also right click a group of selected sheets and left click the 'Ungroup Sheets' option.
Related Articles
- 1 Paste From PDF Format to Excel
- 2 Copy Data From a Web Database
- 3 Working With Word & Excel Together
- 4 Preview an Excel Worksheet Saved As a Web Page
Copying material from the internet into your Excel spreadsheet can be easy. Or pretty difficult. It all depends on what exactly you're trying to copy and how you would like it to appear in your spreadsheet. If you want to copy a link or copy some text, the process is pretty straightforward. If you have an image to transfer, one you save from the net, say, it can be simple if you're lucky, but can also get a bit complicated. Copying data tables from the internet to Excel can be the trickiest of all, but it can be done!
Copy Text
Simply highlight the text you want to want to copy from the internet and type Ctrl+C to copy it into your clipboard. Then use the Ctrl+V command to paste the text into a cell of your choosing in your Excel spreadsheet. The pasted text will retain the formatting from the website. To paste plain text instead, first paste it into Notepad or a similar text editor, then copy and paste it again into Excel.
Tip
- You can also use the Paste Special option in Word to remove any formatting from text.
Copy a Link
To copy a hyperlinked web address from the internet, treat it just like text by highlighting it, copying it and pasting directly into Excel. It will display as the text from the webpage, with the underlying URL active. Alternatively, you can right-click the link to open an options menu, and select Copy link address to save and paste only the URL, without including the visible text.
Copy an Image
You can easily copy and paste many images into Excel, especially image files that have a jpg file extension. Once pasted, you can resize the image by clicking on it, grabbing a corner with your cursor, and dragging it to a larger or smaller size.
For images that don't respond to a simple copy and paste, click on the Insert menu in Excel, select Illustrations, and from the Illustrations pull-down, select the option that best suits your circumstances. For example, you might insert an image from a file you saved or an image directly from an online source.
One of the most flexible options in Excel under Insert/Illustrations is Screenshot. You can take a screenshot of any image using the print screen key on your keyboard (usually labeled as PrtSc or PrtScrn). If you're on a Mac, you can use the print screen function by executing the following command: Command+Ctrl+Shift+3. Once the image is saved, use the Screenshot option to insert it to your spreadsheet.
Tip
- The Screenshot option is a particularly good method for copying sections of a PDF document that you want to add to your spreadsheet.
Copy a Table of Data
You have three options for copying tabular data from the internet into Excel. Try them in order:
- Direct copy and paste: Highlight the data you want to insert, copy it and paste it directly to your spreadsheet. With luck, the data will neatly arrange itself into rows and columns. If the paste option does not work, use the Undo command – Ctrl+Z on your keyboard – to remove it.
- Indirect copy and paste: Copy the data, paste it to Notepad to remove any formatting, then recopy it and paste it into Excel. You can also try Paste Special into Word, using a variety of the pasting options available, to see which one works best with a final paste into Excel.
- Use the Excel Data commands: Click Data on the Excel menu to open the Get & Transform Data box, and select From Web as your option. This will open a new options box where you can insert the URL of the page that you want to copy data from. Then select the table on the page you wish to copy and keep your fingers crossed that it works!
Tip
- When downloading files from an online source, don't confuse your intent to save from the net with savefrom.net, which is a YouTube video downloader that sometimes shows up in search results.
References (3)
About the Author
David Sarokin is a well-known Internet specialist with publications in a wide variety of topics for small businesses, from the best uses of information technology to the steps for incorporating your business. As a small business owner himself, he brings an experienced perspective to all his work. He is the author of Missed Information (MIT Press, 2016), detailing how our social systems like health care, finance and government can be improved with better quality information, and is working on a new book on the future of corporations.
Cite this Article Choose Citation Style
Sarokin, David. 'How to Copy From the Internet and Paste Into Excel.' Small Business - Chron.com, http://smallbusiness.chron.com/copy-internet-paste-excel-40505.html. 13 August 2018.
Sarokin, David. (2018, August 13). How to Copy From the Internet and Paste Into Excel. Small Business - Chron.com. Retrieved from http://smallbusiness.chron.com/copy-internet-paste-excel-40505.html
Sarokin, David. 'How to Copy From the Internet and Paste Into Excel' last modified August 13, 2018. http://smallbusiness.chron.com/copy-internet-paste-excel-40505.html
Note: Depending on which text editor you're pasting into, you might have to add the italics to the site name.
If there is one thing that unites us all, it has to be the frustration to keep up with a slow excel spreadsheets.
While the impact on the performance may be negligible when there is less data, it becomes more profound as you add more and more data/calculations to the workbook.
9 out of 10 times, an Excel user would complain about the slow Excel spreadsheets. And there is hardly anything you can do about it. Fallout 4 see yourself in first person.
Well, that’s NOT completely true.
The way Excel has been made, it does get slow with large data sets. However, there are many speed-up tricks you can use to improve the performance of a slow Excel spreadsheet.
10 Tips to Handle Slow Excel Spreadsheets
Here are 10 tips to give your slow Excel spreadsheet a little speed boost, and save you some time and frustration (click to jump to that specific section).
- Avoid Volatile Functions (you must).
- Use Helper Columns.
- Avoid Array Formulas (if you can).
- Use Conditional Formatting with Caution.
- Use Excel Tables and Named Ranges.
- Convert Unused Formulas to Values.
- Keep All Referenced Data in One Sheet.
- Avoid Using Entire Row/Column in References.
- Use Manual Calculation Mode.
- Use Faster Formula Techniques.
1. Avoid Volatile Formulas
Volatile formulas are called so because of a reason. Functions such as NOW, TODAY, INDIRECT, RAND, OFFSET etc. recalculate every time there is a change in the workbook.
For example, if you use NOW function in a cell, every time there is a change in the worksheet, the formula would be recalculated and the cell value would update.
This takes additional processing speed and you end up with a slow excel workbook.
As a rule of thumb, avoid volatile formulas. And if you can’t, try and minimize its use.
2. Use Helper Columns
Helper columns are one of the most under-rated design constructs in Excel. I have seen many people shy away from creating helper columns.
How To Copy And Paste Excel Comments
DON’T DO That.
The biggest benefit of using ‘Helper Columns’ is that it may help you avoid array formulas.
Now don’t get me wrong. I am not against array formulas. Rather I believe these could be awesome in some situations. But it when you try to do it all with one long formula, it does impact the performance of your Excel workbook. A couple of array formulas here and there shouldn’t hurt, but in case you need to use it in many places, consider using helper columns.
Here are some Examples where helper columns are used:
3. Avoid Array Formulas
Array formulas have its own merits – but speed is not one of those.
As explained above, array formulas can take up a lot of data (cell references), analyze it, and give you the result. But doing that takes time.
If there is a way to avoid array formulas (such as using helper column), always take that road.
4. Use Conditional Formatting with Caution
I absolutely love conditional formatting. It makes bland data look so beautiful. Instead of doing the comparison yourself, now you can simply look at a cell’s color or icon and you’d know how it compares with others.
But. here is the problem.
Not many Excel users know that Excel Conditional Formatting is volatile. While you may not notice the difference with small data sets, it can result in a slow excel spreadsheet if applied on large data sets, or applied multiple times.
Word of advice – Use it Cautiously.
5. Use Excel Tables and Named Ranges
Excel Table and Named Ranges are two amazing features that hold your data and makes referencing super easy. It may take a while to get used to it, but when you start using it, life becomes easy and fast.
In creating>Session expired
Please log in again. The login page will open in a new tab. After logging in you can close it and return to this page.