In my excel sheet I only want to see used rows and column.thanks

J

Joe

Hi Bernard,

I'd like to see just the area that has my data ie Pivot table. I dont need
to see more columns and/or rows around. Like if you had selected View>Page
preview. I would like to get the spreadsheet like a form. so I looks more
professional, ie when you are trying to fill a form they just give you the
space to fill out but in Excel you have more and more lines below and on the
sites. Ask me questions

Thanks,
jose
 
J

Joe

Hi don Guillett,

Thanks. This options removes all the scroll affecting other sheets. Any
other Idea?

Thanks,
Joe
 
J

Joe

it looks better than before. Is there anything that I can do to center the
form in the sheet without having unused collumns around so to make it look
like a proper Form or questionnaire
 
G

Gord Dibben

Assuming your form is comprised of the range A1:G30 or similar.

Insert a couple of columns at left. Now range is C1:J30

Insert a couple of rows at top and bottom.

Color these a nice grey color so's your data input area is surrounded by these.

To keep users from going outside this area you could lock those cells and not
allow locked cells to be selected.

Or set the scrollarea to just your data range.

A few ways to set up your form visually...........whatever looks best to you.


Gord
 
J

Joe

Great minds think alike. Exactly what I did this morning. Thanks for the
extra tip. They are very helful. Have a nice day
 
J

Joe

When you say, to set the scrollarea to data range. Is there any way to do
this apart from using Freeze panel option?
 
G

Gord Dibben

Joe

Through VBA

Since the scrollarea method does not stick between sessions you will have to
reset it each time.

You may wish to place the code into a WorkBook_Open Sub in ThisWorkbook module
and specify which worksheet if only one sheet required.

Private Sub WorkBook_Open()
Sheets("YourSheet").ScrollArea = "C1:J30"
End Sub

Or alternative in the Thisworkbook module to limit scrollarea on all sheets.

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
With ActiveSheet
.ScrollArea = "C1:J30"
End With
End Sub


Gord

When you say, to set the scrollarea to data range. Is there any way to do
this apart from using Freeze panel option?
Click to expand...

Gord Dibben MS Excel MVP
 
F

Faisal

I physically want 10 columns and 100 rows in my worksheet to run a particular
conversion program. Otherwise it goes through every blank cell.
 
P

Pete_UK

The conversion program is not doing a very good job then.

Have you tried saving the file in Excel 95 (or earlier) format? -
these files only had up to 16k rows, so it might speed things up by a
factor of 4.

Pete
 
Top