Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set the last cell in a worksheet?
I have a worksheet that fills to column L down to row 175. The last cell in
the worksheet goes out to T 40912. This workbook saved is 2.6 MB. I want to set the last cell closer to the end of my work. How do I set the last cell in the workbook/worksheet? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set the last cell in a worksheet?
The typical approach is to DELETE the rows and columns that are beyond the
last used cell you want to set. Then save the file. Depending on your version of Excel, you may need to close and re-open the workbook Does that help? *********** Regards, Ron XL2002, WinXP "Dave B" wrote: I have a worksheet that fills to column L down to row 175. The last cell in the worksheet goes out to T 40912. This workbook saved is 2.6 MB. I want to set the last cell closer to the end of my work. How do I set the last cell in the workbook/worksheet? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set the last cell in a worksheet?
Thank you Ron! Very simple yet spent hours trying to do by myself. Thanks
again! "Ron Coderre" wrote: The typical approach is to DELETE the rows and columns that are beyond the last used cell you want to set. Then save the file. Depending on your version of Excel, you may need to close and re-open the workbook Does that help? *********** Regards, Ron XL2002, WinXP "Dave B" wrote: I have a worksheet that fills to column L down to row 175. The last cell in the worksheet goes out to T 40912. This workbook saved is 2.6 MB. I want to set the last cell closer to the end of my work. How do I set the last cell in the workbook/worksheet? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set the last cell in a worksheet?
Hi, here is the link for VBA Code to set last cell:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=83 I have tried it works most of the time... Helps when there are many sheets in the book, it takes lot of time efforts to go to each sheet n set the last cell mannually... "Dave B" wrote: Thank you Ron! Very simple yet spent hours trying to do by myself. Thanks again! "Ron Coderre" wrote: The typical approach is to DELETE the rows and columns that are beyond the last used cell you want to set. Then save the file. Depending on your version of Excel, you may need to close and re-open the workbook Does that help? *********** Regards, Ron XL2002, WinXP "Dave B" wrote: I have a worksheet that fills to column L down to row 175. The last cell in the worksheet goes out to T 40912. This workbook saved is 2.6 MB. I want to set the last cell closer to the end of my work. How do I set the last cell in the workbook/worksheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How:Add New Worksheet that copies the cell of the previous sheet | Excel Worksheet Functions | |||
How do I get ONLY new info from 1 Worksheet to another automatical | Excel Worksheet Functions | |||
fill cell with color from other worksheet | Excel Discussion (Misc queries) | |||
Conversion of Cell Contents into a Functional Worksheet name ? | Excel Worksheet Functions | |||
Refrencing another cell in a worksheet that "could" exist | Excel Worksheet Functions |