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
 
You must log in or register to reply here.

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
Pivot Chart - Excel 2013 - Rotating Second and Third Lines of text onthe Horizontal Axis 0
Horizontal scrolling 2
2 Horizinotal axes in Excel 2007 8

Back
Top