microsoft office training excess - data table

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft office training excess - Data Table

microsoft office training excess - Data Table

resolvedResolved · Low Priority · Version Standard

Zoe has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

Data Table

Why, when creating a Data Table, do the column input cells actually refer to rows and the row input cells actually refer to columns?

RE: Data Table

Hi Zoe

The column in put cell refers to the column of information in the data table. The data is stored in a column of rows.

The logic is a bit a backward, and that is just the way it is programmed in excel.

Regards

Richard


 

Excel tip:

Display Functions on Worksheets

Functions in Excel can be difficult to recall their format/syntax

For example, you want to use the =PMT function.

Enter =PMT, then select keystroke, CTRL+SHIFT+A.

This usful memory jog, will display the arguments of a function on a worksheet, allowing the user to proceed with the generation of the function



View all Excel hints and tips


Server loaded in 0.09 secs.