View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Spiky Spiky is offline
external usenet poster
 
Posts: 622
Default spreadsheet colum combination

On Jul 7, 11:00 am, Old Bob wrote:
Thanks, I wanted to now make 4 columns but keep all the A's, B's ect together.
--
Old Bob

"sajay" wrote:
You mean with the same two columns split into 4 or want to add another two
details column?
Sort is simply the best option you can use Automatic Filter option from Data
Menu.


and if you plan to take prints
go to nearly the half of the excel sheet
cut it from there and paste next to data in top


"Old Bob" wrote in message
...
I have an alphabetical list of songs in two colums-one for title and one
for
artist. My list now is way too long (400 pages). Is there an easy way to
make this list in 4 colums and still keep it alphabetical?
--
Old Bob

How many songs do you add in a week? You could switch to Word. It
allows for multiple print columns, like a newspaper. And can still
Sort.