Excell budget worksheets

F

F_disk

Newb here....needing some help...

I am using 4 work sheets to represent the four weeks in a month.
I want to be able to put say "dog food" in B23 on all four work sheets
and then have that value show up on each sheet and also a running
grand total of it on the main sheet (first one).

I can figure out how to link the worksheets together so that when I enter
on worksheet 2 it shows up in a total column on work sheet one etc.
Thanks !!!!
 
K

Kevin B

Click on the tab for sheet 1, and then, while holding down a shift key, click
on the tab for sheet 4. This will turn Group Mode on, and whatever you type
in one sheet gets typed in all sheets, this includes data, formatting and
formulas. To ungroup, right click on any of the selected tabs and select
ungroup sheets.
 

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