If I have deleted data or even deleted rows at the end of my spreadsheet, then when using the menu item "Edit|GoTo|Special|Lastcell the current cell becomes that maximum number of cells ever used, rather than the last non-blank cell.
Does anyone know how to jump to the last cell containing data?
Does anyone know how to find dependent cells after using the "Trace dependents" button on the Auditing toolbar, when the dependent cells are in another worksheet? (It's fine if they are on the current worksheet, as Excel shows arrows, but if on another sheet, just an icon appears)
Can anyone tell me how to test whether a cell contains a directly input value or a formula so that I can use the test in a conditional format?
e.g. if a cell SHOWS 7, test is it a directly entered 7, or is it the result of a formula say =4+3?
Has anyone had experience in open-pit production drilling/blasting of previously broken ground?
We are working down to expose old, pillar-extracted coal seam workings. The sandstone overburden for about 15metres above the seam is severely fractured due to highly variable subsidence, and has...
Has anyone had experience in open-pit production drilling/blasting of previously broken ground?
We are working down to expose old, pillar-extracted coal seam workings. The sandstone overburden for about 15metres above the seam is severely fractured due to highly variable subsidence, and has...
