Set Default to Copy and Paste Visible Cells Only
Hello, Does anyone know if we can set the Copy and Paste Function to default into copying and pasting only the visible cells? I'm using Excel 2016 in Windows 10. I've been doing the Alt + ; and then copying it way but when copying, I never want the hidden cells anyway. So I'm wondering if this could be set as default to avoid the extra step. Thanks!
Restrict all type of content copy and paste from clipboard/windows 10 in to Microsoft team desktop
we have already achieved blocking of copying data/chat/file outside MS team (E.g. users cannot copy a chat from MS team in to a word file on local windows 10 laptop/desktop). But our requirement is to block copy, cut and paste of any data/content in to MS teams from local windows 10 (we dont want selective block by DLP rules and defined keywords e.g. PCI DSS etc.). Example user should not be able to copy any data from a word file in local machine or any copied content in clipboard and paste it in to MS team. Please support how we can achieve this, we dont want DLP based data restriction of pasting data in MS teams.Restriction should be a blanket one. Client does not need keyword specific documents/content like credit cards, company name etc to blocked from pasting in MS teams. We want complete block of copy paste and cut functionality for all content whether it is sensitive or non-sensitive. Please note our above issue is for windows 10 devices laptop and desktop. Further we have achieved blocking of files sharing as well and restrict copying of data/files outside MS team via session policy and file sharing blocks. Thanks in advance for your support. Your earliest reply will be appreciated as it is an urgent requirement of compliance.
Office 365 Update Changed the way Copy and Paste (clipboard) Works
I seem to be the only one that has this issue; however, everyone in our office (with the same version update) seems to have it as well. Basically, the clipboard no longer seems to work the same way. It used to save the copied information, even after the selected range is no longer selected -- but now, it does not. It is taking significantly more time to move data between spreadsheets. Is anyone else experiencing this, or is this perhaps an error on our offices' Office update?
Multi-line messages copy with LF endings, not CR/LF
Hi We have some multi-line text strings that regularly need to be copied out of a channel in Teams. We have found that when the text is copied, the line endings copy with a line-feed, rather than the standard Windows carriage return/line-feed - which causes some software not to display it properly. Is there any way around this so that multi-line text copies with CR/LF line endings please? Thanks!HELP: cell copied is deselected when clicking on formula bar.
MY PROBLEM The behaviour of excel seems different today, I can’t copy and paste a value directly on the formula bar any longer. When I copy a cell, it appears the usual dashed line to highlight that the cell is copied. As soon I click the Formula Bar, when any cell is selected, the dashed line disappears, and by clicking ctrl+V no value is pasted on the formula bar. I’m using Office 365, desktop version. HOW I TRIED TO SOLVE THE ISSUE I have just tried to restart the computer; I don’t know what else to try. WHAT I USED TO DO AND WHY When I need to copy a value (not formulas) from cell X to cell Y, I used to copy the cell X and paste the value directly on the formula bar of cell Y. I know that I could use Paste Special to paste only values, but the behaviour is different, and I prefer to copy directly on formula bar. For example, if in cell X the value is 1,000000005, and the cell is formatted to show only 2 decimals, I have two different value in cell Y if I paste to formula bar and or use Paste Special; if I copy and paste the value in cell Y with paste special, the value of cell Y is 1,000000005, and I need to format the cell to show only 2 decimals; on the contrary if I copy and paste on formula bar of cell Y, the pasted value is exactly 1,00, regardless of how I format cell Y. Sometimes I need the original value, sometimes I need the value already rounded; that’s why I don’t want to use paste special, but I would like to paste on formula bar. Moreover, by copying values on formula bar, instead of using paste special I also save a few clicks.
Need an easy way to collect screen shots from a group of users through copy and paste not attach
We are running an alpha UAT with a group of internal users. The UAT participants are given ~20 test cases and each test case requires them to find an answer to a question in the online product (that is in alpha release) and then answer a few questions about the experience and take a screen shot to show they got the correct answer. We are thinking of using Microsoft Forms to collect information about each test case which seems easy and provides a way to export all participant data for all test cases into an excel which is great. But the challenge we are facing is collecting a screenshot for each test case from the users and associating it with the data collected for each test case. We know Forms allows the ability to upload a file but these are busy business users and asking them to take a screenshot, save it and upload it is too much to expect and too timely. Also many users speak English but second language so we need simple instructions. So we are thinking of collecting the answers to the questions via forms but collecting the screen shots another way. Ideally, we'd like to view all screenshots from all users for a particular test case together but with each identified by the user who submitted it. Then we can easily validate that the answers are correct plus see if the page layout displays correctly for each user's unique environment (OS, browser, screen resolution, and with each user's unique data. note: the product is only available via browsers and supported on pc/laptop not phones or tablets). Having all together makes this QA easier. Any thoughts on how to do this? One solution we've thought of: Have each user copy and paste their screenshots into an excel file that we send to them. The excel file would have a tab/worksheet labeled with each test case # and the user would copy the screenshot for a particular test case and paste into the corresponding numbered labeled tab/worksheet in the excel. And then at the end of the Microsoft Form they would upload the file so it is associated with their answers to the question that they answered via Forms. However this doesn't aggregate the screenshots per question and it is a bit cumbersome because the user has to juggle 3 things: have the Microsoft Form open with the test case instructions and questions to answer, then perform the test case and find the answer in the browser where they are logged into the product, and then take a screenshot that they copy into the excel file. A lot to juggle. Any idea to make this easier using Teams? We have Microsoft Office 365. Or open to using a completely different tool for UATs. Our next phase will be to conduct the UAT with external users who won't have access to our Office 365 environment so need to solve the problem for them as well. Open to 2 different solutions for internal vs external but 1 solution would be ideal.
