Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
new user makes alot of mistakes
I build a spreadsheet for radio schedules, I make mistakes when I enter
revisions. Its hard to make a template for these schedules as the number columns and number of rows varies from month to month. So if I change the position of one thing or delete several groups of numbers, I forget to change them in other places. My guess is to build a template every month, but other than that, what can I do to stop making mistakes! thanks |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
new user makes alot of mistakes
Perhaps you should not worry so much with the month to month changes in
number of rows/columns. Design a "worst case" scenario template and use it each month. Then instead of deleting unused rows/columns and messing up formulas and results, HIDE them! Without knowing what kind of mistakes you're making, it's hard to make other recommendations. The use of named ranges (see Excel Help - search for the phrase 'Define named cell references or ranges' for a beginning point) could help you. Don't use absolute references (=$A$15) unless you have to, use relative addressing (=A15) so that when rows/columns are inserted/deleted, the address updates in dependent formulas. If bad goes to worse, set up a document that details the types of changes you usually make and what you have to alter to keep the workbook working properly. Then read and follow your own instructions on making alterations each month. "rachie1127" wrote: I build a spreadsheet for radio schedules, I make mistakes when I enter revisions. Its hard to make a template for these schedules as the number columns and number of rows varies from month to month. So if I change the position of one thing or delete several groups of numbers, I forget to change them in other places. My guess is to build a template every month, but other than that, what can I do to stop making mistakes! thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy and pasting on columns but on spreadsheet with alot of data | Excel Discussion (Misc queries) | |||
moving alot of data (10000 cells) from a column to a row | Excel Discussion (Misc queries) | |||
Alot of chart in vb | Charts and Charting in Excel | |||
I have alot of text in a cell, I just want to see the top line | Excel Worksheet Functions | |||
mistakes in the Excel functions (help on line french version at le | Excel Worksheet Functions |