Formatting CSV file

  • Thread starter Thread starter Debbie
  • Start date Start date
D

Debbie

I have a large spreadsheet that I run from a query in
Access and transfer to Excel. This spreadsheet is then
saved as a CSV file and run thru a program that was
designed to break the large spreadsheet into smaller
spreadsheets by distributor. Is there any way to format
this CSV file for Excel viewing where the user can print
page 15 of say 50 pages? Some of these smaller reports
might be 200 pages or so and we don't want to print out
the entire report if the information is located on page
15. Maybe we should be looking closer at an Access
application rather than Excel. Any feedback would be
greatly appreciated. Thank you in advance for your help.
 
CSV files are plain text--so there's not any formatting you can apply that will
stick.

But maybe you could teach the users to apply data|filter|autofilter. Then
filter by the values they want and then print those visible rows.

Or even have them select their range and do:
file|Print
At the bottom right, there's an option for what to print.
They can choose Selection.
 
Back
Top