how to center excel sheet horizontally and verticaly on page?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How to center excel sheet vertically or horizontally on a page ?

Also how to change grid colours in excel ?

Thanks
 
File/Page Setup/Margins, and tick the centre vertically and horizontally.

For grid line colours

Tools/options/View select colour in gridline colour dropdown box.

HTH
Michael M
 
Hello fitzbest,

To center the worksheet data horizontally and vertically fo
printing...

On the main menu click File > Page Setup > Margins
Check the boxes at the bottom labeled Horizontally and Vertically

To change the Gridline Color...

On the main menu click Tools > Options > View
At the bottom there is a drop down labeled Colors. Click ot to see th
available colors and click on the one you want.

Sincerely,
Leith Ros
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Configuration of cells 5
Vertical centering not functioning for print 1
How to Convert same horizontal row to vertical row in Excel? 3
Is it possible to use the mouse wheel to scroll horizontally? 1
Missing sheet tabs and horizontal scroll bar 1
Horizontal scrolling 2
Pivot Chart - Excel 2013 - Rotating Second and Third Lines of text onthe Horizontal Axis 0
2 Horizinotal axes in Excel 2007 8

Back
Top