Forum Discussion
AutoSum Question
If I were working on a spreadsheet in Excel, Instead of AutoSuming columns or rows, can I autosum specific cells? Example: If I wanted to subtract D17 from B19 and the total goes into cell D19? Is this possible? I am not familiar with the finer options of spreadsheets, I am trying to learn the quicker ways of creating working spreadsheets. Thanks.
4 Replies
AutoSum doesn't work with individual cells, but you can create the formula yourself:
Select cell D19.
Enter the formula
=B19-D17
HansVogelaar thank you for taking the time to respond to my question. would you happen to know if there is a way I can set this formula up to function across 11 other pages in this workbook? Basically it's a budget workbook I built as a tester but I am wondering if I can apply this formula to one page and have it automatically carryover to the other 11 pages within? Do you think I might be better off doing this formula per page rather than trying to connect 11 other spreadsheet pages in a workbook?
If you want to enter the same formula in multiple sheets, you can do select all the sheets you want to apply it to, then enter the formula.
To select some adjacent sheets:
- Click on the sheet tab of the sheet tab of the first sheet you want to include.
- Hold down Shift while you click on the sheet tab of the last sheet you want to include.
To select individual, non-adjacent sheets:
- Click on the sheet tab of the sheet tab of the first sheet you want to include.
- Hold down Ctrl while you click on the sheet tab of another sheet you want to include.
- Repeat as needed.
Warning: when you are done, do not forget to select a single sheet again, otherwise all your actions will be applied to all selected sheets.
A tell-tale sign that you have selected more than one sheet is [Group] in the title bar of the workbook window.
