pages open is wrong positions

  • Thread starter Thread starter rwfster
  • Start date Start date
R

rwfster

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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to determine row of page break on modified presentation sheet? 2
Why does row one always appear at the top when page down 1
Arggh! Each row prints on separate page 2
how can i print (row) titles on all pages except the last page? 3
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Excel Fit to page print options in Excel 1
how do I print multiple print areas on one page 1
Page break dosen't break 4

Back
Top