1. You are viewing our forum as a guest. For full access please Register. WindowsBBS.com is completely free, paid for by advertisers and donations.

Delete Row or Column

Discussion in 'Other PC Software' started by dastgir, 2009/02/01.

  1. 2009/02/01
    dastgir

    dastgir Inactive Thread Starter

    Joined:
    2005/12/26
    Messages:
    86
    Likes Received:
    0
    Dear Sir,

    I am using MS Excel 2003.

    Yesterday when i was in market i saw a man working on excel sheet.
    To delete some rows he used a toolbar icon (Shape of the Icon was like
    when we use formula editing toolbar). Since he was busy and i am in hurry i can,t enquire
    him about this toolbar icon. At home i searched my toolbar but didn't find
    any such toolbar support to delete row or column.

    Can any one help here.

    Regards,

    Gulam Dastgir
     
    dastgir,
    #1
  2. 2009/02/01
    PeteC

    PeteC SuperGeek Staff

    Joined:
    2002/05/10
    Messages:
    28,896
    Likes Received:
    389
    Look under ....

    View > Toolbars > Customise - Select category - Edit in the left hand column.

    Scroll down the right hand column to Delete, Delete Rows, Delete Columns.

    Click & drag the icon to the toolbar at the head of the main window.
     
    PeteC,
    #2


  3. to hide this advert.

  4. 2009/02/02
    dastgir

    dastgir Inactive Thread Starter

    Joined:
    2005/12/26
    Messages:
    86
    Likes Received:
    0
    Thanks PeteC for your help.
    Is there any keyboard shortcut to paste special.

    Regards,
    Gulam Dastgir
     
    dastgir,
    #3
  5. 2009/02/02
    PeteC

    PeteC SuperGeek Staff

    Joined:
    2002/05/10
    Messages:
    28,896
    Likes Received:
    389
    Follow the same procedure outlined above ....

    View > Toolbars > Customise - Select category - Edit in the left hand column.

    Scroll down the right hand column to Paste Special.

    Click & drag the icon to the toolbar at the head of the main window.

    You will see that the "S" of Special is underlined - use Alt-C to copy and then Alt-S to Paste Special.

    BTW - a simple Google would have found this for you :) ....

    http://www.google.com/search?source...Set+keyboard+shortcut+for+Paste+Special+Excel
     
    PeteC,
    #4
  6. 2009/02/03
    dastgir

    dastgir Inactive Thread Starter

    Joined:
    2005/12/26
    Messages:
    86
    Likes Received:
    0
    And how to paste merge cells so no change in formating
    takes places.

    Regards,

    Gulam Dastgir
     
    dastgir,
    #5
  7. 2009/02/03
    PeteC

    PeteC SuperGeek Staff

    Joined:
    2002/05/10
    Messages:
    28,896
    Likes Received:
    389
    If I understand correctly that you want to paste a set of merged cells elsewhere then follow these instructions ....

    Highlight the merged cells, right click > Copy

    Highlight the first cell into which you want to paste - right click on it and select Paste Special. In the Paste Special options box which appears select those options you require and click on OK.
     
    PeteC,
    #6
  8. 2009/02/03
    Bilb0

    Bilb0 Inactive

    Joined:
    2007/07/23
    Messages:
    203
    Likes Received:
    6
    On the far right side of the upper menu seletions, there is a drop down called "HELP ".

    I have from time to time found it to be quite helpful.
     
    Bilb0,
    #7
  9. 2009/02/07
    dastgir

    dastgir Inactive Thread Starter

    Joined:
    2005/12/26
    Messages:
    86
    Likes Received:
    0
    Dear PeteC,

    Why it not possible to copy on the merged cells.

    Is it not possible to select options of value and formating simultaniously in paste special menu? If possible then how to do it?

    Regards,

    Gulam Dastgir
     
    dastgir,
    #8
  10. 2009/02/07
    PeteC

    PeteC SuperGeek Staff

    Joined:
    2002/05/10
    Messages:
    28,896
    Likes Received:
    389
    Gulam

    I am in no position to answer your detailed questions on Excel - I use it only on simple, personal spreadsheets.

    The answers I have given you were sourced from a Google search - I suggest you do the same and move on up the learning curve.
     
    PeteC,
    #9
  11. 2009/02/07
    Bilb0

    Bilb0 Inactive

    Joined:
    2007/07/23
    Messages:
    203
    Likes Received:
    6
    YOU CAN COPY MERGED CELLS BUT THE MERGED ATTRIBUTE IS ALSO COPIED.
    When you perform a paste (with merged cells on the clipboard), if you do not want the MERGED attribute to be pasted, you must perform a PASTE SPECIAL, and then you are limited to the options available in the dialog box, or develop custom VBA code to paste special other combinations than are afforded in the dialog box.

    In Excel 2003, in the PASTE SPECIAL dialog box, in the right hand side of options, you have the option to PASTE SPECIAL VALUES AND NUMBER FORMATS.

    If you also need to paste OTHER FORMATS, you'll have perform a second paste special or write custom code in VBA.

    There are several excellent books for learning and training Microsoft Excel avaliable in multiple languages in multiple formats available over the internet or in book stores around the world.
     
    Bilb0,
    #10
  12. 2009/02/15
    dastgir

    dastgir Inactive Thread Starter

    Joined:
    2005/12/26
    Messages:
    86
    Likes Received:
    0
    Dear Bilbo,

    When i go for filling in series eg. from 1 to hundred, the formating of the
    parent cell is also copied. Is this possible that in such cases that only series is filled
    and format is not copied? This option, as i experienced, only possible when
    the parent cell number is copied instead filled in series.

    What are the importance of the various options available in series dialog
    box esp. linear, growth etc.

    Regards,
    Gulam Dastgir
     
    dastgir,
    #11
  13. 2009/02/15
    Bilb0

    Bilb0 Inactive

    Joined:
    2007/07/23
    Messages:
    203
    Likes Received:
    6
    Of which I am aware, it is not possible to fill only values or formulas without also getting the format(s) of the parent cell(s).

    The importance of the options in the Series dialog box are up to the user to decide.
    The functionality of them is easy for you to determine by experimenting.

    As a side note, i am surprized to see you exerting so much effort to get Excel to do something it is not prepared to do.
    Getting around functionality limitations, particularly this limitation is quite simple and would take FAR less time to implement than you have already spent trying to circumvent its built in design.
     
    Bilb0,
    #12
  14. 2009/03/04
    dastgir

    dastgir Inactive Thread Starter

    Joined:
    2005/12/26
    Messages:
    86
    Likes Received:
    0
    Dear Bilb0,

    When we drag a cell from left to right positions of column get changed in the
    formula eg A becomes B and so on. Is excel 2003 has any option that during
    such drag positions of row get changed not that of column eg 1 becomes 2
    and so on.

    Regards,
    Gulam Dastgir
     
    dastgir,
    #13

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...