Gridlines - Yes or No?

In Excel there are gridlines and gridlines. You can display them on the screen as you work or on the printouts or both or neither.

Confusing?

To display or hide gridlines as you work, choose Tools, Options, View tab and enable or disable Gridlines.

For printing, choose File, Page Setup, Sheet tab and enable or disable Gridlines for printing...

Now you know.

Hide or color Excel gridlines

Ok, grey is my favourite colour - it's the colour of my old school uniform. I'm an Aussie and we still wear uniforms to school! Mine was grey serge in winter and grey cotton in summer, complete with hats and gloves. I kid you not and this is seriously OT and it uses Australian spelling so I'll get back to what I was saying.

Ok, so gray might be my favorite color but it's probably not yours. If Excel's gray gridlines offend your color sense, you can change them or remove them entirely. To remove them choose Tool, Options, View tab and disable the Gridlines checkbox.

To change the color of the lines, choose Tool, Options, View tab and choose an alternate color from the Gridlines color dropdown list. If you didn't realise gridlines were little dots and not solid lines, you're about to see that that's exactly what they are.

Align anything in Word

When you want to make sure everything on a Word page lines up properly, display the gridlines.

To do this, first display the Drawing toolbar then choose Draw, Grid and choose the Display gridlines on screen checkbox. Set the Use Margins option to start the grid aligned on the left and top margins. Set the value to 1 for small squares and to 2 or 3 for a larger grid.

If you select the Snap Objects to Grid checkbox all objects will automatically line up against the grid.

If you don't want this to be the case, press the Alt key as you drag an object and it will be freed from snapping to align to the grid.