advanced.excel - listfinancials

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » advanced.excel - List/Financials

advanced.excel - List/Financials

resolvedResolved · Low Priority · Version Standard

Anthony has attended:
Excel Intermediate course
Excel Advanced course

List/Financials

How do I print off only certain rows of data and the headings from a large list of data?

RE: List/Financials

Hi Anthony

Thanks for your question.

If it is only rows that match certain criteria that you want to print, then you can use an AutoFilter to display just the data that meets your criteria.

To do this, click within your list, then go to Data - Filter - AutoFilter. Dropdown arrows will display beside your column headings from which you can select the criteria you are looking for within certain column/s.

I hope this helps.
Amanda

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Editing a formula quickly

If you want to edit a fomrula or text quickly witin a cell instead of the formula bar, you can click either double click in the cell or press the F2 key

View all Excel hints and tips


Server loaded in 0.08 secs.