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!
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?
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.
