Step 1: select the data > press right mouse button and the context menu will open > select copy I assume you already know that you first have to copy the data and then you can paste it. Mouse #1 – Right click copy + Right click paste Basic Copy paste with mouse or keyboard shortcut 1. I will start with the very basic use of copy/paste feature and then move on to explain other variations. But not many know that this feature is productivity heaven and it can be used in more than 30 possible ways to do things super easily and super fast! You might know how to do copy and paste in many ways like using mouse right click or ribbon or keyboard. Using Clipboard to copy paste paste paste!įor sure Ctrl+C and Ctrl+V is one of the most famous keyboard shortcut in windows environment and one big reason for it become famous beyond limits is that it can be used in almost every Windows application software including Microsoft Excel. Bonus Tip – Add multiple numbers to multiple cells Paste Special – Conducting mathematical operations using copy/paste.Paste special – Copy paste linked picture Paste Special – Copy paste picture of data range Paste Special – Copy paste link or cell reference Paste Special – Copy paste data validation Paste Special – Copy paste all except borders Paste Special – Copy paste just column widths Bonus tip – Paste special – Copy paste just formula Paste Special – Copy paste just formula and number formatting Paste special – copy paste only values and number format Bonus: Double click fill handle to fill quickly Copy/paste or Fill multiple cells repeatedly Copy/paste or Fill single cell repeatedly Basic Copy paste with mouse or keyboard shortcut.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |