Removing columns (not hide or white-out).
 

I am using MS Office 2003 Excel and want to know if it is possible to delete
columns in a worksheet (not hide them or white/black them out) but end a
worksheet after using only a couple of columns? I realize that the columns
go on and on but I would like to know if it is possible to end a worksheet
after column D. I have tried everything. Anyone suggestions?

Thanks a bunch

It's not possible.

--

Vasant

"TrishDB" wrote in message
...
I am using MS Office 2003 Excel and want to know if it is possible to
delete
columns in a worksheet (not hide them or white/black them out) but end a
worksheet after using only a couple of columns? I realize that the
columns
go on and on but I would like to know if it is possible to end a worksheet
after column D. I have tried everything. Anyone suggestions?

Thanks a bunch

What exactly do you need to do this for, there may be another way?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"TrishDB" wrote in message
...
I am using MS Office 2003 Excel and want to know if it is possible to
delete
columns in a worksheet (not hide them or white/black them out) but end a
worksheet after using only a couple of columns? I realize that the
columns
go on and on but I would like to know if it is possible to end a worksheet
after column D. I have tried everything. Anyone suggestions?

Thanks a bunch

Thank you for responding and for sparing me much grief!

"Vasant Nanavati" wrote:

It's not possible.

--

Vasant

"TrishDB" wrote in message
...
I am using MS Office 2003 Excel and want to know if it is possible to
delete
columns in a worksheet (not hide them or white/black them out) but end a
worksheet after using only a couple of columns? I realize that the
columns
go on and on but I would like to know if it is possible to end a worksheet
after column D. I have tried everything. Anyone suggestions?

Thanks a bunch

Thanks for responding. I would like to use Excel as opposed to building a
table in Word, however, I am wanting this sheet to "appear", when opened, as
a worksheet, with just the text, etc. that I have used. Do you know of a way
to eliminate columns that are unused so that when working in Excel (not in
print preview) you will not see additional columns that are not being used?
Thanks for any advice you can give! I appreciate your time.

"Bob Phillips" wrote:

What exactly do you need to do this for, there may be another way?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"TrishDB" wrote in message
...
I am using MS Office 2003 Excel and want to know if it is possible to
delete
columns in a worksheet (not hide them or white/black them out) but end a
worksheet after using only a couple of columns? I realize that the
columns
go on and on but I would like to know if it is possible to end a worksheet
after column D. I have tried everything. Anyone suggestions?

Thanks a bunch

If you hide them and unlock the visible cells then hide the rows/columns
and then protect the sheet,
why wouldn't that work?

--
Regards,

Peo Sjoblom


"TrishDB" wrote in message
...
Thank you for responding and for sparing me much grief!

"Vasant Nanavati" wrote:

It's not possible.

--

Vasant

"TrishDB" wrote in message
...
I am using MS Office 2003 Excel and want to know if it is possible to
delete
columns in a worksheet (not hide them or white/black them out) but end
a
worksheet after using only a couple of columns? I realize that the
columns
go on and on but I would like to know if it is possible to end a
worksheet
after column D. I have tried everything. Anyone suggestions?

Thanks a bunch

Trish

Hiding the unused rows and columns then protecting the sheet is the usual
method.

Setting the scrollarea using VBA is another method.

Note: Setting ScrollArea is good for that session only and only the
activesheet. Has to be reset next time workbook is opened.

Best to place the code into a WorkBook_Open Sub in ThisWorkbook module and
specify which worksheet.

Private Sub WorkBook_Open()
Sheets("YourSheet").ScrollArea = "A1:N34"
End Sub

Note: if users disable macros, the scrollarea method will not work.


Gord Dibben Excel MVP

On Tue, 26 Apr 2005 15:22:02 -0700, "TrishDB"
wrote:

Thanks for responding. I would like to use Excel as opposed to building a
table in Word, however, I am wanting this sheet to "appear", when opened, as
a worksheet, with just the text, etc. that I have used. Do you know of a way
to eliminate columns that are unused so that when working in Excel (not in
print preview) you will not see additional columns that are not being used?
Thanks for any advice you can give! I appreciate your time.

"Bob Phillips" wrote:

What exactly do you need to do this for, there may be another way?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"TrishDB" wrote in message
...
I am using MS Office 2003 Excel and want to know if it is possible to
delete
columns in a worksheet (not hide them or white/black them out) but end a
worksheet after using only a couple of columns? I realize that the
columns
go on and on but I would like to know if it is possible to end a worksheet
after column D. I have tried everything. Anyone suggestions?

Thanks a bunch

Thank you! I will give that a shot!

"Gord Dibben" wrote:

Trish

Hiding the unused rows and columns then protecting the sheet is the usual
method.

Setting the scrollarea using VBA is another method.

Note: Setting ScrollArea is good for that session only and only the
activesheet. Has to be reset next time workbook is opened.

Best to place the code into a WorkBook_Open Sub in ThisWorkbook module and
specify which worksheet.

Private Sub WorkBook_Open()
Sheets("YourSheet").ScrollArea = "A1:N34"
End Sub

Note: if users disable macros, the scrollarea method will not work.


Gord Dibben Excel MVP

On Tue, 26 Apr 2005 15:22:02 -0700, "TrishDB"
wrote:

Thanks for responding. I would like to use Excel as opposed to building a
table in Word, however, I am wanting this sheet to "appear", when opened, as
a worksheet, with just the text, etc. that I have used. Do you know of a way
to eliminate columns that are unused so that when working in Excel (not in
print preview) you will not see additional columns that are not being used?
Thanks for any advice you can give! I appreciate your time.

"Bob Phillips" wrote:

What exactly do you need to do this for, there may be another way?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"TrishDB" wrote in message
...
I am using MS Office 2003 Excel and want to know if it is possible to
delete
columns in a worksheet (not hide them or white/black them out) but end a
worksheet after using only a couple of columns? I realize that the
columns
go on and on but I would like to know if it is possible to end a worksheet
after column D. I have tried everything. Anyone suggestions?

Thanks a bunch

Thank you! I will give that a shot!

"Peo Sjoblom" wrote:

If you hide them and unlock the visible cells then hide the rows/columns
and then protect the sheet,
why wouldn't that work?

--
Regards,

Peo Sjoblom


"TrishDB" wrote in message
...
Thank you for responding and for sparing me much grief!

"Vasant Nanavati" wrote:

It's not possible.

--

Vasant

"TrishDB" wrote in message
...
I am using MS Office 2003 Excel and want to know if it is possible to
delete
columns in a worksheet (not hide them or white/black them out) but end
a
worksheet after using only a couple of columns? I realize that the
columns
go on and on but I would like to know if it is possible to end a
worksheet
after column D. I have tried everything. Anyone suggestions?

Thanks a bunch