How can I insert rows BELOW, in Excel

How can I insert a row BELOW the currently selected row? In Excel 2003, after selecting a row, I could go to the Table menu and click insert rows below. Now the only option seems to be on the Home ribbon, cells group, insert button then insert ...

Message posted on the April 12th, 2010 - 6:24 PM ET

Add rows to table

This is a template - I want to be able to add rows to a table (7 colums). Below is example of table: Each <> is a form field The Net1 is a formula of GAmt1 - (GAmt1 * Rate1) By clicking the macroButton field <insert row above> a new row ...

Message posted on the January 17th, 2010 - 09:59 am ET

macro to delete rows below the first row with duplicate data

I am looking for a macro to delete rows of data that are below the row I want to keep. I have a table that pulls in scan codes from specific work order #'s. The problem I have is that I only need to have the last scan that was entered for that work ...

Message posted on the October 15th, 2009 - 12:16 pm ET

adding rows below a table

I recently updated to the Microsoft 2007 program and I am having a problem adding to rows to an existing table. Joe

Message posted on the February 24th, 2009 - 11:52 am ET

inserting table data from a Word document into an Access table

The Word 2003/2007 document(some files are in "docx" or Word 2007 and some are in "doc" Word 2003 format) has data as indicated below: ..some text on line 1 which is not needed.. ..some text on line 2 which is not needed.. ...

Message posted on the May 29th, 2010 - 09:51 pm ET

inserting table data from a Word document into an Access table

The Word 2003/2007 document(some files are in "docx" or Word 2007 and some are in "doc" Word 2003 format) has data as indicated below: ..some text on line 1 which is not needed.. ..some text on line 2 which is not needed.. ...

Message posted on the May 29th, 2010 - 09:51 pm ET

End of table

I have several workbooks that were created by someone else. They all have one characteristic that I would like to change. When I create a worksheet, the Ctrl-End key combination jumps to the bottom of the table -- the lower right cell. If my table ...

Message posted on the September 23rd, 2010 - 01:08 pm ET

Making a 2 columned, 4 row table in a single cell for multiple row

I am using Excel 2007. I have 5 columns as illustrated below - (Table Description has no rows yet) CTwt. Size Metal Jewelers cost Table Description 5 10 Tungsten 31 4 10.5 Tungsten 35 2 11 Tungsten 50 10 11.5 Tungsten 20 8 12 Tungsten 15 ...

Message posted on the December 10th, 2009 - 10:03 am ET

Creating a table within a table

I am using Excel 2007. I have 5 columns as illustrated below - (Table Description has no rows yet) CTwt. Size Metal Jewelers cost Table Description 5 10 Tungsten 31 4 10.5 Tungsten 35 2 11 Tungsten 50 10 11.5 Tungsten 20 8 12 Tungsten 15 ...

Message posted on the December 10th, 2009 - 10:02 am ET

Update Numbers in a Table Automatically

We have a two column table that is constantly being updated and modified, new rows are added in the middle or at the end of the table. The left column always has a numbered entry: Ref1, Ref2 Ref3, etc. The right column has descriptive data. If I ...

Message posted on the February 17th, 2010 - 02:08 pm ET

Making a table and automating it throughout cells

I am using Access 2007 and Excel 2007. I have 5 columns in a spreadsheet as illustrated below - (Table Description has no rows yet) CTwt. Size Metal Jewelers cost Table Description 5 10 Tungsten 31 4 10.5 Tungsten 35 2 11 Tungsten 50 ...

Message posted on the December 09th, 2009 - 04:15 pm ET

Delete rows with date more than 48 hours with a condition..

In the below table I want to delete rows with dates more that 48 hours in column K if column J="ABC" Column J|Column K ABC 29-01-09 ABC 30-01-09 ABC 30-01-09 MNO 31-01-09 MNO 31-01-09 ABC 03-02-09 MNO 03-02-09 MNO 31-01-09 MNO 01-02-09 ...

Message posted on the February 03rd, 2009 - 09:08 pm ET

transpose multiple rows into one column

Dear all, How to transpose the below table into one column (actually 2 columns) with name? my table: Name col1 col2 col3 col4 A 10 20 30 40 B 50 60 C 70 80 90 transpose ...

Message posted on the October 23rd, 2009 - 03:52 pm ET

Dynamically Naming a Table of Data

Probably a stupid question. I can dynamically name a columular data range using the Insert>Name>Define =OFFSET(Sheet!$A$1,0,0,COUNTA(Sheet!$A:$A) function. This allows me to add data to a list and the named range automatically takes the new ...

Message posted on the August 28th, 2009 - 12:38 am ET

		Advanced search
In

rows below table