Although Excel 2007 is not a word processor, you may need to centre your worksheet's contents from time to time. When you add content to a worksheet in Excel 2007, the information is left-justified by default. Choose to centre your worksheet horizontally from page to page instead. The centring is applied to the selected worksheet alone. So, if you want to centre each worksheet in your workbook, you'll need to select and format those worksheets as well.
- Skill level:
Select the Office Button and click "Open." Double-click the file you want to modify in the "Open" dialogue box. It loads on your page.
Select the worksheet you want to align in the workbook. To centre each worksheet in your file, right-click on any worksheet tab (at the bottom of your page) and choose "Select All Sheets" from the pop-up list.
Select the "Page Layout" tab. Click the arrow on the right of the "Page Setup" group.
Select the "Margins" tab in the "Page Setup" dialogue box.
Go to the "Center on page" section and check "Horizontally." Click "OK."
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for