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

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

Please elaborate
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Joe" wrote in message
...

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

Hide the others or use scroll area

--
Don Guillett
SalesAid Software

"Joe" wrote in message
...

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

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 ViewPage
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

"Bernard Liengme" wrote:

Please elaborate
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Joe" wrote in message
...

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

Hi don Guillett,

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

Thanks,
Joe

"Don Guillett" wrote:

Hide the others or use scroll area

--
Don Guillett
SalesAid Software

"Joe" wrote in message
...

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

Hide the unused rows and columns?


Gord Dibben MS Excel MVP

On Wed, 22 Nov 2006 03:57:01 -0800, Joe wrote:

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

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

"Gord Dibben" wrote:

Hide the unused rows and columns?


Gord Dibben MS Excel MVP

On Wed, 22 Nov 2006 03:57:01 -0800, Joe wrote:

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

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


On Thu, 23 Nov 2006 01:07:02 -0800, Joe wrote:

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

"Gord Dibben" wrote:

Hide the unused rows and columns?


Gord Dibben MS Excel MVP

On Wed, 22 Nov 2006 03:57:01 -0800, Joe wrote:

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

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

"Gord Dibben" wrote:

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


On Thu, 23 Nov 2006 01:07:02 -0800, Joe wrote:

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

"Gord Dibben" wrote:

Hide the unused rows and columns?


Gord Dibben MS Excel MVP

On Wed, 22 Nov 2006 03:57:01 -0800, Joe wrote:

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

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

"Gord Dibben" wrote:

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


On Thu, 23 Nov 2006 01:07:02 -0800, Joe wrote:

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

"Gord Dibben" wrote:

Hide the unused rows and columns?


Gord Dibben MS Excel MVP

On Wed, 22 Nov 2006 03:57:01 -0800, Joe wrote:

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

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

On Fri, 24 Nov 2006 03:30:01 -0800, Joe wrote:

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

"Gord Dibben" wrote:

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


On Thu, 23 Nov 2006 01:07:02 -0800, Joe wrote:

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

"Gord Dibben" wrote:

Hide the unused rows and columns?


Gord Dibben MS Excel MVP

On Wed, 22 Nov 2006 03:57:01 -0800, Joe wrote:






Gord Dibben MS Excel MVP

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

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

"Bernard Liengme" wrote:

Please elaborate
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Joe" wrote in message
...

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

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

On Jun 26, 10:46*am, Faisal wrote:
I physically want 10 columns and 100 rows in my worksheet to run a particular
conversion program. Otherwise it goes through every blank cell.



"Bernard Liengme" wrote:
Please elaborate
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Joe" wrote in message
...- Hide quoted text -

- Show quoted text -