+ Reply to Thread
Results 1 to 4 of 4

Print cell in worksheet that you like

  1. #1
    Registered User
    Join Date
    03-11-2011
    Location
    Pakistan
    MS-Off Ver
    Excel 2003
    Posts
    1

    Print cell in worksheet that you like

    How can i print those cell containing values that i like because i am using preprinted paper where cell cell header already prited only data that i have put wanted to print ?

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Print cell in worksheet that you like

    Hello,

    use a different sheet for printing. Use references to the cells you want to print from the other sheet in the positions that you need them.

    =Sheet1!A1

    will show the contents of cell A1 in Sheet1. Set up the separate sheet to match your pre-printed paper.

    cheers

  3. #3
    Registered User
    Join Date
    11-03-2010
    Location
    aurad (B),Bidar Division
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Print cell in worksheet that you like

    set print area by selecting it

  4. #4
    Registered User
    Join Date
    11-03-2010
    Location
    aurad (B),Bidar Division
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Print cell in worksheet that you like

    set print area by selecting it but not the header of the data

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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