How do you get rid of page number on an excel worksheet?
Note:- this is not a header or footer. I am working on a worksheet started by someone else, and on every sheet the background has 'Page 1' in big letters. I have looked at formatting cells and there is nothing in there. I have also looking at editing background picture under 'format' - that hasn't worked either. If you have experienced this before, please help (its urgent), thanks.
You are probably in Page break Preview mode. Select View menu and select Normal. This will make the numbers disappear.
June 18th, 2009 at 12:33 pm
It is most likely a shape. If you don't have any shapes in the worksheet that you want to keep, then add this code to the worksheet in the VBAProject (press Alt+F11 to view code, double click on the name of the worksheet, and paste the code in the big window.
Sub DeleteShapes()
Do While Shapes.Count > 0
Shapes(1).Delete
Loop
End Sub
Place the cursor anywhere in the pasted code and press F5 to delete all shapes or press F8 repeatedly to step through the code.
If the page number is not gone, change Shapes to Pictures in the code and run that.
If there are shapes that you don't want to delete, let me know via email or by adding detail to the question and I can suggest ways to selectively delete shapes.
The code can be deleted or left where it is when you are done with it.
Good Luck
References :
June 18th, 2009 at 1:23 pm
You are probably in Page break Preview mode. Select View menu and select Normal. This will make the numbers disappear.
References :