+ Reply to Thread
Results 1 to 3 of 3

Can't add Column and row in excel

  1. #1
    Valued Forum Contributor mohan.r1980's Avatar
    Join Date
    09-18-2010
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2010 (windows7)
    Posts
    729

    Can't add Column and row in excel

    Hello Friend,

    i am trying to add a column but my excel not adding it
    i also make clear all non blank cells.

    but i get error msg like: "can't shift object off sheet"

    Please suggest.
    Attached Files Attached Files
    Last edited by mohan.r1980; 04-26-2016 at 05:53 AM.

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Can't add Column and row in excel

    Highlight any unused columns to the right of your data and any unused rows below your data.
    Then save the workbook and try again.

    BSB

  3. #3
    Valued Forum Contributor mohan.r1980's Avatar
    Join Date
    09-18-2010
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2010 (windows7)
    Posts
    729

    Re: Can't add Column and row in excel

    thanks reply

    it solved by another way
    i just tick All in "for object show" in "Excel option"

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel copy images from Column B to column C and give them name of column A
    By sofianeuk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-02-2015, 07:41 PM
  2. Replies: 3
    Last Post: 08-02-2013, 02:16 PM
  3. Removing data of one excel column from another excel column
    By MarkVisser1981 in forum Excel General
    Replies: 2
    Last Post: 06-19-2013, 06:01 PM
  4. Replies: 2
    Last Post: 03-01-2013, 02:01 AM
  5. Replies: 4
    Last Post: 08-01-2012, 08:55 AM
  6. Coding multiple text in Excel column, return value to adjacent column
    By Tania123 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-06-2012, 12:31 PM
  7. Replies: 2
    Last Post: 02-28-2006, 12:15 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1