Need info to show on multiple sheets

A

AlienBeans

I have a spreadsheet that is 14 pages. I'm looking for a quick way to
enter info into a cell and have the same info appear in a particular
cell on the other 13 pages without having to type the info 14
times....any help would be appreciated. thanks... even copy and paste
takes forever as I can't find a way to select cells on multiple sheets
and paste it ONCE to all sheets. If there is a way to do that, that
would be ok as well.
 
R

robo

What you need to do is "Group Sheets"

Right Click on one of your Sheet Tabs and choose Select All Sheets.

You can also do this by using your SHIFT or CTRL and selected just the
sheets you want.

After selecting sheets anything you type in one sheet will apply to all.

Good Luck.
 
C

Carim

Hi,

If I understand correctly in each of the 13 other sheets :

1. Type =
2. Click on the "original" sheet tab
3. Click on the "original" cell
4. Hit Enter key

HTH
Cheers

Carim
 
Top