how to delete rows and columns not used

[Tipps]

When I scroll down, or hit END, I want the sheet to stop at the last
row and when I scroll to the right, to stop at the last column. I
could do this for Excel Windows but not sure how to in Mac.

It was a combo of highlighting the document and using ctrl shift delete
or something.

This would 'delete' rows and columns not used.
Thanks.

 

[PhilD]

When I scroll down, or hit END, I want the sheet to stop at the last
row and when I scroll to the right, to stop at the last column. I
could do this for Excel Windows but not sure how to in Mac.

Off the top of my head, you could "hide" the columns you don't want (or
don't want to see: hidden columns can still be used for calculations).
To hide columns, highlight the appropriate ones at the top, then
control-click the labels [1] and select hide column.

Doing rows works in a similar way.

[1] Not sure what this should be called, but I am referring to the
letters that are used to define individual cells: A, B, C, ... DA, DB,
DC, ... etc.

Hope this helps.

PhilD

 

[Tipps]

I know about hiding columns, etc. It's actually deleting unused
columns and rows that I'm looking to do. It's possible with Windows as
I did it, some time ago tho. This trick means that whenn you do the
command to go to the end of your sheet, the scrolling stops at the last
row and the last column.

Any ideas?

 

[JE McGimpsey]

I know about hiding columns, etc. It's actually deleting unused
columns and rows that I'm looking to do. It's possible with Windows as
I did it, some time ago tho. This trick means that whenn you do the
command to go to the end of your sheet, the scrolling stops at the last
row and the last column.

No, it's not possible to delete unused rows or columns with any version
of Windows XL. It may be possible with another application.

An XL97-2004 worksheet has 256 columns and 65536 rows. Always.

You can limit the scroll area by running something like this event macro
each time the workbook opens (type or paste it in the ThisWorkbook
module - CTRL/right-click the workbook title bar and choose View Code):

Private Sub Workbook_Open()
Worksheets("Sheet1").ScrollArea = "A1:J10"
End Sub

This prevents scrolling or selecting a cell outside the scroll area with
the mouse, or the arrow, Return, or tab keys. If you hide the
columns/rows outside the scroll area, it will look like the surplus
columns/rows were deleted

However, it doesn't prevent the user from entering a cell address in the
name box (on the left side of the formula bar), hitting enter, and
selecting a cell that way. Nor does it prevent references to cells that
are hidden.

 

[CyberTaz]

Hi Tipps -

I believe you're simply referring to the default behavior of WinXL...
these unused rows & columns didn't actually 'disappear', right?

If you use cells A1:G95, for example:

1- Dragging the Scroll Bar button will not allow you to scroll beyond
Column G or Row 95, and
2- If the cell selector is within that range, Ctrl+End will only take
you to G95 rather than IV65536 and END>RtArrow or Ctrl+RtArrow will
take you no further than Column G, etc.

All this is based on the 'boundaries' to which changes have been made
in the sheet, including empty cells which have been reformatted in some
way. I think the keystroke you mention was probably just fo th pupose
of making sure the cells adjacent to your data range were cleared of
all content.

Does any of this sound at all familiar?

Regards |:>)