Excell Help

[sheepdog 10]

After numerous attempts to open my old pups on hand file that I lost with my old computer, I have given up and decided to just try to make a new one. But now I find I don't know how to work excell, and I'm not even sure how I made the old one to start with either. Anyway, I need to figure out in excell how to make one. I can't figure out how to loose the A B C's across the top and turn them into the right headers, and I can't figure out how to loose the extra colums I don't need. I only need 6 colums. I do need the numbers down the left side, just need to replace the A with breed, B with Sex, C with sire/dam etc. I also need to put text or numbers in the fields.

[mahesh2k 0]

If you are new to spreadsheets in excel thencheck this. For adding and deleting columns and rows, check this. There is some good info about usage of spreadsheet in this site and you will get answers to most of your questions. Check this site for microsoft excel tutorialin pdf format also check this. Hope this helps for starters and if not post again to let us know what you want more or anything different.

[sheepdog 10]

Thanks. I read threw it all, so I am begining to think I can't do what I want in Excell. I highlight and delete colums and they just pop right back in. I was hoping to replace the A B C'S with my own headers. If I put my headers in one of the rows, that throws the numbers off, I want to see at a glance how many litters I have. And it won't let me enter dates the way I want them. I want 2/2 not 2 Feb. Arrrrgh. I wish I could get past this.

[web_designer 7]

Thanks. I read threw it all, so I am begining to think I can't do what I want in Excell. I highlight and delete colums and they just pop right back in. I was hoping to replace the A B C'S with my own headers. If I put my headers in one of the rows, that throws the numbers off, I want to see at a glance how many litters I have. And it won't let me enter dates the way I want them. I want 2/2 not 2 Feb. Arrrrgh. I wish I could get past this.

my dear sheepdog, the columns A,B,C,D and the rows 1,2,3 are only a way to help you to arrange your document. but they never appear when you print your document, any you can see that if you clicked on the "print" icon from the toolbar or "print preview" from file tab. so if you want to add a header to your document just write what you want under the columns, for example if you wrote under the column A, this means you are typing the header for your first column, and if you wrote under the column B that means you are typing the header for your second column and so on...

and about the date you can change it from format> style> modify> date
from date choose the one you want. and by the way i use microsoft office 2003, a little bit old but easy to use.

please feel free to ask me if you want any further help or pm me. i hope i helped you a little, good luck.

[sheepdog 10]

and about the date you can change it from format> style> modify> date

COOL. At least I got that fixed!

I seldom print this, I just use it on the computer, I nearly always have it open in my system tray (isn't that what the row is caled across the bottom of my computer screeen?) It would just be easier if I didn't have to look at all the blank colums, or the A B C's or header taking up the numbers.
( I do occasionally print it out, in case of computer crash, or power failure, just to have it handy)

My own version is 2000, so your's isn't so old after all. And now I have discovered something else, I don't seem to be able to drag lines up or down. I need to be able to delete lines when pups are sold, and then drag up the others to avoid blank rows.
Edited October 8, 2010 by sheepdog (see edit history)

[web_designer 7]

COOL. At least I got that fixed!

 

I seldom print this, I just use it on the computer, I nearly always have it open in my system tray (isn't that what the row is caled across the bottom of my computer screeen?) It would just be easier if I didn't have to look at all the blank colums, or the A B C's or header taking up the numbers.

( I do occasionally print it out, in case of computer crash, or power failure, just to have it handy)

 

My own version is 2000, so your's isn't so old after all. And now I have discovered something else, I don't seem to be able to drag lines up or down. I need to be able to delete lines when pups are sold, and then drag up the others to avoid blank rows.

 

now believe me it is not that hard, i mean about the A,B,C'S columns. just fill your data under them and don't think of them and everything gonna be fine .

 

to be able to delete when pups are sold. just click on the cell (one click not double click because we don't want to delete or change the contents of a certain cell but to delete it all). again, click on the line you want to delete> right click> delete> entire row> ok.

and the same if you want to delete the entire columns or shifting cells.

 

now i will give you some more useful tips to arrange your document:

 

- to add a title to your document:

click on the first cell, usually (A1) i mean the column A and the row 1 and write for example ( sheepdog pet shop)> click again on the cell when you wrote the title and drag the mouse till the column F to highlight all the cells from column A to F> in the toolbar search for this icon (merge and center)

 

 

click on this icon and voila, you will have a header title to your whole document.

 

- formatting your header title:

click on your title's cell> right click> format cells> font> make it bold,18,green.

and you can add border too from border tab.now you have a title header in different color.

 

- adding numbers to the left side of the document:

instead of typing numbers one by one there is an easier way in excel

in cell (A2) again i mean column A and row 2 since row one is used before for the title> type 1> in cell (A3) type 2> and here is the magic, highlight both of the cells (that contain 1 and 2) and put your cursor on the right bottom corner then you can see that the cursor turned from thick plus sign or white cross to a thin plus sign or black plus> now drag it to row A26 , to get a list of numbers for your rows from (1-25), and every time you need to add more, just highlight the last two cells for example cells (A25 AND A26) to adjust the amount of increment you want and drag it to the desired number of the rows and it won't begin from 1 again but will add row's number to them.

 

also to arrange your document you can narrow the numbers column ( in this case column A) by putting your cursor on the border of cell A and drag it to the left a little.

 

and of course you can change the font format and color of the numbers by highlight all cells from A2 to A26> right click> format cells> from font tab choose font size 12 and color blue.

 

- let's say that i forgot to add headers to each column to identify what my columns about, so let's say i want to add these headers:

no., pup name, pup size, pup family, price and details

 

and of course those should be under the title so we should add a whole new row after the title header:

click on cell (A2)> right click> insert> entire row> ok

now you can see that everything is shifting one row down

 

so start typing the columns headers (no., pup name, pup size, pup family, price, details).

and formatting them as we did before

highlight all the header cells (from A2 to E2)> right click>format cells> from font tab choose bold, 16, blue> and from border tab choose outline border and also blue.

from pattern tab choose a cell shade i picked a light gray shed.

 

and then from each column border drag them right or left to give each column the required space.

 

now your document will look like this

 

 

and in print preview will look like this, by the way, i use print preview even when i don't want to print the document. i use it to make sure that my document looks fine.

 

 

 

- if you want to add an overall border to the whole document:

select or highlight your cells (from A1 to F27)> right click> cell format> in border tab choose outline and inside border.

 

and here is how it will look like

 

 

- to add a special format to overall document:

select your whole rows and columns like before, (from A1 to F27)> from menu bar> format>auto format> and choose any one you want i took classic2

 

- if you have a lot of columns and it looks cut off in print preview, you can change the paper size from portrait to landscap

from menu bar> file> page setup>from page tab click on landscap instead of portrait.

 

that's all the necessary things i think you have to know, i hope you will have fun trying them, good luck .