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 ?
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 ?
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
set print area by selecting it
set print area by selecting it but not the header of the data
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks