Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I print a LIST of cell contents?
Hello:
I need help to print a list of cell contents (somehow similar to what Quattro does). Thanks in advance. Yayo. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I print a LIST of cell contents?
Do you mean menu FilePrint'Print what'Selection
-- If this post helps click Yes --------------- Jacob Skaria "Yayo" wrote: Hello: I need help to print a list of cell contents (somehow similar to what Quattro does). Thanks in advance. Yayo. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I print a LIST of cell contents?
No. Sorry.
I do not know if you are familiar with Quattro at all, but in Quattro you go to: File\Page setup: bring the "Options" tab on. Under "Print Options" check "Cell formulas". Then click on "Print", and then on "Print Preview" and you will see a list with ONLY the cells containing any alpha or numerical information. Please copy, paste and click on the following link for a more detailed example: http://books.google.ca/books?id=-vqv...esult&resnum=1 I need to do a similar printout in Excel but it appears that once again Excel is a little bit short in functional options when compared to Quattro. Please let me know if you need further explanation as I would greatly appreciate any help to achieve this type of printout option. Thanks in advance once again. Yayo. "Jacob Skaria" wrote: Do you mean menu FilePrint'Print what'Selection -- If this post helps click Yes --------------- Jacob Skaria "Yayo" wrote: Hello: I need help to print a list of cell contents (somehow similar to what Quattro does). Thanks in advance. Yayo. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I print a LIST of cell contents?
F5SpecialConstantsOK.
FormatCellsFontWhite. Now print. Gord Dibben MS Excel MVP On Tue, 16 Jun 2009 05:51:01 -0700, Yayo wrote: No. Sorry. I do not know if you are familiar with Quattro at all, but in Quattro you go to: File\Page setup: bring the "Options" tab on. Under "Print Options" check "Cell formulas". Then click on "Print", and then on "Print Preview" and you will see a list with ONLY the cells containing any alpha or numerical information. Please copy, paste and click on the following link for a more detailed example: http://books.google.ca/books?id=-vqv...esult&resnum=1 I need to do a similar printout in Excel but it appears that once again Excel is a little bit short in functional options when compared to Quattro. Please let me know if you need further explanation as I would greatly appreciate any help to achieve this type of printout option. Thanks in advance once again. Yayo. "Jacob Skaria" wrote: Do you mean menu FilePrint'Print what'Selection -- If this post helps click Yes --------------- Jacob Skaria "Yayo" wrote: Hello: I need help to print a list of cell contents (somehow similar to what Quattro does). Thanks in advance. Yayo. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I print only cell contents of a Excel 2007 spreadsheet? | Excel Discussion (Misc queries) | |||
how do I print the contents of a cell that is over the max limit? | Excel Discussion (Misc queries) | |||
print cell contents | Excel Discussion (Misc queries) | |||
print comments using cell contents, not cell# | Excel Discussion (Misc queries) | |||
Check cell contents before print | Setting up and Configuration of Excel |