Celframe Knowledgebase
Search:     Advanced search
Browse by category:
Contact Us

Printing a selected Sheet in Spreadsheet

Add comment
Views: 243
Votes: 0
Comments: 0
Posted: 08 Apr, 2009
by: Sysadmin C.
Updated: 08 Apr, 2009
by: Sysadmin C.

1. First open your document in spreadsheet and go to the tab above that says “VIEW” which is along “FILE-EDIT” and so, like the image below.

 

 

2. Click on “PAGE BREAK PREVIEW” which you will find under the “VIEW” tab.
Now y
ou will see the automatic distribution of the sheet as well as page numbers and print ranges. The automatically created print ranges are indicated by dark blue lines, and the user-defined ones by light blue lines. The page breaks (line breaks and column breaks) are marked as black lines.

Move the print range lines as per your requirement and remember the specific page number(s) that you want to print.
 

 

 

3.  If the print ranges are correct or if your done adjusting it, proceed and click “PRINT” under the “FILE” tab.




4.
Now on these prompt screen which you can see after clicking the “PRINT” button, click on the OPTIONS button which is on the bottom left of the prompt screen.




5.
Now in the OPTION menu tick/ click on “Print Only Selected Sheets” under Sheets as the below image shows and proceed to click the “OK” button.




6.
Now we are back on the previous screen, and here we click/tick on the “PAGES” button below Print Range, inserting the page number of the specific page we want to Print. (Eg; 2 ) as for Page Number 2 and click the “OK” button to proceed with printing and your done.

*You may know your specific page number by clicking on PAGE BREAK PREVIEW under the VIEW tab.
*You may select multiple selected pages to print for instance page 13 to page 20 by inserting (eg;13-20) in the   empty box next to PAGES in the Print Screen.
*As an addition just ensure that your printer status is READY.

Others in this Category
document How do I open a tab-delimited file in Celframe Office 2008 Spreadsheet? What if I have a different type of delimiter?
document I see '###' in a cell that formerly held data. How can I see my data again?
document How do I wrap text within a cell in my spreadsheet?
document How I do select a row (or rows) in my spreadsheet to repeat on every page when printed?
document I don't want a capitalized letter at the beginning of a phrase in Spreadsheet. What should I do?
document How do I freeze/split the first rows and the first columns so that they remain visible when I scroll through my spreadsheet?
document How do I print my spreadsheet correctly?
document How do I make a wide title cell extend across several columns in my spreadsheet?
document How do I rotate a column title so that it fits above my very narrow column?
document How do I create a chart in a spreadsheet that is automatically updated when the data is changed?
document How do I protect cells in my spreadsheet?
document How do I output my spreadsheet data as an ASCII, delimited text file?
document Some of the rows in my spreadsheet are hidden. How do I see all the rows?
document How do I format cells in Celframe Office 2008 Spreadsheet so that the rows number automatically?
document What do each of the error codes (Err:NNN) in Celframe Office 2008 spreadsheets mean?
document How can I use cells from different Spreadsheet files?
document How I change the order of sheets in my spreadsheet?
document How can I rename a sheet?
document How is a variable date inserted into a spreadsheet cell?
document How are thick lines or borders created around my cells?
document How do I insert a page number in the form of 'Page 1 of N' on each page of a spreadsheet?
document A large Celframe Office 2008 spreadsheet was converted from another application. Some of my rows are missing! What happened?
document What is the maximum number of cells in an Celframe Office 2008 Spreadsheet?
document How do I insert superscript or subscript text in my spreadsheet?
document Is it possible to open an Excel file that is protected by a password in Celframe Office 2008?
document How can I use decimal signs (dots) instead of commas to display rational figures?
document I want to select two cells that are not adjacent, but holding down the CTRL key does not seem to work. How can I perform this action?
document How can I create my own sort lists?
document Is there any way to merge a text file with separated fields (*.txt, *.csv) into a Calc file?
document How can I wrap text within a cell?
document If a cell is centre-justified, and the text is wider than the cell, it automatically left-justifies. Can I fix this?
document How do I use styles and formatting?
document Can I use a spreadsheet file with more than 32,000 rows?
document My formula from an Excel worksheet doesn't work!
document Why does Spreadsheet refuse to open my text file?
document How do I add trailing characters to a cell?
document How are notes within cells displayed?
document Why does deleting filtered rows remove other rows too?
document Why does Spreadsheet print out all the sheets in the file?
document How can I print some, but not all, of the cells on a sheet?
document How do I get Sheet1 to print as portrait and Sheet2 to print as landscape?
document How can I use conditional formatting?
document What is the fastest way to copy a calculation to all rows?
document Where can I find definitions for the error codes?
document Why do I see the formula text and not the result of the formula?
document Is there a way to add times that total greater than 24hrs?
document Celframe Office 2008 Spreadsheet Automatisms.
document How do I extend the range of data shown in my chart after I add new data to my spreadsheet?
document I have a MSOffice PowerPoint 97 .PPZ file produced using the 'Pack and Go' SaveAs feature. Can this file be opened in Presentation?
document Can we import data from accounting or other software to Celframe spreadsheet?
document What is the meaning of the error codes in Celframe Spreadsheet 2008?



RSS