Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Last cell" in Excel 2003 is way past end of data, how do i fix?
When I use "Go To", "Special", "Last cell" in my spread sheet, the cursor
goes many rows past the end of the data. ie. about 36 rows past the last data row. This is a problem because when I import this data into a blank Access table all 43 rows are imported (36 are blank) and the import gives me an error message. I've tried deleting from the last data row +1 past the row of the "last cell" but the last cell remains in the same relative location. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Last cell" in Excel 2003 is way past end of data, how do i fix?
You need to reset the used range:
http://contextures.com/xlfaqApp.html#Unused -- Biff Microsoft Excel MVP "silverfox52" wrote in message ... When I use "Go To", "Special", "Last cell" in my spread sheet, the cursor goes many rows past the end of the data. ie. about 36 rows past the last data row. This is a problem because when I import this data into a blank Access table all 43 rows are imported (36 are blank) and the import gives me an error message. I've tried deleting from the last data row +1 past the row of the "last cell" but the last cell remains in the same relative location. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Last cell" in Excel 2003 is way past end of data, how do i fix?
hi
i think excel has lost it used range reference. see this site to reset. http://www.contextures.com/xlfaqApp.html#Unused regards FSt1 "silverfox52" wrote: When I use "Go To", "Special", "Last cell" in my spread sheet, the cursor goes many rows past the end of the data. ie. about 36 rows past the last data row. This is a problem because when I import this data into a blank Access table all 43 rows are imported (36 are blank) and the import gives me an error message. I've tried deleting from the last data row +1 past the row of the "last cell" but the last cell remains in the same relative location. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Last cell" in Excel 2003 is way past end of data, how do i fix?
Delete (not clear contents) the blank rows. Save the workbook and the last
cell should be reset. -- HTH... Jim Thomlinson "silverfox52" wrote: When I use "Go To", "Special", "Last cell" in my spread sheet, the cursor goes many rows past the end of the data. ie. about 36 rows past the last data row. This is a problem because when I import this data into a blank Access table all 43 rows are imported (36 are blank) and the import gives me an error message. I've tried deleting from the last data row +1 past the row of the "last cell" but the last cell remains in the same relative location. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Last cell" in Excel 2003 is way past end of data, how do i fix?
The Last Cell will grow as data is added to a spreadsheet. But will only
shrink, when the workbook is saved. So, even if you delete all the cells below and to the right of your data, the last cell will not be updated until you save your workbook. HTH Elkar "silverfox52" wrote: When I use "Go To", "Special", "Last cell" in my spread sheet, the cursor goes many rows past the end of the data. ie. about 36 rows past the last data row. This is a problem because when I import this data into a blank Access table all 43 rows are imported (36 are blank) and the import gives me an error message. I've tried deleting from the last data row +1 past the row of the "last cell" but the last cell remains in the same relative location. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Last cell" in Excel 2003 is way past end of data, how do i fix?
Hi,
And for future reference Ctrl+End does the same thing as Edit, Go To, Special, Last Cell. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "silverfox52" wrote: When I use "Go To", "Special", "Last cell" in my spread sheet, the cursor goes many rows past the end of the data. ie. about 36 rows past the last data row. This is a problem because when I import this data into a blank Access table all 43 rows are imported (36 are blank) and the import gives me an error message. I've tried deleting from the last data row +1 past the row of the "last cell" but the last cell remains in the same relative location. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Last cell" in Excel 2003 is way past end of data, how do i fix?
The most common cause of the last cell being set outside the worksheet range
that is currently in use is excessive formatting. When you format whole rows and columns, some types of formatting can cause the last cell to be set to a cell far below or to the right of the actual range that is in use. Try to select the extra rows and choose Edit-Clear All Repeat with Columns, if required. Test by GoTo-Special and choose Current Region... "silverfox52" wrote: When I use "Go To", "Special", "Last cell" in my spread sheet, the cursor goes many rows past the end of the data. ie. about 36 rows past the last data row. This is a problem because when I import this data into a blank Access table all 43 rows are imported (36 are blank) and the import gives me an error message. I've tried deleting from the last data row +1 past the row of the "last cell" but the last cell remains in the same relative location. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Last cell" in Excel 2003 is way past end of data, how do i fi
The save was what was needed, ;) thanks
"Elkar" wrote: The Last Cell will grow as data is added to a spreadsheet. But will only shrink, when the workbook is saved. So, even if you delete all the cells below and to the right of your data, the last cell will not be updated until you save your workbook. HTH Elkar "silverfox52" wrote: When I use "Go To", "Special", "Last cell" in my spread sheet, the cursor goes many rows past the end of the data. ie. about 36 rows past the last data row. This is a problem because when I import this data into a blank Access table all 43 rows are imported (36 are blank) and the import gives me an error message. I've tried deleting from the last data row +1 past the row of the "last cell" but the last cell remains in the same relative location. |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Last cell" in Excel 2003 is way past end of data, how do i fix?
Sheeloo
Couple or three points.................... Has nothing to do with excess cells being formatted. Once upon a time the excess range was filled then "cleared", leaving behind the false used range. EditClear All will not reset the used range. You must EditDelete And selecting Current Region will not show you the false used range. Current Region only shows contiguous non-blank cells in any region. CTRL + End will show you the used range. Workbook must be saved before the new usedrange is set. Gord Dibben MS Excel MVP On Mon, 2 Mar 2009 11:17:01 -0800, Sheeloo <Click above to get my email id wrote: The most common cause of the last cell being set outside the worksheet range that is currently in use is excessive formatting. When you format whole rows and columns, some types of formatting can cause the last cell to be set to a cell far below or to the right of the actual range that is in use. Try to select the extra rows and choose Edit-Clear All Repeat with Columns, if required. Test by GoTo-Special and choose Current Region... "silverfox52" wrote: When I use "Go To", "Special", "Last cell" in my spread sheet, the cursor goes many rows past the end of the data. ie. about 36 rows past the last data row. This is a problem because when I import this data into a blank Access table all 43 rows are imported (36 are blank) and the import gives me an error message. I've tried deleting from the last data row +1 past the row of the "last cell" but the last cell remains in the same relative location. |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Last cell" in Excel 2003 is way past end of data, how do i fi
When I pressed Ctrl+End, the cursor went WAAAAY to the end of the
spreadsheet, rather than just to end of of the area where the data is located. How do I accomplish that? "Shane Devenshire" wrote: Hi, And for future reference Ctrl+End does the same thing as Edit, Go To, Special, Last Cell. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "silverfox52" wrote: When I use "Go To", "Special", "Last cell" in my spread sheet, the cursor goes many rows past the end of the data. ie. about 36 rows past the last data row. This is a problem because when I import this data into a blank Access table all 43 rows are imported (36 are blank) and the import gives me an error message. I've tried deleting from the last data row +1 past the row of the "last cell" but the last cell remains in the same relative location. |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Last cell" in Excel 2003 is way past end of data, how do i fi
Sounds like you need to reset the used range. See this:
http://contextures.com/xlfaqApp.html#Unused -- Biff Microsoft Excel MVP "dk" wrote in message ... When I pressed Ctrl+End, the cursor went WAAAAY to the end of the spreadsheet, rather than just to end of of the area where the data is located. How do I accomplish that? "Shane Devenshire" wrote: Hi, And for future reference Ctrl+End does the same thing as Edit, Go To, Special, Last Cell. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "silverfox52" wrote: When I use "Go To", "Special", "Last cell" in my spread sheet, the cursor goes many rows past the end of the data. ie. about 36 rows past the last data row. This is a problem because when I import this data into a blank Access table all 43 rows are imported (36 are blank) and the import gives me an error message. I've tried deleting from the last data row +1 past the row of the "last cell" but the last cell remains in the same relative location. |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Last cell" in Excel 2003 is way past end of data, how do i fi
Hi
Select a column to the right of your dataControl+Shift+Cursor right arrow to select all columns to the rightRight clickDelete Select a row below your dataControl+Shift+Cursor down arrow to select all rows belowRight clickDelete Save the file. Close the file. Reopen -- Regards Roger Govier "dk" wrote in message ... When I pressed Ctrl+End, the cursor went WAAAAY to the end of the spreadsheet, rather than just to end of of the area where the data is located. How do I accomplish that? "Shane Devenshire" wrote: Hi, And for future reference Ctrl+End does the same thing as Edit, Go To, Special, Last Cell. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "silverfox52" wrote: When I use "Go To", "Special", "Last cell" in my spread sheet, the cursor goes many rows past the end of the data. ie. about 36 rows past the last data row. This is a problem because when I import this data into a blank Access table all 43 rows are imported (36 are blank) and the import gives me an error message. I've tried deleting from the last data row +1 past the row of the "last cell" but the last cell remains in the same relative location. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003: Conditional Formatting using "MIN" & "MAX" function | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Range name of "\0"? - How can I slide this past Excel? | Excel Worksheet Functions | |||
In Excel 2003 is there a way to prevent "Save As" and "Print"? | Excel Discussion (Misc queries) | |||
How do I add more columns past cell "IV" | Charts and Charting in Excel |