Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to limit number of rows Excel?
I want to be able to hit "end of page" (CTRL END) and have it go no further
than row 100 and column AZ but i cannot figure out how to do it. |
#2
|
|||
|
|||
Ctrl end takes you to the bottom right hand of your sheet. If you have data
extending beyond that, Ctrl End will take you beyond that. Try Ctrl G, type in AZ100 and hit Enter "Surreal" wrote: I want to be able to hit "end of page" (CTRL END) and have it go no further than row 100 and column AZ but i cannot figure out how to do it. |
#3
|
|||
|
|||
sorry, you can also record a little macro, assign something like Ctrl e as
shortcut key, and in this way go there. Sub Macro1() Application.Goto Reference:="R100C52" End Sub "Surreal" wrote: I want to be able to hit "end of page" (CTRL END) and have it go no further than row 100 and column AZ but i cannot figure out how to do it. |
#4
|
|||
|
|||
If you're going to far to the right or too far down, it could be because excel
sees your used range as more than you see it. Debra Dalgleish has some techniques for resetting the last used cell at: http://www.contextures.com/xlfaqApp.html#Unused Surreal wrote: I want to be able to hit "end of page" (CTRL END) and have it go no further than row 100 and column AZ but i cannot figure out how to do it. -- Dave Peterson |
#5
|
|||
|
|||
On Tue, 15 Mar 2005 04:29:04 -0800, "Surreal"
wrote: I want to be able to hit "end of page" (CTRL END) and have it go no further than row 100 and column AZ but i cannot figure out how to do it. You can hide the rows and columns you won't be using. Just select (place your cursor in the beginnging row to hide) hold down the shift key and press end+down arrow. Then format / rows / hide. Do the same for columns. I use this a lot to define where my worksheets stop so I don't go paging all over the place for data not in view. Don S |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
How do I unhide rows 1 through 28 on an Excel worksheet? | Excel Worksheet Functions | |||
How do I pick a number from a list in Excel? | Excel Worksheet Functions | |||
Does Excel 2000 have a 'datedif' function to calculate the number. | Excel Worksheet Functions | |||
Can the number of times undo is used in Excel 2002 be increased? | Setting up and Configuration of Excel |