Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
In my excel sheet I only want to see used rows and column.thanks
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
In my excel sheet I only want to see used rows and column.thanks
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ... |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ... |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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: |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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: |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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: |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
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: |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
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: |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ... |
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|