Paste Special – English Page

Spread the love

Table Creation and Formatting –  The use of data entry to maintain the records and formatting is required to show the table in organized form. It is required by any organization that maintain the database properly and readable for analysis and reporting purpose as well as helps in business growth. The data helps to take proper decision for business growth.

 

Copy and Paste a data is a very initial job and crucial also, below are the some paste options which help to distribute the data and share on multiple locations by doing paste command.

Copy and PASTE SPECIAL OPTIONS – Shortcut key ( Alt+E+S+V)

  • All – It pastes same as original properties of cell.
  • Formulas – Only formulas will be applied on cells.
  • Values – only Convert formulas into values
  • Formats – It pastes only formatting of cells not values (color,fond, border etc.).
  • Comments – Only comments will be pasted on cells.
  • Validations – Only validation and inside referenced values will be pasted.
  • All except borders – same as All except borders formatting
  • Formulas and numbers format – Formulas and number formatting will be applied on cells ($,RS,Etc.)
  • Values and numbers format – convert formulas to value as well formatting of numbers will be pasted

 

Multiple method to use mathematical operations during paste command on cells.

Operations

  • None – No operation
  • Add – Add the copied values on existing cells
    •  EXAMPLE – if copied value is 5 and existing value of cell is 10, and paste on same cell which has already a value is 10 , so it will be added up and result will show 15.
  • Subtract – Subtract the copied values on existing cells
    • EXAMPLE – if copied value is 5 and existing value of cell is 10, and paste on same cell which has already a value is 10 , so it will be added up and result will show 5.
  • Multiply – Multiply the copied values on existing cells
    • EXAMPLE – if copied value is 5 and existing value of cell is 10, and paste on same cell which has already a value is 10 , so it will be added up and result will show 50.
  • Divide – Divide the copied values on existing cells
    •  EXAMPLE – if copied value is 5 and existing value of cell is 10, and paste on same cell which has already a value is 10 , so it will be added up and result will show 2.

 

Data Linking and Modify

  • Transpose  – ( horizontal to vertical ,  vertical to horizontal)
  • Paste Link – set an link to cell

 

Data Entry Examples

  • Use “Enter” to one row down selection
  • Use “Tab” to go to next column
  • Use Shortcut key “F2” to edit cell

Cells Formatting Steps –

  1.  Select cells
  2.  Type in Cells – Name , Class , Marks, Subjects , Year , Semester
  3.  Align cells in center
  4.  Set font to bold
  5.  Fill the colors in cells

ExcelinHindi.com - 1Table Desing Formatting

  • Select the borders for cells
  • It makes easy to read cells separately

ExcelinHindi.com - 2Table Desing Formatting

Copy and Paste Special Example – 

  1.  Select cells to copy
  2.  right click then copy option will be appeared

ExcelinHindi.com - 1.Copy

 

 

 

 

 

 

 

 

 

 

  •  Select a single cell to paste copied values

ExcelinHindi.com - 3.Paste

  •  Paste – Copied formula cells will be pasted as values
  •  Repeat once again the paste operation , but this time need to select “Formats” option instead of value.

ExcelinHindi.com - 2.Paste

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Paste – Format से cells की FORMATTING paste हो जाएगी

  •  Paste – Structured of copied range/cells will be pasted on cells.

ExcelinHindi.com - 4.Paste