Friday, July 22, 2011

How to Align Double


1. Create a new Excel 2007 spreadsheet from the circular 'Office' tab of the Ribbon. Select 'New' and then 'Blank Workbook' to create a new, blank spreadsheet. Save your document as an Excel 2007 file format from the 'Save As' button from the 'Office' tab.
2. Switch to 'Page Layout' view from the 'View' tab of the Ribbon. Page Layout view allows you to see the parameters of your print document including margins, column width and row height. It also allows you to view the alignment of your cells to prepare them as tags.
3. Right-click the column header and select 'Column Width' to input your tag width. Type the width of your tag in inches, centimeters or millimeters by entering the appropriate units after the value. For example, to make a tag that is two inches wide, input '2in' without the quotation marks.
4. Right-click the row header to the left of the screen and select 'Row Height' to input the height of your tag. Type the height of your tag followed by the appropriate units. Create duplicate cell parameters in the adjacent cells so that when you print, you can fold your tag in half or cut and reverse it to create a double-sided tag.
5. Highlight your cells and click the 'Home' tab of the Ribbon. Click the 'Borders' button from the Font area and select 'All Borders.' Borders will show you the alignment of each tag after you print your document.

Blogger news