Open an Excel Spreadsheet
This is an example of a blank spreadsheet.
The Column headers are "A", "B", "C", etc.
The Row headers are "1", "2", "3", etc.
The Cell that is currently selected is A1
In this example, the "Row #1" is the headers for the individual
columns and the "A" column holds the names of the individual items.
Note that the header name in Column C - "Number of Petals" is
so long that appears to run over and appears to block Column
D. It DOES NOT block Column D. The words merely spill over.
Once you click in cell "D1" you will be able to type.
If your labels are long you can change the style of the cells by having
the text wrap with in each cell and there by keep your cells the same size.
From the menu bar, click on Format. Select Style.
Click on Modify
Select the Alignment Tab.
Put a check mark (click in the box) in the Wrap Text box.
Click OK.
Click OK again to get out of all the dialog boxes.
Your text wrapped columns now look like the above example.
If you do not want to wrap the text but merely
wish to make a column a bit larger
click here for
those instructions.
To add a column in the middle of the spreadsheet, select the column
that you want the new column placed to the left of once it is created.
As an example, let's say you want a column added before Column B
(Color).
You would select the B above the column, the click on the word
Insert
from the menu bar.
Then choose Column
The New Column is now added and all of the columns shifted to
the right.
The same procedure can be used to add rows to the spreadsheet.
To preview what your spreadsheet will look like click on the print
preview button.
In this example there are not gridlines, no page header or page footer.
To change or modify these items, select the Setup.. button.
This tab allows you to change the size or arrangement of the paper.
This tab lets you add gridlines to your document.
This tab lets you add a custom header and footer to your spreadsheet.
Header can be placed in either on the left, center or right side of
the paper
This header is in the center of the page and the font was changed to
a larger size by clicking on the Blue A button above.
Click OK when you have finished.
Click OK again to get ?bONfs3QZ۷,/vxk@vbS1}z-Zd<߱"Ds`Vb'L3W^IիX0n$16q.ڱzZ>Ŝ7Gpn=Y)NlqUa߈/GDƌ"n@~7`ϽdZ0i8XA4 (xN`tzٯYT)'1y
ubáXH:Օsb۰oH*^Rώ SgE*aرb:tӧC:N]Bynd7!)NP:yiK$,6
t1oynt)d;ċDo&~'E7^P
Og=Jf2O'Xl;9ETӪTKc Z