| Home |
| Search |
| Today's Posts |
|
#6
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. |
| 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 | |||
Threaded Mode
