ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I insert a row at the end of a table. (https://www.excelbanter.com/excel-discussion-misc-queries/111321-how-do-i-insert-row-end-table.html)

Phyllis

How do I insert a row at the end of a table.
 
If I click the last row and use "insert row" function, it will insert the row
before the last row. If I click the first row below the table and use
"insert row" the row will insert below but not in the table. If I just type
in the first row below the table, the row doesn't get added to the table. I
am stumped.
--
PT

JLGWhiz

How do I insert a row at the end of a table.
 
use the help facility and type "Add or delete rows or columns to an Excel
list " in the search box.

"Phyllis" wrote:

If I click the last row and use "insert row" function, it will insert the row
before the last row. If I click the first row below the table and use
"insert row" the row will insert below but not in the table. If I just type
in the first row below the table, the row doesn't get added to the table. I
am stumped.
--
PT


Don Guillett

How do I insert a row at the end of a table.
 
Either set up your table so that when you insert AT the last row you get
what you want (dummy row) or use a defined name that auto adjusts the table.

--
Don Guillett
SalesAid Software

"Phyllis" wrote in message
...
If I click the last row and use "insert row" function, it will insert the
row
before the last row. If I click the first row below the table and use
"insert row" the row will insert below but not in the table. If I just
type
in the first row below the table, the row doesn't get added to the table.
I
am stumped.
--
PT




Phyllis

How do I insert a row at the end of a table.
 
I had forgotten it was called a "list" rather than a "table." Asking help
about inserting a row at the end of a "list" rather than at the end of a
"table" gave me the answer. My bad. Thanks.
--
PT


"Phyllis" wrote:

If I click the last row and use "insert row" function, it will insert the row
before the last row. If I click the first row below the table and use
"insert row" the row will insert below but not in the table. If I just type
in the first row below the table, the row doesn't get added to the table. I
am stumped.
--
PT



All times are GMT +1. The time now is 08:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com