+ Reply to Thread
Results 1 to 5 of 5

notes

  1. #1
    ADK
    Guest

    notes

    I would like to place instructions on how to enter data into the sheet,
    placing the instruction notes off to the side ...but do not want to have
    these notes printable.

    Is this possible? any other suggestions?

    I am using Microsoft Excel 2000

    Thanks



  2. #2
    Dave Peterson
    Guest

    Re: notes

    Maybe you could add a textbox (either from the control toolbox toolbar or from
    the Drawing toolbar). Then right click and choose "format object" or "format
    text box".

    There's a property tab where you can specify to print or not to print.

    Or maybe you could just define your printrange
    file|print area|set print area

    and exclude those cells with the notes.

    ADK wrote:
    >
    > I would like to place instructions on how to enter data into the sheet,
    > placing the instruction notes off to the side ...but do not want to have
    > these notes printable.
    >
    > Is this possible? any other suggestions?
    >
    > I am using Microsoft Excel 2000
    >
    > Thanks


    --

    Dave Peterson

  3. #3
    Zack Barresse
    Guest

    Re: notes

    Maybe you should think about Data (menu) | Validation. It has an Input
    (tab) that will allow you to specify the text, so that when the cell is
    selected, a small window will pop up with your specified text in it
    (generally used as directions or helpful tips) and they are not printable.

    Also, you can use cell comments and make them not printable, but the mouse
    cursor must be positioned over the cell for it to pop up (if set that way);
    you can set it to be there all the time, but (imho) it can get bothersome
    and in the way.

    HTH

    --
    Regards,
    Zack Barresse, aka firefytr, (GT = TFS FF Zack)


    "ADK" <[email protected]> wrote in message
    news:[email protected]...
    >I would like to place instructions on how to enter data into the sheet,
    > placing the instruction notes off to the side ...but do not want to have
    > these notes printable.
    >
    > Is this possible? any other suggestions?
    >
    > I am using Microsoft Excel 2000
    >
    > Thanks
    >
    >




  4. #4
    ADK
    Guest

    Re: notes

    thanks

    "Zack Barresse" <[email protected]> wrote in message
    news:[email protected]...
    > Maybe you should think about Data (menu) | Validation. It has an Input
    > (tab) that will allow you to specify the text, so that when the cell is
    > selected, a small window will pop up with your specified text in it
    > (generally used as directions or helpful tips) and they are not printable.
    >
    > Also, you can use cell comments and make them not printable, but the mouse
    > cursor must be positioned over the cell for it to pop up (if set that
    > way);
    > you can set it to be there all the time, but (imho) it can get bothersome
    > and in the way.
    >
    > HTH
    >
    > --
    > Regards,
    > Zack Barresse, aka firefytr, (GT = TFS FF Zack)
    >
    >
    > "ADK" <[email protected]> wrote in message
    > news:[email protected]...
    >>I would like to place instructions on how to enter data into the sheet,
    >> placing the instruction notes off to the side ...but do not want to have
    >> these notes printable.
    >>
    >> Is this possible? any other suggestions?
    >>
    >> I am using Microsoft Excel 2000
    >>
    >> Thanks
    >>
    >>

    >
    >




  5. #5
    ADK
    Guest

    Re: notes

    thanks

    "Dave Peterson" <[email protected]> wrote in message
    news:[email protected]...
    > Maybe you could add a textbox (either from the control toolbox toolbar or
    > from
    > the Drawing toolbar). Then right click and choose "format object" or
    > "format
    > text box".
    >
    > There's a property tab where you can specify to print or not to print.
    >
    > Or maybe you could just define your printrange
    > file|print area|set print area
    >
    > and exclude those cells with the notes.
    >
    > ADK wrote:
    >>
    >> I would like to place instructions on how to enter data into the sheet,
    >> placing the instruction notes off to the side ...but do not want to have
    >> these notes printable.
    >>
    >> Is this possible? any other suggestions?
    >>
    >> I am using Microsoft Excel 2000
    >>
    >> Thanks

    >
    > --
    >
    > Dave Peterson




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1