move cursor on one sheet moves cursor on all sheets

G

Guest

I have created a budget spreadsheet with a sheet for each month and a sheet
for yearly totals. When I move the cursor from budget catagory to brdget
catagory I would like the cursor to change on all sheets simultaneously so
that when I move from sheet to sheet I will be at the same place.
 
G

Guest

Hold down SHIFT and click on the first sheet tab and then the Last sheet tab.
All sheets are now selected and cursor movements synconised

Peter A
 
G

Guest

Thanks, Billy--

That is better, but the selected cell my not be on the screen on the
subsequent sheet so I still have to move the screen to see the selected cell.
I was hoping that there was a function like "Freeze Panes" that would move
all sheets in sync with the other so as I flipped from sheet to sheet I would
see the same cells visible on each screen. Thanks for getting me this far.

Tom Worden
 

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

Top