Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change Last Cell
How do you change the last cell in your worksheet? I want to reassign the
last cell it takes me to when I choose CTRL+END. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change Last Cell
Try this:
Delete all of the extraneous rows and columns. (EditDeleteEntire Row/Column) Save the workbook. Try [Ctrl]+[End] Does that help? *********** Regards, Ron XL2002, WinXP-Pro "DAVIS" wrote: How do you change the last cell in your worksheet? I want to reassign the last cell it takes me to when I choose CTRL+END. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change Last Cell
If you search for ctrl+end in microsoft.public.access, you will see several
posts asking about this. With Excel 2003, sometimes edit/delete works, sometimes it doesn't. What does work (sometimes I have to do the edit/delete first), is to do file/save-as to save the file to itself. "Ron Coderre" wrote: Try this: Delete all of the extraneous rows and columns. (EditDeleteEntire Row/Column) Save the workbook. Try [Ctrl]+[End] Does that help? *********** Regards, Ron XL2002, WinXP-Pro "DAVIS" wrote: How do you change the last cell in your worksheet? I want to reassign the last cell it takes me to when I choose CTRL+END. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
Cell Change Color - Need Help | New Users to Excel | |||
Possible Lookup Table | Excel Worksheet Functions | |||
background color of my cell does not change | Excel Discussion (Misc queries) | |||
Look for change next blank cell in Range | Excel Worksheet Functions |