| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
exclude from print area
Hi,
I want to print a page but I don't want the cell that has the price in it to print. (But I still want to see it electronically). Anyone know how to exclude a single cell from in the middle of a print area selection? Thanks Kate |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
exclude from print area
Change the font colour to white?
-- Hth Kassie Kasselman "Kate" wrote: Hi, I want to print a page but I don't want the cell that has the price in it to print. (But I still want to see it electronically). Anyone know how to exclude a single cell from in the middle of a print area selection? Thanks Kate |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
exclude from print area
You could move the price cell out of the print area, then copy it, hold down
shift and choose edit menu "paste picture link". Position the picture where you want it, then right-click it and select "format picture": on the Properties tab uncheck the "print picture" checkbox. Tim "Kate" wrote in message oups.com... Hi, I want to print a page but I don't want the cell that has the price in it to print. (But I still want to see it electronically). Anyone know how to exclude a single cell from in the middle of a print area selection? Thanks Kate |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
exclude from print area
Some people report that certain printers still show text with a white font.
It this does not work with your printer(s), post back. NickHK "kassie" (Change xxx to hotmail) wrote in message ... Change the font colour to white? -- Hth Kassie Kasselman "Kate" wrote: Hi, I want to print a page but I don't want the cell that has the price in it to print. (But I still want to see it electronically). Anyone know how to exclude a single cell from in the middle of a print area selection? Thanks Kate |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
exclude from print area
Kate -
You could temporarily use a custom format of three semicolons, i.e., ;;; - Mike http://www.mikemiddleton.com "Kate" wrote in message oups.com... Hi, I want to print a page but I don't want the cell that has the price in it to print. (But I still want to see it electronically). Anyone know how to exclude a single cell from in the middle of a print area selection? Thanks Kate |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| set area in excel not giving me option to set print area? | Excel Discussion (Misc queries) | |||
| File, print area, clear area, is not working | New Users to Excel | |||
| print area across the freeze panes area | Excel Worksheet Functions | |||
| Macro - Set Print Area for Changing Data Area | Excel Programming | |||
| How do you turn off a print area for a page? (no print area) | Excel Discussion (Misc queries) | |||
![Kate[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
