Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CTRL+SHIFT+END extends selection of cells to last - how reset?
I have been working on spreadheets with large amounts of data, that I have
manipulated and some of which I have deleted, when I want to select it all, and press CTRL+SHIFT+END is goes row 14000 where the data originally ended instead of 6000 where it ends now. I wondered if there was anyway to reset what excel considers the last used cell to be? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
CTRL+SHIFT+END extends selection of cells to last - how reset?
LisaH wrote: I have been working on spreadheets with large amounts of data, that I have manipulated and some of which I have deleted, when I want to select it all, and press CTRL+SHIFT+END is goes row 14000 where the data originally ended instead of 6000 where it ends now. I wondered if there was anyway to reset what excel considers the last used cell to be? Hi LisaH Save the workbook, the used range will be re-calculated. Regards Steve |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
CTRL+SHIFT+END extends selection of cells to last - how reset?
Select blanks cells. Go to Edit Clear all. Save workbook and should clear area. or select cells press F5. select blanks and then Edit clear all. VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=565913 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
CTRL+SHIFT+END extends selection of cells to last - how reset?
Already tried that!
" wrote: LisaH wrote: I have been working on spreadheets with large amounts of data, that I have manipulated and some of which I have deleted, when I want to select it all, and press CTRL+SHIFT+END is goes row 14000 where the data originally ended instead of 6000 where it ends now. I wondered if there was anyway to reset what excel considers the last used cell to be? Hi LisaH Save the workbook, the used range will be re-calculated. Regards Steve |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
CTRL+SHIFT+END extends selection of cells to last - how reset?
That didn't work either, thanks anyway.
"VBA Noob" wrote: Select blanks cells. Go to Edit Clear all. Save workbook and should clear area. or select cells press F5. select blanks and then Edit clear all. VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=565913 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
CTRL+SHIFT+END extends selection of cells to last - how reset?
LisaH wrote: Already tried that! Then I suspect that you haven't actually got rid of all your data and/or formatting, see VBANoob's suggestion. Regards Steve |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
CTRL+SHIFT+END extends selection of cells to last - how reset?
LisaH wrote: That didn't work either, thanks anyway. Copy only your used range into a new sheet and delete the original. Regards Steve |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
CTRL+SHIFT+END extends selection of cells to last - how reset?
I have tried that now, and it still isn't working. Thanks
" wrote: LisaH wrote: Already tried that! Then I suspect that you haven't actually got rid of all your data and/or formatting, see VBANoob's suggestion. Regards Steve |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
CTRL+SHIFT+END extends selection of cells to last - how reset?
You might have to close excel down but does work VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=565913 |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
CTRL+SHIFT+END extends selection of cells to last - how reset?
Debra Dalgleish shows techniques to reset that last used cell:
http://contextures.com/xlfaqApp.html#Unused LisaH wrote: I have been working on spreadheets with large amounts of data, that I have manipulated and some of which I have deleted, when I want to select it all, and press CTRL+SHIFT+END is goes row 14000 where the data originally ended instead of 6000 where it ends now. I wondered if there was anyway to reset what excel considers the last used cell to be? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i remove shift lock (highlighting cells) from excel? | Excel Discussion (Misc queries) | |||
help with VB/Macro to shift cells | Excel Discussion (Misc queries) | |||
help with VB/Macro to shift cells | Excel Discussion (Misc queries) | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
I need to shift cells down only to a point w/o disturbing the bot. | Excel Discussion (Misc queries) |