Single page sheet

[Northguy]

How can I create a single sheet or form that just shows the single sheet? In other words I don't want to see the normal unused columns on the right hand side. It would look like the print preview w/o the RHS cells.

 

[My Aswer Is This]

Try this:
On the Ribbon Turn off "Gridlines"
Hide the headings
Then put borders around the cells you want to see.

 

[thisoldman]

I interpreted what northguy wants a little differently: hide the unused columns to the right.

Select the first column you do not want to see. Press Ctrl+Shift+RightArrow. That should take you to column XFD. Then hide the selected columns. I would use the right-click context menu and select "Hide" to do this. This will hide the column labels, too

You can do the same thing with rows.

 

[Northguy]

I interpreted what northguy wants a little differently: hide the unused columns to the right.

Select the first column you do not want to see. Press Ctrl+Shift+RightArrow. That should take you to column XFD. Then hide the selected columns. I would use the right-click context menu and select "Hide" to do this. This will hide the column labels, too

You can do the same thing with rows.

Cool. That's exactly what I was looking for. Thanks

 

[My Aswer Is This]

I thought about doing it this way but had never done that so did not test that option. Now I know. Was not sure what would happen trying to hide so many columns and rows.

I interpreted what northguy wants a little differently: hide the unused columns to the right.

Select the first column you do not want to see. Press Ctrl+Shift+RightArrow. That should take you to column XFD. Then hide the selected columns. I would use the right-click context menu and select "Hide" to do this. This will hide the column labels, too

You can do the same thing with rows.