Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pages open is wrong positions
I use a large excel 2003 spreadsheet that has 6 worksheets. Sometimes the
pages open on different rows, i.e.: page 1 opens on row 4, page 2 opens on row 16, page 3 opens on row 97 etc. It is imperative that data is inputted in the same row across all worksheets. Is there any way to sync all worksheets to the same row so that all pages would open to the same row? Thanks in advance for the help. -- rwfster |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
pages open is wrong positions
they open to wherever they were the last time it was saved, you may want a
small macro to "home" everything when the sheet is opened. "rwfster" wrote: I use a large excel 2003 spreadsheet that has 6 worksheets. Sometimes the pages open on different rows, i.e.: page 1 opens on row 4, page 2 opens on row 16, page 3 opens on row 97 etc. It is imperative that data is inputted in the same row across all worksheets. Is there any way to sync all worksheets to the same row so that all pages would open to the same row? Thanks in advance for the help. -- rwfster |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
autoshapes on chart print in wrong positions | Charts and Charting in Excel | |||
Multiple pages open when I open Excel | New Users to Excel | |||
Excel 2003 multilevel subtotals in wrong positions | Excel Worksheet Functions | |||
total and subtotal positions wrong in excel | Excel Discussion (Misc queries) | |||
Password box to remain open after wrong input | Excel Discussion (Misc queries) |