Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Marking page end
how do i mark the last used cell as page end, my spreadsheet goes down to row
26661 and across to BU. We are currently only up to line 3660 row Z |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Marking page end
On Oct 5, 10:40 pm, lucy wrote:
how do i mark the last used cell as page end, my spreadsheet goes down to row 26661 and across to BU. We are currently only up to line 3660 row Z What are you looking for? You can probably set the PrintArea dynamically if you want easy printing. Or if you want the last cell automatically highlighted or Named (so you can find it easily) in some way, a macro or UDF can do it. You could also set the PrintArea manually pretty fast if you know the shortcuts to manuvering around a spreadsheet. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Marking page end
Delete...........do not clear contents...........all rows and columns below
and right of the actual range of data. Then SAVE the workbook to reset the used range. To do it with code See Debra Dalgleish's site. http://www.contextures.on.ca/xlfaqApp.html#Unused Gord Dibben MS Excel MVP On Sun, 5 Oct 2008 20:40:00 -0700, lucy wrote: how do i mark the last used cell as page end, my spreadsheet goes down to row 26661 and across to BU. We are currently only up to line 3660 row Z |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Marking up pricing | Excel Discussion (Misc queries) | |||
sum limit and marking | Excel Worksheet Functions | |||
Marking rows | Excel Discussion (Misc queries) | |||
Marking Duplicates | Excel Worksheet Functions | |||
coloured marking | New Users to Excel |