Warning: Illegal string offset 'link' in [path]/includes/class_bbcode.php on line 2777

Warning: Illegal string offset 'link' in [path]/includes/class_bbcode.php on line 2791

Warning: Illegal string offset 'link' in [path]/includes/class_bbcode.php on line 2777

Warning: Illegal string offset 'link' in [path]/includes/class_bbcode.php on line 2791
MS Excel 2007 Lecture # 10
  • The Facebook Platform

Results 1 to 1 of 1
  1. #1
    Join Date
    Jan 2010
    Location
    Lahore, Pakistan
    Age
    25
    Posts
    3,818
    Points
    6,772.51
    Rep Power
    10000

    Default MS Excel 2007 Lecture # 10

    "Discover the Excel 2007 Paste Special Secrets!"

    To use the Paste Special dialog box
    • Select the range of data you wish to copy.
    • On the Home tab, in the Clipboard group, click Copy icon.
      OR press Ctrl+C.
    • Click the cell where you want to paste the range.
    • On the Home tab, in the Clipboard group, click the down arrow of the Paste icon and click the Paste Special option.
    • From the Paste Special dialog box displayed, select the necessary option from the Paste section:

    Name:  excel-2007-paste-special.jpg
Views: 186
Size:  29.2 KB
    Each option is explain as follow:
    Name:  excel-2007-paste-special-option.jpg
Views: 184
Size:  74.2 KB

    • In the Operation section, select the available suitable option.
    • For example, if you select the Add option, Excel adds the corresponding values in the source range and the destination range and replaces the destination range with the new values.
    • The Skip Blanks option prevents Excel from overwriting cell contents in your paste area with blank cells from the copied range. It is useful if you're copying a range to another area but don't want the blank cells in the copied range to overwrite existing data.
    • The Transpose option can change the orientation of the pasted entries. For example, if the original cells' entries run down the rows of a single column of the worksheet, the transposed pasted entries will run across the columns of a single row (see steps below).


    To use the Transpose option







    • Select the range of data you wish to copy and transpose.
    • On the Home tab, in the Clipboard group, click Copy icon.
      OR press Ctrl+C.
    • Click the cell where you want to place the range.
    • On the Home tab, in the Clipboard group, click the down arrow of the Paste icon and click Transpose.


    Find Me On Social Networks

    Facebook | Twitter | Google+



 

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

     

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •