Display a single page on an Excel sheet
elise_forum
Posted messages
7
Status
Membre
-
Mike-31 Posted messages 18405 Registration date Status Contributeur Last intervention -
Mike-31 Posted messages 18405 Registration date Status Contributeur Last intervention -
Hello,
I would like to know if it is possible, and if so how, to display only one page on my Excel sheet.
Actually, I use this Excel sheet to create a schedule and I have set the display to landscape mode and page layout mode (display as it will be printed).
The display I see matches my needs, what I would like, however, is for only this page to be visible and for all the others to be invisible (the cells to the right and below). Like what we could have in Word... or a bit like the view we have in "page break" mode but without the big "PAGE 1" in the middle and with headers and footers appearing...
I'm not sure if my request is clear enough... Thank you in advance,
Elise
I would like to know if it is possible, and if so how, to display only one page on my Excel sheet.
Actually, I use this Excel sheet to create a schedule and I have set the display to landscape mode and page layout mode (display as it will be printed).
The display I see matches my needs, what I would like, however, is for only this page to be visible and for all the others to be invisible (the cells to the right and below). Like what we could have in Word... or a bit like the view we have in "page break" mode but without the big "PAGE 1" in the middle and with headers and footers appearing...
I'm not sure if my request is clear enough... Thank you in advance,
Elise
3 réponses
Hello
perhaps simply by hiding the columns and rows to be hidden and protecting the sheet
(to hide: right-click on the column or group and "hide", the same for the rows)
best regards
--
The quality of the response mostly depends on the clarity of the question, thank you!
perhaps simply by hiding the columns and rows to be hidden and protecting the sheet
(to hide: right-click on the column or group and "hide", the same for the rows)
best regards
--
The quality of the response mostly depends on the clarity of the question, thank you!
I don't know, it depends on the configuration of your sheet, because you can only act on complete rows or columns.
For example, if what you want to keep goes from A1 to Z100, you need to hide everything else.
Go to the address bar, place the cursor at Y and type AA:XFD and enter.
Right-click on the selection and "hide."
Do the same vertically with 100:1048576.
(Excel >= 2007)
You can see the "ends" of the sheet with: hold down the ctrl key and press the left arrow key
or with the down arrow key.
I found out how to limit the view of the number of rows in a sheet, but I forgot... maybe someone can pull that out for you.
Best regards.
For example, if what you want to keep goes from A1 to Z100, you need to hide everything else.
Go to the address bar, place the cursor at Y and type AA:XFD and enter.
Right-click on the selection and "hide."
Do the same vertically with 100:1048576.
(Excel >= 2007)
You can see the "ends" of the sheet with: hold down the ctrl key and press the left arrow key
or with the down arrow key.
I found out how to limit the view of the number of rows in a sheet, but I forgot... maybe someone can pull that out for you.
Best regards.
Hello,
select the page you only want to print
for example from cell H1 to N50
then go to the Page Layout tab/Page Setup section and click on Print Area/Set
you may need to adjust the column widths and row heights so that your area fits on one page.
you can continue working on all your pages but only the defined area will be printable
See you+
Mike-31
I am responsible for what I say, not for what you understand...
select the page you only want to print
for example from cell H1 to N50
then go to the Page Layout tab/Page Setup section and click on Print Area/Set
you may need to adjust the column widths and row heights so that your area fits on one page.
you can continue working on all your pages but only the defined area will be printable
See you+
Mike-31
I am responsible for what I say, not for what you understand...
Impossible since I use several formulas on this page...