Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Extending a work sheet
I have a worksheet that I use at my office. I find that I will run out of
room to add information. How may I extend the worksheet to add more rows and still keep the formulas that I use? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Extending a work sheet
Hi Jeff,
Until the arrival of the next incarnation of Excel, the number of rows is immutably fixed at 65536. --- Regards, Norman "Jeff Kirkhart" wrote in message ... I have a worksheet that I use at my office. I find that I will run out of room to add information. How may I extend the worksheet to add more rows and still keep the formulas that I use? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Extending a work sheet
That helps some, but I am only using about 30 rows. How do I add more and
still keep the same size and formulas? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Extending a work sheet
Hi Jeff.
Best if you use range names in your formulas if you want your data table to be dynamic, the way you have described. For instance, say you have 2 columns of data for Name(cell A1) and Bags Sold(cell B1) and you have a formula(Sum) in cell B30 adding up all the Bag Sold to give a grand total. The formula =Sum(B2:B29) would be okay till as you have mentioned, you get to sell b29, and run out of space. Solution: Highlight the range of cells(B2:B29) that you're starting with, and then give the range a descriptive name - e.g "grandtotalbagsales" using the "Insert-Name-Define" command (on the main menu) or do it quicker by typing the descriptive name for the range into the "name box" to the left of the formula bar. Next, use simply replace the formula for the grand total in cell B30 with =sum(grandtotalbagsales). Once you've done the above, all you need to do subsequently is place your cursor on the last row of your named range and use the insert command to add any number of rows you want to include(you must ensure you insert rows while your cursor is in one of the rows within the named range for this to work). You should be able to do this and still keep the formulas that you use(i.e you'll have no need to modify them every time you add rows). I think you'll find the tips on Pierre Le Clerc's website on this subject also helpful - http://www.excel-vba-access.com Hope this helps + sorry it's a bit long-winded :-). -- Tayo Solagbade helps individuals and businesses leverage Microsoft Excel for their data management and decision making so they can get more done with less effort, in less time, and at less cost. "Jeff Kirkhart" wrote: That helps some, but I am only using about 30 rows. How do I add more and still keep the same size and formulas? |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Extending a work sheet
Could it be that you are operating in "Page break preview"......if so, do
View Normal..........or perhaps all the rows beyond 30 have been hidden? Vaya con Dios, Chuck, CABGx3 "Jeff Kirkhart" wrote: That helps some, but I am only using about 30 rows. How do I add more and still keep the same size and formulas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
BLANK WORK ORDERS OR DAILY ACTIVITY SHEET TEMPLATES | Excel Discussion (Misc queries) | |||
help with seting up a work sheet | Excel Discussion (Misc queries) | |||
Populating work sheet combox with another work sheet values | Excel Discussion (Misc queries) | |||
In Excel, how do you make one whole sheet equal to another. | Excel Discussion (Misc queries) | |||
Spin button in a work sheet - how do I make it work? | Excel Worksheet Functions |