Using Microsoft Excel to organize and analyze aspects of your small business has long been a standard tool. When you're working with raw data, presentation many not be as important as nuts-and-bolts functionality, but there are often times when you need to present your work for lenders, shareholders or employees. Formatting existing spreadsheets may be all you need to make your work presentable. There are a number of cases where dotted lines present a barrier to effective presentation and in Excel these lines can occur in several ways with entirely different purposes. Here are the most common ways to remove the lines from your spreadsheets.

These tips will help you remove dotted lines in Excel 2007 to current Excel versions in Microsoft Office 365. Tip. These techniques may also work with older versions of Excel. Remove Spreadsheet Gridlines By default, Excel displays gridlines, faint lines that define the borders around individual or merged cells.

While these are no longer displayed as dotted lines, removing these is often necessary when you want to eliminate the spreadsheet look from your data. Gridlines are often confused with cell borders, but gridlines affect an entire spreadsheet while borders are customizable for each cell. By default, gridlines don't appear on printed spreadsheets, while cell borders do. To remove gridlines, simply select the View tab at the top of the screen and click to remove the check mark in the Gridlines box in the Show section of the ribbon. For Excel 2007, this box is named Show/Hide. Remove Dotted Cell Borders It's common to format individual cells, merged cells or groups of cells for a better printed appearance. One formatting technique involves adding borders.

Selecting the Home tab at the top of the screen reveals the Font section on the ribbon. Clicking the Borders drop-down button gives you an extensive list of border options for the currently selected cell or range of cells. If your current borders are dotted lines, you can turn off borders or select a style other than dotted lines for the cell borders. Remove a Page Break in Excel An Excel page break problem can also create unexpected dotted lines.

When you have a spreadsheet formatted to print, page breaks are represented horizontally by lines. In the current version of Excel for Office 365, a manually added page break shows as a solid horizontal line, while automatically generated page breaks show as dotted lines.

To remove a single manually added page break in Excel, select a cell in the row immediately below the primary page break. Select the Page Layout tab at the top of the screen and find Breaks in the Page Setup section of the Ribbon.

Click on Breaks and select Remove Page Break. In Normal View, the solid horizontal line disappears.

However, the dotted lines of automatically generated page breaks remain. Remove these using the following steps:.

Select the File tab from the top of the screen. Click Options from the menu on the left side of the screen. Click Advanced on the left side of the pop-up window. Scroll down to Display options for this worksheet. Click to remove the check from the box beside Show page breaks.

Photo : floor plan design software for mac. It comes with a large collection of furniture, designs and other things needed to design homes and their layout. Part 6 6..Roomeon 3D Planner Features and functions Roomeon 3D planner is free floor plan software windowswhich enables you to design and plan the flooring, furniture and interiors of a house.

JS, Numbers doesn't have a Page Break command or feature. It's a What You See is What You Get program, and if you want some content to move to another page you have to adjust the content manually until it looks the way you want it to. An easy way is to grab the Row Height control of the last row you wish to display on the current page and drag it down until all rows below have jumped off that page. Or, you could split the table into separate smaller tables by dragging them into pieces – a more laborious option. JS, Numbers doesn't have a Page Break command or feature.

It's a What You See is What You Get program, and if you want some content to move to another page you have to adjust the content manually until it looks the way you want it to. An easy way is to grab the Row Height control of the last row you wish to display on the current page and drag it down until all rows below have jumped off that page. Or, you could split the table into separate smaller tables by dragging them into pieces – a more laborious option.

Thanks, Jerry, But there is no way I can use your solution now. The spreadsheet holds my music collections (around 2,500 CDs), split into 15 genres.

Excel Page Breaks For Printing

So I already have 15 worksheets @ 1 table each (actually 16 if you count the Summary). Splitting each and every table in 26 separate tables would be a killer job that I am not willing to do. I still think paying $119 for Office for Mac would be much easier. OTOH, I prefer using Pages instead of Word so it looks like there is no perfect software world out there! Message was edited by: iosiP. Apple Footer. This site contains user submitted content, comments and opinions and is for informational purposes only.

Apple may provide or recommend responses as a possible solution based on the information provided; every potential issue may involve several factors not detailed in the conversations captured in an electronic forum and Apple can therefore provide no guarantee as to the efficacy of any proposed solutions on the community forums. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the.