1. Copy a range of cells in a column.
2. Select a blank cell.
3. Select Home -> Paste -> Transpose.
Or
Right click -> Paste Special -> Transpose -> OK.
The list is now presented horizontally.
1. Copy a range of cells in a column.
2. Select a blank cell.
3. Select Home -> Paste -> Transpose.
Or
Right click -> Paste Special -> Transpose -> OK.
The list is now presented horizontally.
wHAT IF THE COLUMN IS CONTAINING FORMULA
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks