Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Manually reseting the used cell range
sorry if this is a double post. My excel workbook is too large and I think
the problem is that I copied formats to the end of the sheet. When I hit "Ctrl + End" it goes to the end of the sheet even though I have deleted the cells and the rows manually. Any help is appreciated? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Manually reseting the used cell range
Did you save the workbook?
Did you close it and reopen it (then check it)? Debra Dalgleish shows techniques to reset that last used cell: http://contextures.com/xlfaqApp.html#Unused Woody13 wrote: sorry if this is a double post. My excel workbook is too large and I think the problem is that I copied formats to the end of the sheet. When I hit "Ctrl + End" it goes to the end of the sheet even though I have deleted the cells and the rows manually. Any help is appreciated? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Manually reseting the used cell range
Hi Woody13
Look here http://www.contextures.com/xlfaqApp.html#Unused -- Regards Ron de Bruin http://www.rondebruin.nl "Woody13" wrote in message ... sorry if this is a double post. My excel workbook is too large and I think the problem is that I copied formats to the end of the sheet. When I hit "Ctrl + End" it goes to the end of the sheet even though I have deleted the cells and the rows manually. Any help is appreciated? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to enter data in one row cell only in a cell range | Excel Worksheet Functions | |||
Determine if Cell Address is within a Range | Excel Worksheet Functions | |||
need to Copy or Move to active cell from specified range | Excel Discussion (Misc queries) | |||
How do I change a cell range with a reference cell? | Excel Discussion (Misc queries) | |||
Returning a Value to a Cell Based on a Range of Uncertain Size | Excel Worksheet Functions |