Hi can someone help me-when you open up a new workbook the sheet has pale blue cell and row lines these do not print inless you elect to show gridlines in page setup-my issues is -I have managed to delete some of those lines in the workbook I am using- I have tried various methods to reinsert the lines but the sheet is half blank and when I insert gridlines in print preview they are still blank??
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Missing Cell and row lines in a workbook
- Thread starter Muffy123
- Start date
Michael M
Well-known Member
- Joined
- Oct 27, 2005
- Messages
- 21,895
- Office Version
- 365
- 2019
- 2013
- 2007
- Platform
- Windows
I don't quite follow your problem.
Is there a macro that has been run on startup to get to this state ?
What version of Excel are you using ?
If on Excel 07 or higher, try going to the Home button and then selecting Excel Options.
Choose "Advanced" and then scroll down to "Display Options for this worksheet"
Have a look at Gridline color and whether "Show gridlines" is checked.
Is there a macro that has been run on startup to get to this state ?
What version of Excel are you using ?
If on Excel 07 or higher, try going to the Home button and then selecting Excel Options.
Choose "Advanced" and then scroll down to "Display Options for this worksheet"
Have a look at Gridline color and whether "Show gridlines" is checked.
Upvote
0
