MS-EXCEL-47-Paste Special Option in Excel | Part-2 | Useful Technique for Data Entry & Data Cleaning
Paste Special Option in Excel | Part-2 | Useful Technique for Data Entry & Data Cleaning
MS-EXCEL-47-Excel मे Paste Special का उपयोग | पार्ट - 2
Hi,
Welcome to Mr. Coding Channel to learn something new.
In this quick and informative video, learn all about the Paste Special options in MS Excel. Discover how to utilize various options such as All, Formula, Values, Formats, Comments, Data Validation, All using source theme, All except borders, Column width, Formulas and number formats, Values and number formats, Add, Subtract, Multiply, Divide, Skip blanks, Transpose, and Link. Enhance your Excel skills and maximize your productivity with these powerful Paste Special features. Don't miss out on this essential Excel tutorial!
Subscribe to our channel for more Excel tips and tricks!
In this Part, we will learn below-given options
All: Paste the cell contents and formatting.
Formula: Paste only formulas.
Values: Paste only values and not formulas.
Formats: Copy only the cell formats and not values.
Comments: Paste only comments attached to a cell.
Data Validation: Paste only the data validation settings.
All using source theme: Paste all cell contents in the theme formatting applied to the source cell.
All except borders: Paste all cell contents and formatting, but not borders.
Column width: Paste only the column width from the copied cells.
Formulas and number formats: Paste formulas and number formats such as currency symbols, date formats, etc.
Values and number formats: Paste values (but not formulas) and number formats.
All Merging Conditional formats : To combine your copied formats with existing conditional formats in the paste area
Add: Add the copied data to the data in the destination cell(s).
Subtract: Subtract the copied data from the data in the destination cell(s).
Multiply: Multiply the copied data by the data in the destination cell(s).
Divide: Divide the copied data by the data in the destination cell(s).
Skip blanks: Prevent replacing the values in the destination range with blank cells that occur in the copied range.
Transpose: Convert the columns of copied data to rows, and vice versa.
Link: Link the pasted data to the copied data by inserting formulas like =A1.
⌚ Timestamps | Time-Line | Chapters
00:00 - What We Learn?
01:20 - Recap: simple Copy and Paste
02:24 - Paste Special Option: All
04:46 - Paste Special Option: Formula
05:12 - Paste Special Option: Values
06:49 - Paste Special Option: Formats
07:26 - Paste Special Option: Comments
09:01 - Paste Special Option: Data Validation
11:40 - Paste Special Option: All using source theme
12:11 - Paste Special Option: All except borders
12:35 - Paste Special Option: Column width
13:19 - Paste Special Option: Formulas and number formats
14:23 - Paste Special Option: Values and number formats
15:45 - Paste Special Option: All Merging Conditional formats
18:19 - Paste Special Option: Add, Subtract, Multiply, Divide
21:06 - Paste Special Option: Skip blanks
22:43 - Paste Special Option: Transpose
23:33 - Paste Special Option: Link
🔗🔗🔗🔗🔗🔗 Download the file 🔗🔗🔗🔗🔗🔗🔗🔗🔗
MS Excel Part 047 - Exercise for Practice - Visit to download
प्रेक्टिस करने के लिए एक्सरसाईझ - डाउनलोड करे
https://mrcodings.com/MsExcelPart047
--------------------------------------
--------------------------------------
🎇🎇🎇🎇🎇🎇🎇 Related Video 🎇🎇🎇🎇🎇🎇🎇
Excel Conditional Formatting | All Parts
• Conditional Formatting | MS Excel | B...
-------------------------------------
--------------------------------------
🎇🎇🎇🎇🎇🎇🎇 Related Video 🎇🎇🎇🎇🎇🎇🎇
Excel Tutorial Playlist | All Parts
• Free Excel Tutorial | MS Excel Tutori...
-------------------------------------
🟢 MS Excel Tutorial Playlist
https://mrcodings.com/ms-excel-tutorial
-----------
🔵 MS Word Tutorial Playlist
https://mrcodings.com/ms-word-tutorial
-------------
🟢 Tally Tutorial in Gujarati
• Tally Tutorial in Gujarati
-------------
Our 🧒📘 FaceBook
/ mrcoding33
-------------
Our 📷 Instagram
/ mrcoding33
-------------
🔵 Join Our Telegram Channel
https: //t.me/mrCoding33
-------------
Official 🌐 Website
https://mrcodings.com
-------------
#MSExcelPart47 #ExcelPart47 #PasteSpecialOption #PasteOptions #MrCoding #MrCoding33 #MisterCoding #ExcelTechniques #Excel2021 #ExcelTutorialForBeginners #MicrosoftExcelTutorial #MSExcel #Excel365 #ExcelTutorial
Смотрите видео MS-EXCEL-47-Paste Special Option in Excel | Part-2 | Useful Technique for Data Entry & Data Cleaning онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Mr Coding 18 Июнь 2023, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 1,571 раз и оно понравилось 45 людям.