| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I set a "page end" point on a large worksheet?
I am a fairly new user to Excel. I have created a worksheet with over 200
lines of data. When I use the "control end" shortcut, I end up way down at the end, if you know what I mean. Is there a way to set the end of my page at the actual end of my data? Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I set a "page end" point on a large worksheet?
Visit Debra Dalgleish's site to see a way to reset this last used cell:
http://contextures.com/xlfaqApp.html#Unused kpetefaith wrote: I am a fairly new user to Excel. I have created a worksheet with over 200 lines of data. When I use the "control end" shortcut, I end up way down at the end, if you know what I mean. Is there a way to set the end of my page at the actual end of my data? Thanks. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I set a "page end" point on a large worksheet?
Dave,
Have you tested this? I did this and it didn't remove the extra rows. Could be user error but I wanted to check anyway. "Dave Peterson" wrote: Visit Debra Dalgleish's site to see a way to reset this last used cell: http://contextures.com/xlfaqApp.html#Unused kpetefaith wrote: I am a fairly new user to Excel. I have created a worksheet with over 200 lines of data. When I use the "control end" shortcut, I end up way down at the end, if you know what I mean. Is there a way to set the end of my page at the actual end of my data? Thanks. -- Dave Peterson . |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I set a "page end" point on a large worksheet?
Yep.
Did you remember to save the workbook. There's a note on that page that some versions require saving (and closing/reopening???). On 05/14/2010 14:43, Nadine wrote: Dave, Have you tested this? I did this and it didn't remove the extra rows. Could be user error but I wanted to check anyway. "Dave Peterson" wrote: Visit Debra Dalgleish's site to see a way to reset this last used cell: http://contextures.com/xlfaqApp.html#Unused kpetefaith wrote: I am a fairly new user to Excel. I have created a worksheet with over 200 lines of data. When I use the "control end" shortcut, I end up way down at the end, if you know what I mean. Is there a way to set the end of my page at the actual end of my data? Thanks. -- Dave Peterson . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Turn off "CALCULATE" on bottom of Excel worksheet. near "Ready" | 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) | |||
| How do I get rid of that large "PAGE 1" thing in Excel? | New Users to Excel | |||
| How to turn off the large text "Page 1" etc, displayed in spreadsh | Excel Discussion (Misc queries) | |||
| Utility to "clean up" or "defrag" large Excel file | Excel Discussion (Misc queries) | |||
Linear Mode
