Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workbook Design
Data Lists are my primary use for Excel. I tend to import the data on
a Worksheet into columns A and B, for example. Skip a column for easy use of the Go To function. Then, columns D and E are for calculations. Is this common and why? Do some folks dedicate a single worksheet for just data and then put calculations on a separate worksheet? What would be the benefit? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workbook Design
One reason for putting "calculations" and other support data on another
sheet, is to keep it out of user's sight, and keep it from being corrupted by the insertion of complete rows through the range of the support material. hth Vaya con Dios, Chuck, CABGx3 wrote in message ups.com... Data Lists are my primary use for Excel. I tend to import the data on a Worksheet into columns A and B, for example. Skip a column for easy use of the Go To function. Then, columns D and E are for calculations. Is this common and why? Do some folks dedicate a single worksheet for just data and then put calculations on a separate worksheet? What would be the benefit? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to merge monthly workbooks into a quarterly workbook?? | Excel Worksheet Functions | |||
Reference & update destin. cells on 1st machine from source workbook on 2nd machine. | Excel Discussion (Misc queries) | |||
excel exits unexpectedly or hangs the second time I open workbook | Excel Discussion (Misc queries) | |||
Repost:Automatically inserting a row in external workbook | Excel Discussion (Misc queries) | |||
How to hyperlink from a workbook to sheets in another workbook? | Excel Worksheet Functions |