Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Setting the end of a sheet
I am having trouble setting the last cell on a sheet. When I press CTRL+END
cell BI65537 is selected, I want it to go to cell I150. How do I do this? It is probably the easiest question but it has been bugging me for an hour!! Thanks, Jane |
#2
|
|||
|
|||
Perhaps there is formatting in the rows. Try selecting rows 151:65536 and go
to Edit-Delete (not just hitting the Delete key), then click in row 150 (or above), save the file, close the file, and reopen the file. Any difference? "JaneC" wrote: I am having trouble setting the last cell on a sheet. When I press CTRL+END cell BI65537 is selected, I want it to go to cell I150. How do I do this? It is probably the easiest question but it has been bugging me for an hour!! Thanks, Jane |
#3
|
|||
|
|||
Reset the used range. See http://www.contextures.com/xlfaqApp.html#Unused
for details. -- HTH RP (remove nothere from the email address if mailing direct) "Nick B" wrote in message ... Perhaps there is formatting in the rows. Try selecting rows 151:65536 and go to Edit-Delete (not just hitting the Delete key), then click in row 150 (or above), save the file, close the file, and reopen the file. Any difference? "JaneC" wrote: I am having trouble setting the last cell on a sheet. When I press CTRL+END cell BI65537 is selected, I want it to go to cell I150. How do I do this? It is probably the easiest question but it has been bugging me for an hour!! Thanks, Jane |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
Dynamic Formulas with Dynamic Ranges | Excel Worksheet Functions | |||
Setting up a macro to print? | Excel Worksheet Functions | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |