Best Way to Align Objects | Distribute Objects in MS Office

Align Objects | Distribute Objects in Word, Ppt, & Excel Manually aligning object is a time-consuming process. But Word, Ppt, Excel has a great feature to align any object, such as a picture, shape, textbox, 3D Models, Icons, etc. with a click. Besides this, you can also easily distribute more objects horizontally or vertically. Important […]

Read More »

The Best Way to Use Go To in Word With Step-By-Step – 2021

Go To in Microsoft Word  Go To command is one of the best ways to move forward or backward relative to the location of a page, paragraph, line, section, bookmark, footnote, endnote, field, table, graphic, equation, etc. (To go to a specific location in word document and the number of items you can move forward […]

Read More »

An Introduction and User Interface to Microsoft Word 21’s Best

Introduction and User Interface to MS Word Introduction to MS Word: Microsoft Word is a powerful word processing application software, and is the part of the MS-Office Suite of Applications. Word is used to sort, share, and store data with different formatting such as Real-Time Format (RTF), Unformed, Html Format, Unformulated Unicode Text, Picture Enhanced […]

Read More »

Magical Shortcut Keys and Hidden Secrets in MS-Word 2019

Magical Shortcut Keys and Hidden Secrets Magical Shortcut Keys  and Hidden Secrets: There are many secrets, features and magics that are kept in MS Word. These tips and tricks in word help you make your document work faster and easier. So, there is no doubt that you don’t know all these secrets. I challenge you. You […]

Read More »

30 Ways to Select Text in MS-Word & Excel

30 Ways to Select Text in MS-Word 30 Ways to Select Text in MS-Word : There are several selection techniques are provided in MS-Word. These selection techniques includes Shortcut Keys, Mouse, and other Commands to select all the text, paragraph, line, word, character, any block and vertical selection. To learn all these tips and tricks, you should read […]

Read More »

Difference Between Functions and Formulas in Excel-21’s Big

Introduction to the “Difference Between Functions and Formulas in MS-Excel”: The function is a pre-defined operation that means it already exists and were developed by Microsoft Corporation as a part of an Excel Application. Whereas Formula is a user-defined operation that means it is like a general calculation doing by the wish of the user.  […]

Read More »

What are the Keyboard Navigation keys? | 2021’s Master

What are the Keyboard Navigation Keys? The keyboard navigation keys are used to move the cursor or mouse pointer around the document area or screen. These are; Left arrow, Right arrow, Up arrow, and Down arrow, and Page up, Page down, Home, and End keys. What are the Keyboard Navigation Keys?​ Sourse: Redragon Karura K502 […]

Read More »

Change Watermark for Selected Pages in MS Word 2021’s Gift

How to Change Watermark for Selected Pages in MS Word Watermark text is useful as a sign, which appears behind the content to identify various types of important documents such as bond papers, stamps, mark sheets, documents, and materials. It is also useful to prevent duplicate documents, identify their own contents, and claim the ownership […]

Read More »

Freeze Panes in MS-Excel 2021’s Secret – Must Read

Freeze Panes in MS-Excel – Freeze Rows and Columns in MS-Excel Freeze Panes in MS-Excel: Freeze the Upper, Left or both part of the Row and Column Headings to keep it visible while the rest of the worksheet scrolls up and down or left and right, called Freeze Panes. Remove freezing the rows, columns or both […]

Read More »

Conditional Formatting in MS-Excel 2019 | New & Advanced

Conditional Formatting In MS-Excel Conditional Formatting in MS-Excel is one of the best features to format or highlight cells (with different colors) that contain data. This feature will help us easily spot certain cells with data based on the condition we have given. The data in the cells may include Less than any number, Greater […]

Read More »

Always Open Read Only in MS-Word, Excel, Ppt 2019

Always Open Read Only in MS-Word Always Open Read Only in MS-Word, Excel, Ppt: To prevent accidental changes from someone, you can enable “Always Open Read-Only” command. This process is only for an informational purpose but, it doesn’t protect your file. The changes are depending upon the readers. When you enable it, your file will […]

Read More »

Encrypt a Word Document or Excel Workbook with Password-20

How to Delete a Blank Page in Microsoft Word 2020 SecretMagical Shortcut Keys and Hidden Secrets in MS-Word 2019Conditional Formatting in MS-Excel 2019 | New & AdvancedBold, Italic, and Underline in MS-Word 2019, 2016…2007Different Watermark for Different Pages in Word 2019 | New Encrypt a Word Document or Excel Workbook with Password Encrypt a word […]

Read More »

What is Synchronous Scrolling in MS-Word & Excel?_Trick-1

What is Synchronous Scrolling in MS-Word & Excel: Synchronous scrolling is one of the great features, used to compare contents of two documents at the same time by scrolling one of the two documents. To use this feature, follow the steps below. Synchronous Scrolling in MS-Word: Open or create two excel worksheets that you want […]

Read More »

How to Select Text Vertically in MS-Word_No:1 Trick

Different Watermark for Different Pages in Word 2019 | NewBold, Italic, and Underline in MS-Word 2019, 2016…2007Conditional Formatting in MS-Excel 2019 | New & AdvancedMagical Shortcut Keys and Hidden Secrets in MS-Word 2019How to Delete a Blank Page in Microsoft Word 2020 Secret How to Select Text Vertically in MS-Word: This article provides you a […]

Read More »

Find Text using Navigation Pane in MS-Word

Columns for Different Pages and Sections in MS-Word |1 Gift How to Find Text using Navigation Pane in MS-Word 2019, 2016: Are you not able to find the words in the document quickly If your document contains more pages with lots of contents? Here are the solution with Navigation Pane. The Navigation pane is the […]

Read More »

Bold, Italic, and Underline in MS-Word 2019, 2016…2007

Shortcuts for Increase or Decrease Font Size in MS-Word 2019Columns for Different Pages and Sections in MS-Word |1 Gift Bold, Italic, and Underline in MS-Word Bold, Italic, and Underline in MS-Word 2019, 2016, 2013, 2010, and 2007: Bold, Italic, and Underline commands are very important to format your text in the document. In fact, without these […]

Read More »

How to Recover Unsaved Word Document, Workbook & Ppt 2019

Recover Unsaved Word Document, Workbook & Ppt. Recover Unsaved Word Document, Workbook & Ppt. in MS-Office: Did you lose your document or workbook which you not saved? So, don’t worry, here is a solution to Manage all your unsaved document or excel workbook by recovering necessary or deleting unnecessary files. To do so get started […]

Read More »

How to Bookmark Document Location in MS-Word 2019 | Latest

Bookmark Document Location in MS-Word 2021’s Big Bookmark document location: Creating bookmark is a feature used to jump anywhere within the document. A bookmark in MS Word means that any location or content in a document can be saved with its corresponding names, and the same location or content can be navigated by a bookmarked […]

Read More »

Columns for Different Pages and Sections in MS-Word |1 Gift

Shortcuts for Increase or Decrease Font Size in MS-Word 2019Different Watermark for Different Pages in Word 2019 | NewHow to Delete a Blank Page in Microsoft Word 2020 Secret Columns for Different Pages and Sections in MS-Word Accommodate Columns for Different Pages and Sections in MS-Word: In the word document, you can split (divide) text […]

Read More »

Create a Custom AutoFill Series List in Excel 20 | Excellent

Conditional Formatting in MS-Excel 2019 | New & AdvancedMagical Shortcut Keys and Hidden Secrets in MS-Word 2019Difference Between Functions and Formulas in Excel 20 MasterPaste Special in Excel & Word with No.1 Shortcuts ​Freeze Panes in MS-Excel 2020’s Secret – Must Read Create Custom AutoFill Series List in Excel Create Custom AutoFill Series List in […]

Read More »

Shortcuts for Increase or Decrease Font Size in MS-Word 2019

Shortcuts for Increase or Decrease Font Size in MS Word Shortcuts for Increase or Decrease Font Size in MS-Word Shortcuts for Increase or Decrease (Grow or Shrink) Font Size: Since it is usually a time-consuming task to increase or decrease the size of a text with the mouse, using the keyboard shortcuts instead of the mouse can increase […]

Read More »

How to Take a Screenshot in 5 Different Ways On and Offline

How to Take a Screenshot in 5 Different Ways How to take a Screenshot: There are several ways to take a screenshot/snapshot using the keyboard, applications, and online. Best methods are suggested below. Or, watch the video tutorial below this post. Method-1: How to Take a Screenshot Using Window Key: Follow the steps below to take […]

Read More »

Objective-Multiple Choice Questions on MS-Office 20 Special

Objective-Multiple Choice Questions on MS-Office This article on Objective-Multiple Choice Questions on MS-Office provides you MCQ Questions on MS-Office. MCQ are useful for any interviews and competitive exams. So, get started to read now. Objective-Multiple Choice Questions on MS-Office Starts Now 1.      Where will the contents of the document be stored after cutting or pasting? […]

Read More »

How to Show or Hide Desktop Icons in Windows 10 and 8

How to Show or Hide Desktop Icons in Windows OS Show or Hide Desktop Icons in Windows 10 and 8: A desktop icon is a graphical representation of a program, file, or folder that can be accessed quickly. Frequently used icons that can be accessed in the system are Control Panel and Recycle Bin. So […]

Read More »

Page, Paragraph, Line, and Column Breaks in MS-Word 21’s Master

Page, Paragraph, Line, and Column Breaks in MS-Word​ Page, Paragraph, Line, and Column Breaks in MS-Word: In this article, you will learn a very important topic related to the paragraph formatting,  such as a Page Break, Paragraph Break, Line Break, and a Column Break in the word document. Page Break in MS-Word: Start a new […]

Read More »

What is Page Break Preview in Excel 2019?

What is Page Break Preview in Microsoft Excel 2019? Page Break Preview shows the worksheet by separating it as pages that contain contents which are to be printed. Before going to take printout the worksheet area, you may check out in which part of the worksheet is to be printed by dividing the number of […]

Read More »

Distribute Rows and Columns of a Table Equally in MS-Word

Distribute Rows and Columns of a Table Introduction to Distribute Rows and Columns of a Table: If the row height or column width of a table not equally or evenly distributed, the “Distribute Row Height” and ” Distribute Column Width” options help you distribute all the rows heights and columns widths equally when row heights […]

Read More »

Left, Right, Center, and Justification Alignments in MS-Word

Left, Right, Center, and Justification Alignments Left, Right, Center, and Justification Alignments in MS-Word: Paragraph alignments make a document professionally easy to read. A paragraph is a form of one or more lines, a line is a group of words, and a word is a combination of other characters. Generally, a paragraph aligns Left, Center, Right […]

Read More »

How to Copy Text as Picture in Microsoft Excel

How to Copy Text as Picture in Microsoft Excel How to Copy Text as Picture in Microsoft Excel : This command is a great way to copy the content as shown on the screen or as shown when printed in a Bitmap or Picture Format. And you can paste it wherever you want in the […]

Read More »

Paste Special in Excel & Word with No.1 Shortcuts ​

Paste Special in Excel & Word with No.1 Shortcuts Paste Special Feature in MS Excel: The Paste special is a feature, used to paste the copied contents in a specific format. Using this feature, you can paste several formats like, formulas, values, formats, comments, data validation, number formats. Also, you can add, multiply, subtract, or […]

Read More »

How to Set Multiple Page Sizes in MS Word 2021’s Challenge

How to Set Multiple Page Sizes in Word Document Set Multiple Page Sizes in Word: Set default page/paper size as other page sizes such Letter size, A4 size, Tabloid, Envelope size, and custom page sizes at a time in the document. You can add (change) more mixed page sizes (different or custom page sizes)  wherever you […]

Read More »

Different Page Borders for Different Pages in Word 21’s BIG

Different Page Borders for Different Pages in MS-Word Different Page Borders for Different Pages: To give your word document a good look, apply different types of borders to different pages. To do so, follow the steps below with pictorial directions. Steps to Start the Different Page Borders for Different Pages First, add enough pages in […]

Read More »

Introduction to MS Excel & User Interface to MS Excel

Introduction to MS Excel Introduction to MS & User Interface to Excel: Excel is an electronic spreadsheet program, developed by Microsoft Corporation.  An Excel Spreadsheet is used to record, validate and analyze the numeric data for maintaining Payrolls, Selling and purchasing of product orders, Progress Reports, family budgets, and more. These are calculated whether using […]

Read More »

Top Online Video Converter Software’s in 2020 | Excellent

Top Online Video Converter Software’s in 2020 Top Online Video Converter Software’s in 2020: Apowersoft Free Online Video Converter is one of the great applications besides Wondershare and other software’s for Windows and Mac OS. You can convert and edit any Video and Audio formats extremely fast. It is a Free and open source software with […]

Read More »

6-Ways to Insert New Worksheet In Microsoft Excel

6-Ways to Insert New Worksheet In Excel: 6-Ways to Insert New Worksheet In MS-Excel: In excel spreadsheet, there are several options are there to insert the “New Worksheet”. These are whether Keyboard shortcut or other options from the ribbon. in this article, 6 different ways are provided below to insert new worksheet in excel. Method-1: Click the New Sheet […]

Read More »

Change Worksheet Tab Color in 5-Ways in MS-Excel

Change Worksheet Tab Color in 5-Ways:  There are several ways to change the worksheet tab color by using the shortcut keys or other commands in excel. Changing the worksheet tabs colours helps us to understand the difference between the tabs of different works easily. So, follow one of the 5 methods you like or all. […]

Read More »

Most Important Shortcut Keys of MS Word – 2021’s Master

Shortcut keys of MS Word Shortcut Keys of MS Word: To do document work faster you need to use shortcut keys that are used frequency. shortcut keys reduce the mouse work and makes document work pretty fast in less time. Most Important and Frequent used shortcuts of MS Word are discussed below. Most Important Shortcut Keys […]

Read More »

Quick Access Toolbar in MS-Word 2019 | Imaginative

Quick Access Toolbar in MS-Word Customize Quick Access Toolbar in Microsoft Office Word:  Do you wanna use the commands of the word quickly and frequently so, customize the quick access toolbar by adding or removing the commands? The Quick Access Toolbar locates at the top left corner on the title bar. By default, the Quick Access Toolbar […]

Read More »

Ribbon Display Options in MS-Word 2019, 2016, and 2013

Ribbon Display Options in MS-Word Ribbon Display Options are very useful to control the Ribbon Tabs and Groups. It appear at 4th position from the top right corner of the office applications (Left to the Control Buttons). The list of 3 options under the Ribbon Display Options in MS-Word is the Auto-Hide Ribbon, Show Tabs, Show Tabs […]

Read More »

File Menu Options in Microsoft Word, Excel & Ppt 2019-2013

File Menu Options in MS-Word File Menu Options in MS-Word: The File menu controls and accesses the file functions of the MS-Office Products. Formally, a file menu handles the files by using various commands. The list of file menu commands is info, New, Open, Save, Save as, Print, Share, Export, Account, Share, options, and Close. What is an […]

Read More »

Hidden Control Buttons in MS-Word 2019

Hidden Control Buttons in MS-Word Hidden Control Buttons in MS-Word: The Hidden Control Buttons are contextual, that appears based upon the Left or Right click on the Title bar. There is a slight difference between the Hidden Control Buttons and the Control Buttons. In general, the control buttons include Minimize, Restore Down/Maximize and Close, appear at the top right corner of the MS Office […]

Read More »

Change Color Themes in Microsoft Office 2020 Master

Change Color Themes in Microsoft Office Products: Change Color Themes in Microsoft Office: To change the Office Color Themes in Word, Excel, PPT or Other Office Applications, follow the steps below: Go to the “File” menu in one of the office applications. For example, MS-Word Then select the “Account” After that, click the drop-down arrow of the Office Theme Under […]

Read More »

Cut, Copy, and Paste the Contents in Word – The Master 2021

Cut, Copy, and Paste the Contents How to Cut, Copy and Paste the Contents of the Clipboard in MS-Word: Cutting, copying and pasting are the most important options for the Clipboard in MS Word. The cut and copy commands help you temporarily store content on the Clipboard, and the Paste command will help you get the content of […]

Read More »

How to Use Format Painter in Microsoft Word 2019 | Master

How to Use Format Painter in MS-Office Word Format Painter Copies formatting from one text and applying it to another. In other meaningful words, copy the text formatting such as any combination of bold, italic, underline, text colour, text size, etc. and apply it to another text to make it as the same as the copied one. […]

Read More »

Paste Options in Microsoft Word (Advanced) 2021’s Master

Paste Options in Microsoft Word (Advanced): The Paste Option is your choice to paste the contents (with or without objects) of the clipboard in several formattings (after cutting or pasting) such as a Keep Source Formatting, Merge Formatting, Picture Formatting, and Keep Text Only. To paste the contents of the clipboard, select one of the […]

Read More »

Paste Options in Microsoft Word (Advanced): The Paste Option is your choice to paste the contents (with or without objects) of the clipboard in several formattings (after cutting or pasting) such as a Keep Source Formatting, Merge Formatting, Picture Formatting, and Keep Text Only. To paste the contents of the clipboard, select one of the options given underneath the “Paste Options”. So let’s discuss below:

Paste Options in Microsoft Office Word
Paste Options in Microsoft Word (Advanced)

Keep Source Formatting (K) - Paste Options in MS Word

in the Paste options, Keep Source Formatting pastes the text without degrading the text formatting as well as the picture after putting it on the clipboard by cutting or copying.

Paste Options in MS Word
Keep Source Formatting in Paste Options

Merge Formatting (M) - Paste Options in MS Word

In the Paste option, Merge Formatting Pastes only the plain text along with original objects as it was before.

Merge Formatting Paste Options in MS-Word
Merge Formatting - Paste Options in MS-Word

Picture Formatting (U) - Paste Options in Microsoft Word

In the Picture option,  pastes the text as a Picture with all the formatting that you have cut.

Picture in Paste Options in MS-Word
Picture in Paste Options in MS-Word

Keep Text Only (T) - Paste Options in MS Word

This option pastes the text (Plain text) along with objects without formatting.

Keep Text Only in Paste Options in MS-Word
Keep Text Only in Paste Options in MS-Word

Steps to follow in using the Paste Options:

  1. Type or keep the text you want
  2. Then go to the Insert tab to insert the objects (Picture or Shapes) 
  3. Click on the Picture and go to the picture location where it was saved in the disk location.
  4. Then select the picture by clicking it, and then click on the Insert or double click on it to Insert into the document
  5. Otherwise, click on the Shapes to insert or draw into the document
  6. Now Select the text and apply the formatting you want
  7. Then cut or copy the items that are selected (the cut or copied items go to the clipboard)
  8. On the Home tab, in the Clipboard Group, click on the Drop-down arrow of the Paste so that you can see the “Paste Options”.
  9. These options are the Keep Source Formatting, Merge Formatting and Keep Text Only.
  10. Now Select one of the options you want to paste the contents of the clipboard with different formatting and with or without objects based on your requirement.

Also, start reading the related topics given below:

FAQ

Most frequent questions and answers

Keep Source Formatting pastes the text without degrading the text formatting as well as the picture after putting it on the clipboard by cutting or copying.

Merge Formatting Pastes only the plain text along with original objects as it was before.

pastes the text as a Picture with all the formatting that you have cut or copied.

pastes the text (Plain text) along with other objects without formatting.