ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do i remove page breakup lines in the worksheet ? (https://www.excelbanter.com/excel-discussion-misc-queries/147501-how-do-i-remove-page-breakup-lines-worksheet.html)

manish

how do i remove page breakup lines in the worksheet ?
 
i have done that in " normal view ".. but atill the page breakup limes are
visible in my worksheet ....

Peo Sjoblom

how do i remove page breakup lines in the worksheet ?
 
Close and reopen the workbook

--
Regards,

Peo Sjoblom



"manish" wrote in message
...
i have done that in " normal view ".. but atill the page breakup limes are
visible in my worksheet ....




smeheut

how do i remove page breakup lines in the worksheet ?
 
on the active worksheet click on the tools menu then options and uncheck the
page breaks box. this will remove the lines

"manish" wrote:

i have done that in " normal view ".. but atill the page breakup limes are
visible in my worksheet ....


manish

how do i remove page breakup lines in the worksheet ?
 


"smeheut" wrote:

on the active worksheet click on the tools menu then options and uncheck the
page breaks box. this will remove the lines

"manish" wrote:

i have done that in " normal view ".. but atill the page breakup limes are
visible in my worksheet ....


i am using MICROSOFT OFFICE 2007.. there is no option like that..

manish

how do i remove page breakup lines in the worksheet ?
 


"Peo Sjoblom" wrote:

Close and reopen the workbook

--
Regards,

Peo Sjoblom



thanks

"manish" wrote in message
...
i have done that in " normal view ".. but atill the page breakup limes are
visible in my worksheet ....





Dave Peterson

how do i remove page breakup lines in the worksheet ?
 
Click on the Office Button
Click on Excel Options
Advanced category
"Display Options for this worksheet" Section
Uncheck Show Page breaks.

(Things are hidden pretty well!)

manish wrote:

"smeheut" wrote:

on the active worksheet click on the tools menu then options and uncheck the
page breaks box. this will remove the lines

"manish" wrote:

i have done that in " normal view ".. but atill the page breakup limes are
visible in my worksheet ....


i am using MICROSOFT OFFICE 2007.. there is no option like that..


--

Dave Peterson


All times are GMT +1. The time now is 04:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com