If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Do not print one cell question?
I have my worksheet protected so only certain cells can be selected. I will
send this worksheet to others to collect data and send the information back to me on the same worksheet. In some cases, people will not use the form within Excel and will print the form. When the Excel worksheet is printed I want it to not print one cell. This cell is calucalated automatically within Excel and I don't want people making an attempt at the calculation. Is there a way print the worksheet/form and not print the one cell? Thank you. |
#2
|
|||
|
|||
Do not print one cell question?
Hi,
I'm not sure what you want, but you can select the cell (when its not protected) and choose Format, Cells, Custom on the Number tab and on the Code line enter ;;; (three semi-colons) Cheers, Shane Devenshire Microsoft Excel MVP "LiveUser" wrote in message ... I have my worksheet protected so only certain cells can be selected. I will send this worksheet to others to collect data and send the information back to me on the same worksheet. In some cases, people will not use the form within Excel and will print the form. When the Excel worksheet is printed I want it to not print one cell. This cell is calucalated automatically within Excel and I don't want people making an attempt at the calculation. Is there a way print the worksheet/form and not print the one cell? Thank you. |
#3
|
|||
|
|||
Do not print one cell question?
Shane,
Thank you for responding. What does the three semi-colons accomplish? -LiveUser "Shane Devenshire" wrote: Hi, I'm not sure what you want, but you can select the cell (when its not protected) and choose Format, Cells, Custom on the Number tab and on the Code line enter ;;; (three semi-colons) Cheers, Shane Devenshire Microsoft Excel MVP "LiveUser" wrote in message ... I have my worksheet protected so only certain cells can be selected. I will send this worksheet to others to collect data and send the information back to me on the same worksheet. In some cases, people will not use the form within Excel and will print the form. When the Excel worksheet is printed I want it to not print one cell. This cell is calucalated automatically within Excel and I don't want people making an attempt at the calculation. Is there a way print the worksheet/form and not print the one cell? Thank you. |
#4
|
|||
|
|||
Do not print one cell question?
Try it. You'll notice immediately what it accomplishes.
Gord Dibben MS Excel MVP On Mon, 19 May 2008 03:59:00 -0700, LiveUser wrote: Shane, Thank you for responding. What does the three semi-colons accomplish? -LiveUser "Shane Devenshire" wrote: Hi, I'm not sure what you want, but you can select the cell (when its not protected) and choose Format, Cells, Custom on the Number tab and on the Code line enter ;;; (three semi-colons) Cheers, Shane Devenshire Microsoft Excel MVP "LiveUser" wrote in message ... I have my worksheet protected so only certain cells can be selected. I will send this worksheet to others to collect data and send the information back to me on the same worksheet. In some cases, people will not use the form within Excel and will print the form. When the Excel worksheet is printed I want it to not print one cell. This cell is calucalated automatically within Excel and I don't want people making an attempt at the calculation. Is there a way print the worksheet/form and not print the one cell? Thank you. |
#5
|
|||
|
|||
Do not print one cell question?
And to add to Gord's "try it, you'll like it" bg response...
Number formatting consists of 4 parts: postives;negatives;zero;text Try (again!) this custom format on a test cell: \a;\b;\c;\d Then type in a postive number and hit enter. Then a negative number; then 0; then text. Watch what's displayed in the cell each time you hit enter. And ;;; (means that there's nothing for each of the four pieces to show) LiveUser wrote: Shane, Thank you for responding. What does the three semi-colons accomplish? -LiveUser "Shane Devenshire" wrote: Hi, I'm not sure what you want, but you can select the cell (when its not protected) and choose Format, Cells, Custom on the Number tab and on the Code line enter ;;; (three semi-colons) Cheers, Shane Devenshire Microsoft Excel MVP "LiveUser" wrote in message ... I have my worksheet protected so only certain cells can be selected. I will send this worksheet to others to collect data and send the information back to me on the same worksheet. In some cases, people will not use the form within Excel and will print the form. When the Excel worksheet is printed I want it to not print one cell. This cell is calucalated automatically within Excel and I don't want people making an attempt at the calculation. Is there a way print the worksheet/form and not print the one cell? Thank you. -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|