End of Worksheet

  • Thread starter Thread starter JanetW
  • Start date Start date
J

JanetW

When I press ctrl-End to locate the bottom-right cell of my worksheet
it goes out to column "IV" (ie, the max column number of an Exce
spreadsheet) instead of column "U" which is the last column with an
data or formatting. And when I import this spreadsheet into anothe
spreadsheet, it takes ALL the columns instead of only the columns whic
contain data.

Does anyone know how to get Excel to properly identify the end of th
spreadsheet?

Thanks
 
Go to the first column that is empty, i.e. if your last column is Z, select
AA, press ctrl + shift & right arrow key
do edit>delete, save workbook. Do the same for rows, select the first empty
row and do ctrl + shift & down arrow
edit>delete and save .
 
Does anyone know how to get Excel to properly identify the end of the

Select V1. Press CTRL+SpaceBar. Press CTRL+Shift+RightArrow. Use Delete from
the Edit menu.

Do the same for "dead" rows, except use Shift+SpaceBar, then
CTRL+Shift+DownArrow.

Save & close. Then re-open & try CTRL+End again.

Rgds,
Andy
 
You can select the *entire* column past the end of your data, and then
<Ctrl> <Shift> <RightArrow>,
Right click in the selection and choose "Delete".
Do <Ctrl> <Home> and then do <Save>

Now try <Ctrl> <End>

If there are extra rows, you can do the same using,
<Ctrl> <Shift> <DownArrow>,
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


When I press ctrl-End to locate the bottom-right cell of my worksheet,
it goes out to column "IV" (ie, the max column number of an Excel
spreadsheet) instead of column "U" which is the last column with any
data or formatting. And when I import this spreadsheet into another
spreadsheet, it takes ALL the columns instead of only the columns which
contain data.

Does anyone know how to get Excel to properly identify the end of the
spreadsheet?

Thanks!
 
Thanks! I was manually selecting the extra columns and deleting, whic
didn't solve the problem. But the ctrl-shift-right arrow, then deletin
seems to have taken care of it
 
Janet

No difference in methods you used.

The only thing to remember is "Save the file after deleting the rows and
columns"

In some versions you have to Save then Close and re-open to see the changes.

Gord Dibben Excel MVP
 
Back
Top