AVSIG: Help with Excel wwswsigarch.jpg (7236 bytes)

✈ . . . . . . ✈ . . . . . ✈ . . . . ✈ . . . ✈ . . ✈ . ✈ . . ✈ . . . ✈ . . . . ✈ . . . . . ✈ . . . . . . Touch-and-Go to our Live Forum (This is a Read-only Archive of the 2004-2017 AVSIG Forum)


AVSIG Discussion Sections >> Hardware/Software

Pages: 1 | 2 | 3 | >> (show all)
Ward Miller POU-NY
Top Gun


Reged: 05/05/04
Posts: 10508
Loc: New York
Help with Excel
      #418958 - 12/09/15 05:29 PM

I have an Excel 2010 name & address file, with a special code in one column.
I want to print the file, selecting (filtering) just the names with an "X" in
the special code column.

I did a google on "Printing Filtered List in Microsoft Excel 2010" and got a
great file with that title. But it lacks specificity. As I start to do what
it says, I don't get the expected results almost from step 1. For example,
after just a few specified clicks it says a list will drop down. It doesn't.

Can someone help me with DETAILED instructions?


Post Extras: Print Post   Remind Me!   Notify Moderator  
sreyoB yrraL
AVSIG Member


Reged: 05/16/04
Posts: 9442
Re: Help with Excel [Re: Ward Miller POU-NY]
      #418961 - 12/09/15 06:32 PM

Sort by the column with the "X", set the print area, and print?

Post Extras: Print Post   Remind Me!   Notify Moderator  
Ward Miller POU-NY
Top Gun


Reged: 05/05/04
Posts: 10508
Loc: New York
Help with Excel [Re: sreyoB yrraL]
      #418966 - 12/09/15 09:15 PM

I'll try that. Years ago I used the Filter to do it, but nothing I try now
seems to get anywhere.

Strange, using the example for the proper version of Excel doesn't work for
me.

I've had some bad luck recently. It seems to be continuing. <sigh>


Post Extras: Print Post   Remind Me!   Notify Moderator  
Mase Taylor
Top Gun


Reged: 04/29/04
Posts: 9446
Loc: SOCAL
Re: Help with Excel [Re: Ward Miller POU-NY]
      #418967 - 12/09/15 09:25 PM

What Yrral said.

I've done this dozens of times, but using Excel 2002.

--------------------
Fly The Airplane As Far Into The Crash As Possible. - Bob Hoover 1922-2016 R.I.P.


Post Extras: Print Post   Remind Me!   Notify Moderator  
sreyoB yrraL
AVSIG Member


Reged: 05/16/04
Posts: 9442
Re: Help with Excel [Re: Ward Miller POU-NY]
      #418981 - 12/10/15 09:00 AM

I've never used the filter function.

There may be better ways to do it but a quick sort is the only way that comes immediately to mind. Excel has so many features that there's usually multiple ways to get something done.


Post Extras: Print Post   Remind Me!   Notify Moderator  
Ward Miller POU-NY
Top Gun


Reged: 05/05/04
Posts: 10508
Loc: New York
Help with Excel [Re: sreyoB yrraL]
      #418988 - 12/10/15 10:31 AM

Larry, if there is an easy way and a hard way to do something, Microsoft
seems to always choose the hard way. For this same name & address file I
must print labels. That involves creating a special file with Excel, then
using Word and Mail-Merge to format and print the labels.

The MS Help instructions are something like 9 pages long and contain several
serious errors in the procedures. After struggling with it for several
months I finally made a detailed procedure, customized for my particular
situation, and with check-off boxes for each step. Now I can do the job
each month in 5 or 10 minutes, instead of an hour filled with errors and
back tracking.

PC-FILE and dBase would print labels with just a few clicks.


Post Extras: Print Post   Remind Me!   Notify Moderator  
Mase Taylor
Top Gun


Reged: 04/29/04
Posts: 9446
Loc: SOCAL
Re: Help with Excel [Re: Ward Miller POU-NY]
      #418991 - 12/10/15 11:10 AM

I finally gave up trying to print labels from Excel and created a separate WORD file to print them, using one of the built-in templates for the size labels I was using. Of course, this meant having to update two files when there was any change in names or addresses.

I did use mail merge when I had to send the same missive to 200 different folks on the list.

--------------------
Fly The Airplane As Far Into The Crash As Possible. - Bob Hoover 1922-2016 R.I.P.


Post Extras: Print Post   Remind Me!   Notify Moderator  
Terry Carraway
Top Gun


Reged: 06/02/04
Posts: 7098
Loc: Maryland
Re: Help with Excel [Re: Ward Miller POU-NY]
      #418993 - 12/10/15 11:18 AM

Quote:

Larry, if there is an easy way and a hard way to do something, Microsoft
seems to always choose the hard way. For this same name & address file I
must print labels. That involves creating a special file with Excel, then
using Word and Mail-Merge to format and print the labels.

The MS Help instructions are something like 9 pages long and contain several
serious errors in the procedures. After struggling with it for several
months I finally made a detailed procedure, customized for my particular
situation, and with check-off boxes for each step. Now I can do the job
each month in 5 or 10 minutes, instead of an hour filled with errors and
back tracking.

PC-FILE and dBase would print labels with just a few clicks.




Because you are comparing a spread sheet to databases.

Spreadsheets do some things well. But they are NOT databases.

PC-FILE and dBase are databases and do what databases do. And keeping names and addresses and doing labels is DATABASE work.

Yes, you can do such things in Excel, but that is not what it is designed to do well. Spreadsheets do complex calculations well, databases do not.

--------------------
Terry
Mostly 0W3


Post Extras: Print Post   Remind Me!   Notify Moderator  
sreyoB yrraL
AVSIG Member


Reged: 05/16/04
Posts: 9442
Re: Help with Excel [Re: Terry Carraway]
      #418997 - 12/10/15 12:35 PM

Yeah, I agree with Terry.

Maintaining an addresses database and printing mailing labels is not what Excel is designed to do. It'll do it, but it won't be an elegant solution. I use Outlook for my contacts and it does a much better job.

The advantage a spreadsheet has is flexibility. Excel can do almost anything you need. None of the solutions in Excel will be as elegant as an application designed specifically for your purpose. Should be lots of inexpensive options available for contacts and label printing.


Post Extras: Print Post   Remind Me!   Notify Moderator  
Ward Miller POU-NY
Top Gun


Reged: 05/05/04
Posts: 10508
Loc: New York
Help with Excel [Re: Terry Carraway]
      #419016 - 12/10/15 05:34 PM

>> Spreadsheets do some things well. But they are NOT databases. <<

So several years ago I bought MS Access and a manual for it. Ugh! The
absolute worse application I've ever attempted to use. The user interface
is awful. Finally gave up. It wasn't worth the pain.


Post Extras: Print Post   Remind Me!   Notify Moderator  
Pages: 1 | 2 | 3 | >> (show all)



Extra information
0 registered and 10 anonymous users are browsing this forum.

Moderator:  Mike Overly 

Print Topic

Forum Permissions
      You cannot start new topics
      You cannot reply to topics
      HTML is disabled
      UBBCode is enabled

Rating:
Topic views: 5220

Rate this topic

Jump to

Contact Us AVSIG

Powered by UBB.threads™ 6.5.5

Logout   Main Index    AVSIG Aviation Forum