• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

updating multiple cells in Excel at the same time - question?

QueBert

QueBert

Lifer
So I Googled this and see CRTL+ENTER thing. Here's what I want to do, I have one with 2 sheets, and I'd like to link everything in a column in the 1st to a column on the 2nd sheet. So, if I edit B1 in sheet1 B1 in sheet2 gets updated. These are text only there's no formula in there. I'm assuming this is do-able with a formula, but I'm clueless and my Googling isn't turning up anything.
 
Sheet1 cell B1 contains "stuff"

Formula for Sheet2 cell B1 is =Sheet1!B1

Sheet2 cell B1 will show whatever is in Sheet1 B1. To create the formula in Excel you can either type it in the cell or type an equals sign <=> in the destination cell (Sheet2 B1 in this case) and then click on cell B1 in Sheet1 and hit <enter>.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top