The View Option makes it possible to show or hide most of Microsoft Excel settings quickly, such as Inner Tabs, Formula Bar, Status Bar, Windows in Taskbar, Gridlines, Page Breaks, Display Zeros, Vertical Scrollbar, Horizontal Scrollbar, Sheet Tab, etc. It will save your time in looking for these setting when you need to show or hide them.
![Excel Excel](/uploads/1/2/5/4/125494858/792497147.gif)
Microsoft Excel 2010 data is typically best viewed on your computer screen. Unfortunately, it just is not always possible to force someone to view it that way.
So you need to learn how to adjust the settings in Excel 2010 so that documents are properly formatted for printing. An important element of this is simply knowing where a page ends or begins, which is why it can be helpful to know how to show page breaks in Excel 2010. With page breaks visible on your screen by default, you will always know what data in your spreadsheet is going to fit on a page, and what data is going to be pushed to another page. Show Excel 2010 Page Break Lines by Default Like many of the other default changes that you can make to an Excel 2010 spreadsheet, the setting that you need to modify is found on the Excel Options menu.
Changes that you make in this menu will affect the default way that your spreadsheet is displayed, and the default way that it operates. What this means is that a change to the Excel Options menu will automatically be applied to all new documents until you choose to change that option again. Step 1: Launch Microsoft Excel 2010.
Step 2: Click the File tab at the top of the window. Step 3: Click Options at the bottom of the left column to open the Excel Options window. Step 4: Click Advanced in the column at the left side of the Excel Options window. Step 5: Scroll to the Display options for this worksheet section, then check the box to the left of Show page breaks. Note that this is only changing the option for the worksheet that is currently active.
If you want to make this change for other worksheets, you will need to create that sheet in the current workbook, then choose the sheet from the drop-down menu to the right of Display options for this worksheet. Step 6: Click the OK button at the bottom of the window. You should now see the page breaks on the current worksheet.
![Page Break View On Excel For Mac 2011 Page Break View On Excel For Mac 2011](http://www.get-digital-help.com/wp-content/uploads/2013/11/delete-page-break-printer-lines.png)
Hi Shane, Kinda thought so. Thanks for confirming. Cheers, Kristine 'Shane Devenshire' wrote: Hi, Nothing in Excel to control this. You might be able to change a Windows color setting, but if you do it would effect all programs.
If this helps, please click the Yes button. Cheers, Shane Devenshire 'kgriba' wrote: I'm in 'page break view' of Excel, and Excel likes to place a watermark in the background 'Page 1'. While this doesn't print, I still find it 'noisy' for onscreen viewing. Is there a way to make the type/letters of 'Page 1' any paler or another colour? Thanks, kgriba.
Hi Gord, Yeah, thanks. I didn't think I could change it but thought I'd ask just in case! Cheers, Kristine 'Gord Dibben' wrote: No.
View in Normal to make it go away. Gord Dibben MS Excel MVP On Wed, 11 Mar 2009 15:46:01 -0700, kgriba wrote: I'm in 'page break view' of Excel, and Excel likes to place a watermark in the background 'Page 1'.
While this doesn't print, I still find it 'noisy' for onscreen viewing. Is there a way to make the type/letters of 'Page 1' any paler or another colour? Thanks, kgriba.