98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » advanced.excel - List/Financials
advanced.excel - List/Financials
Resolved · 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 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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Editing a formula quicklyIf 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 |