Once i faced some issue. these happen because of comments updated in previous excel sheer from where data was copied..
i also not able hide columns. Select worksheet and remove comments (excel 2007 steps) Removing Comments from All Cells 1. Open the sheet with the comments to be deleted 2. From the *Ribbon*, select the *Home* command tab 3. In the *Editing* group, click *FIND & SELECT*» select *Comments* All comments on the active sheet will be selected. 4. From the *Editing* group, click *CLEAR*» select *Clear Comments* All comments are cleared. Regards Chethan Kumar BN On Fri, Oct 7, 2011 at 12:47 AM, Dilip Pandey <dilipan...@gmail.com> wrote: > Just an additional check. > Verify if there are some objects lying at the boarder of the > worksheet. See the attachment for better understanding. > > Feel free to get back in case of any queries. > > Regards, > DILIPandey > > On 10/6/11, Sam Mathai Chacko <samde...@gmail.com> wrote: > > I wasn't able to see the picture earlier. Strange! Anyway, Anil, apart > from > > the reasons mentioned by MS, this also occurs when the used range of your > > sheet covers the entire sheet area, and if you insert a row or column, > Excel > > blocks the action assuming that there might be some row or column that > could > > get pushed out of the sheet (which it stops from happening by giving an > > error) > > > > HTH > > > > Sam > > > > On Thu, Oct 6, 2011 at 1:25 PM, Mahesh parab <mahes...@gmail.com> wrote: > > > >> Hi Anil > >> > >> check whether this helps > >> http://support.microsoft.com/kb/211769/en-us > >> > >> > >> > >> HTH > >> Mahesh > >> > >> > >> On Thu, Oct 6, 2011 at 1:20 PM, Sam Mathai Chacko > >> <samde...@gmail.com>wrote: > >> > >>> What error? > >>> > >>> > >>> > >>> On Thu, Oct 6, 2011 at 1:16 PM, Anil Bhange < > >>> anil.bha...@tatacommunications.com> wrote: > >>> > >>>> Hi Expert,**** > >>>> > >>>> ** ** > >>>> > >>>> Could you please let me know why below error is coming while hiding > some > >>>> of the columns**** > >>>> > >>>> ** ** > >>>> > >>>> **** > >>>> > >>>> ** ** > >>>> > >>>> ** ** > >>>> > >>>> *Anil Bhange* > >>>> > >>>> *Assistant Manager* > >>>> Financial Reporting & Compliance,**** > >>>> > >>>> TATA Communications Ltd. > >>>> VSB, Fort, Mumbai – 400 001, > >>>> India**** > >>>> > >>>> ** ** > >>>> > >>>> ' Desk : + 91 22 6659 2320 > >>>> | IP Phone : 51 2320 | Mobile :+ 91 90290 32123 **** > >>>> > >>>> anil.bha...@tatacommunications.com**** > >>>> > >>>> ** ** > >>>> > >>>> ** ** > >>>> > >>>> -- > >>>> > >>>> > ---------------------------------------------------------------------------------- > >>>> Some important links for excel users: > >>>> 1. Follow us on TWITTER for tips tricks and links : > >>>> http://twitter.com/exceldailytip > >>>> 2. Join our LinkedIN group @ > http://www.linkedin.com/groups?gid=1871310 > >>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com > >>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com > >>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > >>>> > >>>> To post to this group, send email to excel-macros@googlegroups.com > >>>> > >>>> <><><><><><><><><><><><><><><><><><><><><><> > >>>> Like our page on facebook , Just follow below link > >>>> http://www.facebook.com/discussexcel > >>>> > >>> > >>> > >>> > >>> -- > >>> Sam Mathai Chacko > >>> > >>> -- > >>> > >>> > ---------------------------------------------------------------------------------- > >>> Some important links for excel users: > >>> 1. Follow us on TWITTER for tips tricks and links : > >>> http://twitter.com/exceldailytip > >>> 2. Join our LinkedIN group @ > http://www.linkedin.com/groups?gid=1871310 > >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com > >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com > >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > >>> > >>> To post to this group, send email to excel-macros@googlegroups.com > >>> > >>> <><><><><><><><><><><><><><><><><><><><><><> > >>> Like our page on facebook , Just follow below link > >>> http://www.facebook.com/discussexcel > >>> > >> > >> -- > >> > >> > ---------------------------------------------------------------------------------- > >> Some important links for excel users: > >> 1. Follow us on TWITTER for tips tricks and links : > >> http://twitter.com/exceldailytip > >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > >> 3. Excel tutorials at http://www.excel-macros.blogspot.com > >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com > >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > >> > >> To post to this group, send email to excel-macros@googlegroups.com > >> > >> <><><><><><><><><><><><><><><><><><><><><><> > >> Like our page on facebook , Just follow below link > >> http://www.facebook.com/discussexcel > >> > > > > > > > > -- > > Sam Mathai Chacko > > > > -- > > > ---------------------------------------------------------------------------------- > > Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links : > > http://twitter.com/exceldailytip > > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > > 3. Excel tutorials at http://www.excel-macros.blogspot.com > > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > > To post to this group, send email to excel-macros@googlegroups.com > > > > <><><><><><><><><><><><><><><><><><><><><><> > > Like our page on facebook , Just follow below link > > http://www.facebook.com/discussexcel > > > > > -- > Thanks & Regards, > > DILIP KUMAR PANDEY, mvp > MBA,B.Com(Hons),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 62, India > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- B.N Chetan kumar -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
