Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - printing specific areas
Hi, my name's Gabriella.
I've been working with Microsoft Excel to build a customer database. Each column is something else - address, city, zip code, phone number, job done, date the job was completed and name. I didn't put any formulas in, nor did I mess with anything that I don't know about within Excel - namely everything. This is where my question comes in. Say I want to print a list of people who've had jobs done in a specific city, or in a specific year. Is there a way to print that without having to go through the whole file and picking them out with ctrl+click? Is there some kind of formula, etc.? I know close to nothing about Excel's special features, so any help would be greatly appreciated. Thanks! :) -Gabriella |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - printing specific areas
Gabriella
You should be able to do that using Auto-Filter. Select the top left cell of your data table then Data|Filter|Autofilter A set of down arrows should appear. Click the one on the column for (say) City and select your city and the data will be filtered to only show that city and if you print all you will get is what you see on the screen. You can add additional filters to other columns to make you report more specific. Mike "Gabriella" wrote: Hi, my name's Gabriella. I've been working with Microsoft Excel to build a customer database. Each column is something else - address, city, zip code, phone number, job done, date the job was completed and name. I didn't put any formulas in, nor did I mess with anything that I don't know about within Excel - namely everything. This is where my question comes in. Say I want to print a list of people who've had jobs done in a specific city, or in a specific year. Is there a way to print that without having to go through the whole file and picking them out with ctrl+click? Is there some kind of formula, etc.? I know close to nothing about Excel's special features, so any help would be greatly appreciated. Thanks! :) -Gabriella |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - printing specific areas
DataFilterAutofilter wilkl give you this function.
Filter for what you want to see then print the visible cells. Gord Dibben MS Excel MVP On Thu, 24 Jul 2008 01:45:02 -0700, Gabriella wrote: Hi, my name's Gabriella. I've been working with Microsoft Excel to build a customer database. Each column is something else - address, city, zip code, phone number, job done, date the job was completed and name. I didn't put any formulas in, nor did I mess with anything that I don't know about within Excel - namely everything. This is where my question comes in. Say I want to print a list of people who've had jobs done in a specific city, or in a specific year. Is there a way to print that without having to go through the whole file and picking them out with ctrl+click? Is there some kind of formula, etc.? I know close to nothing about Excel's special features, so any help would be greatly appreciated. Thanks! :) -Gabriella |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing named areas in Excel 2003 | Excel Discussion (Misc queries) | |||
Merge Excel data into specific form areas in a Word Doc | Excel Discussion (Misc queries) | |||
Defining specific areas for users to enter data | Excel Discussion (Misc queries) | |||
Printing multiple areas on the 1 page | Excel Discussion (Misc queries) | |||
printing from different areas | Excel Worksheet Functions |