How to Make Excel Data Horizontal. When you start fresh in Microsoft Excel, you have two options to enter data – horizontal and vertical. But after entering vertical or columnar data, it can ...

Click the fill handle and drag it down until you cover the desired rage of cells in the column, and then release the mouse button. Excel copies the value in the first cell to the other cells.

Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.