ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Page Breaks (https://www.excelbanter.com/excel-discussion-misc-queries/43129-page-breaks.html)

Woody13

Page Breaks
 
I'm using Page Break Preview and wanted to add additional page breaks. Using
the insert menu after highlighting a row does not work. Any ideas? Isn't
there a way to do it with a keyboard button and using the mouse
simultaneously? Thanks

Elisabeth

Select your row, then right click to get the Insert Page Break menu item
--
Elisabeth


"Woody13" wrote:

I'm using Page Break Preview and wanted to add additional page breaks. Using
the insert menu after highlighting a row does not work. Any ideas? Isn't
there a way to do it with a keyboard button and using the mouse
simultaneously? Thanks


bill k


in page break preview

select a cell in A column and press <ALTI,B to get a horizontal break
above that cell
select a cell in row one and press <ALTI,B to insert a vertical page
break to the left of that cell

or right click onto those cells and select insert page break

hope that helps


--
bill k


------------------------------------------------------------------------
bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821
View this thread: http://www.excelforum.com/showthread...hreadid=400615



All times are GMT +1. The time now is 12:21 AM.

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