Clearing unused cells

[Frank Kabel]

Hi
you can't clear these rows/columns. the best you could do is hide them
8but then you may encounter problems adding rows/columns)

 

[SlimPickins]

How can I clear cells that are at the bottom and right of what I use.
The cells are empty of data.
What I want is to get rid of the cells completely, and still have the
option to add columns and rows as needed.

I also want to add a button to clear a worksheet or one cell.
Can't get the "hang"of macros.....yet.

Slim

 

[David McRitchie]

Just to make sure does Ctrl+End put you at the
intersection of your last used row and your last used
column. You will print up to that point. If that cell
is beyond your data then you have a last cell problem
and would want to look at
http://www.mvps.org/dmcritchie/excel/lastcell.htm

You will not print past the last cell (Ctrl+End) and you will
see this better if you have borders or gridlines turned on.

You can get an indication of this by looking at the size of
the scrollbar.

 

[SlimPickins]

Thanks

Slim

 

[Gord Dibben]

Slim

Clear one cell.......right-click and "Clear Contents"

Clear the sheet......right-click on button at top left intersect of row and
column headers and "Clear Contents".

Also under Tools>Customize>Commands>Edit you will find a "Clear Contents"
button you can drag to your Toolbar.

Gord Dibben Excel MVP