Welcome to Soft32 Forums!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

inserting columns and rows

 
   Soft32 Home -> Mac -> Excel RSS
Next:  Time Capsule power supply early death  
Author Message
bluedom

External


Since: Oct 18, 2009
Posts: 2



(Msg. 1) Posted: Sun Oct 18, 2009 9:42 am
Post subject: inserting columns and rows
Archived from groups: microsoft>public>mac>office>excel (more info?)

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

When I try to insert a new column or row I receive an error message saying that it is "impossible to place objects outside of the sheet". (This is roughly translated as I have MS Office 2008 French student/family version. Is this a limitation of the student/family version or am I doing something wrong. I followed the step by step instructions from this site on how to insert/delete rows and columns but with no luck. Thanks.

bluedom
Back to top
Login to vote
CyberTaz

External


Since: Jul 28, 2007
Posts: 2895



(Msg. 2) Posted: Sun Oct 18, 2009 2:59 pm
Post subject: Re: inserting columns and rows [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

There is no difference between Home/Student & any other edition. The message
means exactly what it says Smile Regardless of whether you realize it & even
if you can't see it, there is content of some type occupying space at the
right edge and/or bottom edge of the sheet.

Just to clarify, those commands do not *add* any rows or columns, It removes
them from the corresponding edge & sticks them where you're asking for them
to be. It can't do that if there is any content at the edge ‹ either in
cells or objects floating on the surface.

One of the most common causes is pasting content copied from other files ‹
particularly web pages ‹ where you really have no idea what all is actually
being copied. Junk can get flung all over the place.

Either clear those areas or copy just the actual content of the sheet &
paste to a new sheet. If the problem persists include OS X & Office update
levels along with as much additional detail as you can supply.

HTH |:>)
Bob Jones
[MVP] Office:Mac



On 10/18/09 12:42 PM, in article 59b7ed9f.-1.RemoveThis@webcrossing.caR9absDaxw,
"bluedom@officeformac.com" <bluedom.RemoveThis@officeformac.com> wrote:

> Version: 2008
> Operating System: Mac OS X 10.5 (Leopard)
> Processor: Intel
>
> When I try to insert a new column or row I receive an error message saying
> that it is "impossible to place objects outside of the sheet". (This is
> roughly translated as I have MS Office 2008 French student/family version. Is
> this a limitation of the student/family version or am I doing something wrong.
> I followed the step by step instructions from this site on how to
> insert/delete rows and columns but with no luck. Thanks.
>
> bluedom
Back to top
Login to vote
bluedom

External


Since: Oct 18, 2009
Posts: 2



(Msg. 3) Posted: Mon Oct 19, 2009 6:09 am
Post subject: Re: inserting columns and rows [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Thank you CyberTaz for your quick and helpful response. In fact, the Excel sheet that is (was) causing me problems was downloaded from First Class where my professor had posted the Excel sheet for the students to fill in according to the class requirements - so there me be content on the sheet that I am not aware of.

Bluedom
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Moving Rows to Columns - I've got a project were I've been given a list of contacts in an Excel file however instead of having columns for First...

Numbers of columns and rows - How do I specify the numbers of columns and rows that I want in a spreadsheet? Eg - I want a sheet with only one....

Numbers of columns and rows - How do I specify the numbers of columns and rows that I want in a spreadsheet? Eg - I want a sheet with only one....

how to delete rows and columns not used - When I scroll down, or hit END, I want the sheet to stop at the last row and when I scroll to the right, to stop at the...

Setting Rows & Columns - Is there some way to set, or limit, the number of columns and rows that I want for a spreadsheet. Thanks, Doug

Changing rows to columns - Does anyone know, how I could arrange data in cells from horizontal to vertical? I do not need to change the direction....
       Soft32 Home -> Mac -> Excel All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum

Categories:
 Windows
 Linux
  Mac
 PDA


[ Contact us | Terms of Service/Privacy Policy ]