Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
To remove dotted lines in Microsoft Excel ?
I have been working on a spreadsheet and selected to print an area. Suddenly
there has appeared dotted lines like "page breaks" throughout the sheet in certain rows and columns. When I asked to have my selection printed in the "Print Preview" the selected area beared no resemblance to the area |I selected and seemed to have mixed up several sections of the spreadsheet. To vercome the problem I again selected the particulare section I wanted to print and copied it to sheet2 in the same spreadsheet. The dotted lines wont disappear. I consulted "Help" it suggested right clicking any cell and ask to "Remove all page breaks". I tried the right click but nowhere does it show: "remove all page Breaks". HELP!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
To remove dotted lines in Microsoft Excel ?
Click on VIEW in the menu and then select PAGE BREAK PREVIEW. Now when you
right-click you will get the RESET ALL PAGE BREAKS shortcut menu selection -- Kevin Backmann "Mike Smithdorf" wrote: I have been working on a spreadsheet and selected to print an area. Suddenly there has appeared dotted lines like "page breaks" throughout the sheet in certain rows and columns. When I asked to have my selection printed in the "Print Preview" the selected area beared no resemblance to the area |I selected and seemed to have mixed up several sections of the spreadsheet. To vercome the problem I again selected the particulare section I wanted to print and copied it to sheet2 in the same spreadsheet. The dotted lines wont disappear. I consulted "Help" it suggested right clicking any cell and ask to "Remove all page breaks". I tried the right click but nowhere does it show: "remove all page Breaks". HELP!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
To remove dotted lines in Microsoft Excel ?
Hi Mike,
one way is set one page height and one page width on page setup. hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Mike Smithdorf" escreveu: I have been working on a spreadsheet and selected to print an area. Suddenly there has appeared dotted lines like "page breaks" throughout the sheet in certain rows and columns. When I asked to have my selection printed in the "Print Preview" the selected area beared no resemblance to the area |I selected and seemed to have mixed up several sections of the spreadsheet. To vercome the problem I again selected the particulare section I wanted to print and copied it to sheet2 in the same spreadsheet. The dotted lines wont disappear. I consulted "Help" it suggested right clicking any cell and ask to "Remove all page breaks". I tried the right click but nowhere does it show: "remove all page Breaks". HELP!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel viewer | Setting up and Configuration of Excel | |||
FUNCTION GETPIVOTDATA MICROSOFT EXCEL 2003 VS EXCEL 2004 FOR MAC | Excel Worksheet Functions | |||
Remove all macros and objects in Excel, Save and Quit | Excel Discussion (Misc queries) | |||
Deleting Lines in Excel | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel |