Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Last cell in worksheet
I only wanted the first 66 rows of a file, so I highlighted and deleted rows
67 - 126. If I use ctr-end (or go-to last cell) it takes me to R126. How can i find out what is in that cell? Excel 2003, Windows Prof 2000 thanks dp |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Last cell in worksheet
After I logged on here and posted, I returned to this file and now I get the
correct last cell. Did it just take 5 minutes or so for the changes to register? Still trying to catch on! dp "dp" wrote: I only wanted the first 66 rows of a file, so I highlighted and deleted rows 67 - 126. If I use ctr-end (or go-to last cell) it takes me to R126. How can i find out what is in that cell? Excel 2003, Windows Prof 2000 thanks dp |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Last cell in worksheet
When you save your workbook, the last cell is refreshed from row 126 to row 66.
-- Hope this helps. If this post was helpfull, please remember to click on the ''''YES'''' button at the bottom of the screen. Thanks, Gary Brown "dp" wrote: After I logged on here and posted, I returned to this file and now I get the correct last cell. Did it just take 5 minutes or so for the changes to register? Still trying to catch on! dp "dp" wrote: I only wanted the first 66 rows of a file, so I highlighted and deleted rows 67 - 126. If I use ctr-end (or go-to last cell) it takes me to R126. How can i find out what is in that cell? Excel 2003, Windows Prof 2000 thanks dp |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Last cell in worksheet
When you save your workbook, the last cell is refreshed from row 126 to row 66.
Not in every version, sometimes you must close/reopen the file See also this page if you want to use code http://www.rondebruin.nl/last.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Gary Brown" wrote in message ... When you save your workbook, the last cell is refreshed from row 126 to row 66. -- Hope this helps. If this post was helpfull, please remember to click on the ''''YES'''' button at the bottom of the screen. Thanks, Gary Brown "dp" wrote: After I logged on here and posted, I returned to this file and now I get the correct last cell. Did it just take 5 minutes or so for the changes to register? Still trying to catch on! dp "dp" wrote: I only wanted the first 66 rows of a file, so I highlighted and deleted rows 67 - 126. If I use ctr-end (or go-to last cell) it takes me to R126. How can i find out what is in that cell? Excel 2003, Windows Prof 2000 thanks dp |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Last cell in worksheet
I believe the necessity for that action Ron, goes way back to XL97, or *PRE*
XL97! -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Ron de Bruin" wrote in message ... When you save your workbook, the last cell is refreshed from row 126 to row 66. Not in every version, sometimes you must close/reopen the file See also this page if you want to use code http://www.rondebruin.nl/last.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Gary Brown" wrote in message ... When you save your workbook, the last cell is refreshed from row 126 to row 66. -- Hope this helps. If this post was helpfull, please remember to click on the ''''YES'''' button at the bottom of the screen. Thanks, Gary Brown "dp" wrote: After I logged on here and posted, I returned to this file and now I get the correct last cell. Did it just take 5 minutes or so for the changes to register? Still trying to catch on! dp "dp" wrote: I only wanted the first 66 rows of a file, so I highlighted and deleted rows 67 - 126. If I use ctr-end (or go-to last cell) it takes me to R126. How can i find out what is in that cell? Excel 2003, Windows Prof 2000 thanks dp |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to name worksheet tabs using a cell within the worksheet? | Excel Discussion (Misc queries) | |||
populate cell on worksheet 2 if text is red on worksheet 1 | Excel Worksheet Functions | |||
Variable worksheet name (tab) linked to cell in same worksheet | Excel Worksheet Functions | |||
How can I link cell colours from worksheet to worksheet/workbook? | Excel Worksheet Functions | |||
Worksheet reference (i.e placing worksheet name in a cell) | Excel Worksheet Functions |