insert rows


    Sponsored Links


  • 1. Applescript-running script on saving an Excel file
    Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Hello, I am trying to have a script run automatically each time the Excel file is saved. The script will duplicate the file to another folder. I have the script working as a drag n' drop applescript application, but I would like to take a step further. Thanks for any help. oyster
  • 2. Saving
    Some excel documents I was using with 2004 Office for Mac cannot be saved with the new 2008 Office unless I change the name.<br> <br> I think this might be related to the fact that the spreadsheet is linked by name to another spreadsheet.<br> <br> If I change the name I can save excel document but now it won be linked any longer to another spreadsheet.<br> <br> Is there a solution to this problem.
  • 3. Using data source in Excel for mail merge in word
    Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel How do I select individual recipients from a data source in Excel when doing a mail merge using mail merge manager in Word if I don't want to use all of them? (When using Microsoft on PC you can select individual recipients within a file but I can't seem to do this on Mac Office). Please help. Gilly
  • 4. how to change currency
    Version: 2008 Operating System: Mac OS X 10.5 (Leopard) When i installed my excel i put spanish and now when i put the currency sign it puts it at the end of the number (like in spain) and not in mexico where i live or the US how can i change it to Us currency without having to format the page or the cells every time?
  • 5. Creating timelines
    Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I have created a list of dates and events in Excel. I would like to import them into a timeline. Can I do this in Excel? Or is there another software system out there that I should be using. I am not looking for a Gantt chart, but a timeline - you know, like the kind you see in National Geographic or something.

Insert rows

Postby gadaad » Mon, 13 Dec 2004 05:05:34 GMT

I just installed Excel 2004. I put the insert rows icon into the toobar
however it stays "greyed out". What am i doing wrong. How can I get it
to work?

Re: Insert rows

Postby JE McGimpsey » Mon, 13 Dec 2004 05:55:10 GMT

In article < XXXX@XXXXX.COM >,

Take a look here:


insert rows

Postby michaelsarna » Sat, 20 Dec 2008 13:32:47 GMT

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

Excel for mac will won't let me insert row. I keep getting a message "Cannot shift objects off sheet" The page I am using are budgets that I have been using for years and worked till I installed the newest Excel for mac 2008.

Re: insert rows

Postby CyberTaz » Sat, 20 Dec 2008 20:52:35 GMT

The most likely cause is that there is content near the bottom edge of the
sheet - or at least something is causing Excel to "think" there is.

Try selecting the first empty row below your data, key
Shift+Command+DownArrow to select all rows to the bottom of the sheet, then
go to Edit> Clear> All. If that doesn't correct it let us know.

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

On 12/18/08 11:32 PM, in article  XXXX@XXXXX.COM ,

Re: insert rows

Postby libwiz » Sun, 11 Jan 2009 04:57:52 GMT

Any other suggestions? This does not work for me. I've tried both
Clear All and Delete after highlighting unused cells. I still cannot
insert a row or column.

On Dec 19 2008, 3:52m, {*filter*}Taz < XXXX@XXXXX.COM >

Re: insert rows

Postby CyberTaz » Sun, 11 Jan 2009 09:46:12 GMT

Well, if you're sure the sheet isn't protected & there is no content in the
cells "empty" cells it's possible that there is some sort of object *on* the
sheet... Such as an image, drawing object, text box, chart, etc. If you'd
prefer to not take the time to locate the offender the easiest solution is
to copy the active content of the sheet & paste to a new sheet.

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

On 1/9/09 2:57 PM, in article

Similar Threads:

1.Insert rows and keep merged cells in the inserted row

I have a simple spreadsheet with 15 columns and appr. 30 rows.

At Column D + E  I have merged cells horisontally in almost every row - 
except af few ones.
When I want to insert a new row(with merged cells), then it's inserted but 
not merged.
I mark the row on the rownumber, rightclick the mouse and do "insert".

Can I do something, so the merged cells in the marked row will be copied 
into the inserted row?

2.Insert Row based on count and copy range to inserted rows

I am working with the following code that is working fine, I just need some 
help to make an adjustment to it as I can't figure it out. At the time of 
'Names copied down to the inserted rows' I would like it to copy the values 
from the range iRow "A" to iRow "W" to the inserted row instead of just iRow 
"A" as it is now.

Thanks for your help.

Sub InsertRowsBasedOnCount()
    Dim wks As Worksheet
    Dim iRow As Long
    Dim HowManyRows As Variant
    Dim FirstRow As Long
    Dim LastRow As Long
    Set wks = Worksheets("Data resolution category")
    With wks
        FirstRow = 1
        LastRow = .Cells(.Rows.Count, "X").End(xlUp).Row
        For iRow = LastRow To FirstRow Step -1
            HowManyRows = .Cells(iRow, "X").Value
            If IsNumeric(HowManyRows) Then
                'some minor testing
                If HowManyRows > 1 _
                 And HowManyRows < 100 Then
                    .Rows(iRow + 1).Resize(HowManyRows - 1).Insert
                    'Names copied down to the inserted rows
                    .Cells(iRow + 1, "A").Resize(HowManyRows - 1).Value _
                        = .Cells(iRow, "A").Value
                End If
            End If
        Next iRow
    End With
End Sub

3.Insert Buttons on Toolbar for Insert Row and Insert Column grayed out

Has something changed that I missed?  I can no longer select an entire row 
or column, and then click the Insert button on the toolbar.  These buttons 
are grayed out.

4.Insert values in one newly Inserted row in an existing EXCEL sheet

I need to do the following simple task:

  open an existing excel file "ExFileExcel"
  open an existing sheet "ExSheet" contained in the previous one
  Insert 1 new row as second (2th) row of the above sheet
  write "Hello" on all the cells of that new row
  And (later) delete the new row.

Thanks a lot for any help.


5.Insert row in Master worksheet that auto inserts in other workshee

I've created a Master worksheet tab in a workbook.  This workbook was created 
to show the weekly itineraries (M-F) of everyone in our department.  This is 
a large group of people and there if often movement, with people moving into 
and out of the department frequently.  Consequently, the names change often.  
The Master tab lists the names of everyone in the department.  All the other 
tabs are on a weekly basis, with the names of the employees linked to the 
Master tab.  The idea was that when a name changed in the dept., to make the 
change on the master tab and it would automatically update each of the weekly 
tabs.  This works if I'm typing over a name in the master, but I can't get it 
to work if I insert a row in the master tab to add a name.  The row isn't 
inserted on the other tabs.  Can you tell me how to insert a row on the 
master tab that carries over to all the other tabs?  Thanks for any 
help/advice you can give me!

6. Insert row in Master worksheet that auto inserts in other work

7. Macro insert data, need to insert rows

8. insert row / insert column command buttons

Return to MS EXCEL


Who is online

Users browsing this forum: No registered users and 80 guest