Using Excel 2007
I have a spreadsheet that has a list of ~ 300 customers that I want to keep in alphabetical order.
Currently the list is split up into 3 columns on 2 pages with A-M on page one and N-Z on page two. The problem with this is that, when I have to add a new customer, I have to shift everything around. Is there a way to have all the customers in column A so it's easier to add a new customer and then be able to sort and then have it print on 2 pages and 3 columns? Not sure the best way to do this.
Your help is GREATLY appreciated.
Karen