Re: a p.s.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I don't do well with Excel, you cannot drag and drop, but you can cut and paste...

--
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com
"Mary Sauer" <gsauer@xxxxxxxxxxxxxxxxx> wrote in message
news:ODSKOCEnFHA.3544@xxxxxxxxxxxxxxxxxxxxxxx
> In Excel, create a new field, high-light records 9-17, drag them over to field b,
> create new field, 18-26, drag them over to field 3, and so on.
>
> Setup your page like this:
> Click custom,
> width 8.14
> height 1.25
> Click change copies per page
> Side margin .18
> Top margin . 54
> OK out.
> In the Publication page, arrange, margins zero, Grid guides 2 columns, 0.1 spacing.
> Open the merge wizard, place a text box on the first label, merge field one, a new
> text box on the second label, merge field 2
> Insert a new page and merge c & d and so on.
>
> I know this is not really clear, but it works...
>
>
>
> --
> Mary Sauer MSFT MVP
> http://office.microsoft.com/
> http://msauer.mvps.org/
> news://msnews.microsoft.com
> "Kelly Crom" <KellyCrom@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:C5DEB462-DAE3-409F-8B37-1021A69BD8E9@xxxxxxxxxxxxxxxx
>> You're correct, it's not an issue with a basic sort. I don't even know if the
>> type of sort I would need is even possible with excel, unless there is a way
>> to sort by record number, then using some sort of formula to sort out every 8
>> records, so that when I cut down my stacks, position 1 would be record #1, 9,
>> 17, and so on.
>> --
>> Kelly Crom
>>
>>
>> "www.serif.com" wrote:
>>
>>> Read the original post and UNDERSTAND what the question was
>>>
>>> Any fool can do a basic sort in Excel - however, to do what the original question
>>> asked, is another issue!!!
>
>


.

Relevant Pages

  • Re: Sorting Data Inside of Cell
    ... If your data starts in A1, enter this in an adjacent column, and drag down ... New to Excel, but have a problem that I need to resolve. ... the number in the cell might read 275510. ... need to sort the data into 3 groups, 27,55,10. ...
    (microsoft.public.excel)
  • Re: Unsorting
    ... Insert a new column, on the first row place a 1, then ... drag the fill handle down so the row 2 in the column gets a 2 ... would defeat the purpose of being able to sort things back ... David McRitchie, Microsoft MVP - Excel ...
    (microsoft.public.excel.misc)
  • Re: How to change the column order in Excel table with multiple sort
    ... But you could drag and drop the columns where you want them after you sort. ... I have an Excel table, have sorted it on 4 levels. ... I'd like the column order to mirror the sorting ...
    (microsoft.public.excel.misc)
  • Re: will publisher alpabeticalize your address list
    ... I think the sort started with 2002. ... not outside data such as Access or Excel. ... Mary Sauer MSFT MVP ...
    (microsoft.public.publisher)
  • Re: excel 2002
    ... Use a helper column that formats that date nicer: ... drag down and sort your range by that column. ... > Contact list in excel 2002, how do I sort birthday column by month then day. ...
    (microsoft.public.excel.worksheet.functions)