microsoft+excel+course - Auto Functions

Resolved · Low Priority · Version Standard

Tue 20 Nov 2007, 16:43 Delegate Manfred said...

Manfred has attended:
Excel Intermediate course
Excel Advanced course
Outlook Advanced course
Excel VBA Intro Intermediate course

Auto Functions

How do you retrieve the information displayed at the bottom of the Excel frame?

Wed 21 Nov 2007, 16:12 Trainer Carlos said...

RE: Auto Functions

Hi Manfred

The short answer is NO.

If you require the system to record the calculated total of any range selected you would need to:

Create a macro, attached to a button that is clicked when required

It would then store the result in a preassigned place eg Variable

Regards

Carlos

Excel tip:

Importing Numbers in Excel 2010

Occasionally, when importing data into Excel you find that the some of the imported values are treated as text.

To convert these numbers to actual values, click on an empty cell and press Ctrl+C.

Next, select the range that contains the values you need to change and in the Clipboard Group on the Home tab, click the Paste drop-down arrow and choose Paste Special. In the Paste Special dialog box, select Add and then click OK.

View all Excel hints and tips

microsoft+excel+course - Auto Functions

Auto Functions

RE: Auto Functions

Excel articles

Excel tip:

Importing Numbers in Excel 2010