Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel sums

ResolvedVersion 2002/XP

Jessica has attended:
Upgrade to Office 2007 course

Excel Sums

How do I add a total bar numerous times within one Excel document

RE: Excel Sums

Hi Jessica

Thanks for the post

the best way to do this is create the first formula - then go the the bottom righthand corner of the cell where the formula is and then (you should see a little black cross) then click and drag to the other cells beside that one this should copy the same formula to the other cell

If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn

Fri 30 Jan 2009: Automatically marked as resolved.

 

Training courses

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Microsoft Office tip:

Draw a perfect square or circle

Click on the Rectangle or Oval button on the Drawing toolbar. (If necessary, click Customize on the Tools menu, and then click the Drawing check box on the Toolbars to display the toolbar.)
Press and hold down both the [SHIFT] key and the mouse button.
Drag the mouse pointer diagonally downward and to the right until the rectangle or circle drawn has your preferred measurements.
Release the mouse button.
Release the [SHIFT] key.
In short, simply hold down the SHIFT key while dragging the mouse pointer!

View all Microsoft Office hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.