Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Working with Lists (Now Tables) in Excel 2007
I have a spreadsheet that is dominated by lists. I have sheets where there
are lists beside lists beside lists. ANd I loved the "add a new row" feature in 2003. I'm not that thrilled about having to put my cursor in the LAST column of my "table" and hitting TAB to add a new row - but I suppose I can live with it. OK My real dilemma is - I have formulas EVERYWHERE that refer to the entire contents of my list/table. And in 2003, whenever I added a new row, those formulas updated to include that new row. Apparently in 2007, they don't. HELP! I can't spend my life updating formulas just because I added a new row. Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 lists | Excel Discussion (Misc queries) | |||
Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
Excel 2007 - Tables now (lists in 2003) | Excel Discussion (Misc queries) | |||
Where are Data Forms for lists (tables) in Excel 2007? | Excel Discussion (Misc queries) | |||
Working with Lists in Excel 2003 | Excel Worksheet Functions |