Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selectively printing
Is there a trick to print some word and no others ?
example NAME : excel 2005 LOCATION : united states DATE : 5/22/08 In the above example the capital letters are pre printed in a form to be complete with the lower case letters ( excel 2005,united states,5/22/08). I want to see the capital letter in the worksheet while I work but just print the lower case letters. colors did not work. no macros please. Thanks, appreciate it. -- Socrates said: I only know, I don''''''''t know nothing. I say : I don''''''''t even know, I don''''''''t know nothing. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selectively printing
You could use a helper cell and the LOWER function.
Print the results of that after hiding the original column. Swap hidden columns afrer printing. See help on Custom Views. Gord Dibben MS Excel MVP On Thu, 22 May 2008 18:42:00 -0700, Learning Excel wrote: Is there a trick to print some word and no others ? example NAME : excel 2005 LOCATION : united states DATE : 5/22/08 In the above example the capital letters are pre printed in a form to be complete with the lower case letters ( excel 2005,united states,5/22/08). I want to see the capital letter in the worksheet while I work but just print the lower case letters. colors did not work. no macros please. Thanks, appreciate it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to selectively delete digits in a number? | Excel Worksheet Functions | |||
Selectively Clearing cell contents | Excel Worksheet Functions | |||
How do I selectively import data from another Excel worksheet? | Excel Discussion (Misc queries) | |||
Help w/ selectively combining data | Excel Worksheet Functions | |||
Selectively removing gridlines in excel | Excel Discussion (Misc queries) |