| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to print selected rows of database
In the goto box click on the special button in the bottom left corner.
I tried F5 as noted but it takes me to the Go To page. I don't see anything to click on for visible cells only? Bob "Jaleel" wrote: After selecting and before copying the data, press F5 - special - visible cells only - OK. Then copy and paste. Try this "BobG" wrote: I have a large database that I have sorted and selected out data that meets certain criteria and want to print the culled out set. The database has page breaks included which remain in the culled set but aren't wanted and cause the printing to print a few records and then hit a page break causing the print out to be many pages longer than what is viewed on the screen. How can I print just the view on the screen without the embedded page breaks without deleting the page breaks from the data set as they have functionality when the whole data set is viewed? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Want to print only rows that have value in certain columns- Excel | Excel Discussion (Misc queries) | |||
| resetting last cell | Excel Discussion (Misc queries) | |||
| Why does AutoFilter display rows NOT selected from drop down box? | Excel Discussion (Misc queries) | |||
| Pick certain rows from database to use statistical functions on th | Excel Worksheet Functions | |||
| make first few rows print on every page? | New Users to Excel | |||
Threaded Mode
