(Newbie question!) Trying to crop the page/field size. Screenshot included!

[I Am Legend]

Hi,

I am trying to get rid of the cells and columns, so i can set my page like this:

Any solutions?

Thanks in advance!!

 

[MrKowz]

I'm not sure if this works in Excel 2007/2010, but in 2003 I can go into View>Page Break Preview and adjust the edges to fit the range I want it to show.

 

[I Am Legend]

I'm not sure if this works in Excel 2007/2010, but in 2003 I can go into View>Page Break Preview and adjust the edges to fit the range I want it to show.

Thank you for replying.

I do have the option to go to View>Page Break Preview. But what do you mean adjust edges?

I just wanted a specific amount of cells to be shown, and the rest completly cut off.

 

[MrKowz]

Edit: Select all cells to the right of your viewable range and hide them. Then all cells below and hide them

 

[I Am Legend]

Edit: Select all cells to the right of your viewable range and hide them. Then all cells below and hide them

I try to select all the cells on the right, it goes on for ages. Is there a way I can select them all? Then hide?

 

[MrKowz]

Use the following macro:

Public Sub HideToRightAndDown()
Range(Cells(1, ActiveCell.Offset(0, 1).Column), Cells(1, Columns.Count)).EntireColumn.Hidden = True
Range(Cells(ActiveCell.Offset(1, 0).Row, 1), Cells(Rows.Count, 1)).EntireRow.Hidden = True
End Sub

Put the cursor in the bottom-right of the range you want to show, run the macro, and it will hide everything else.

 

[I Am Legend]

Use the following macro:

Public Sub HideToRightAndDown()
Range(Cells(1, ActiveCell.Offset(0, 1).Column), Cells(1, Columns.Count)).EntireColumn.Hidden = True
Range(Cells(ActiveCell.Offset(1, 0).Row, 1), Cells(Rows.Count, 1)).EntireRow.Hidden = True
End Sub

Put the cursor in the bottom-right of the range you want to show, run the macro, and it will hide everything else.

I owe you my life!
Thank you very much! This is for my coursework