PDA

View Full Version : Questions about MS Excel


Nicky
22-12-04, 13:38
Hey http://www.tombraiderforums.com/images/smilies/wave.gif

Recently I have started using Excel (MS Office 2003) - only the basics though because there are a couple of things I can't figure out.

One, how do you insert tables in an Excel sheet? I mean, 'real' tables with rows and columns that are visible when you print the document - not the default ones you see while working and that don't appear when you print the sheet. I thought there was going to be an option like in Word - Insert table or sth like that, but I can't find anything :confused: There is an option about inserting a Line or a Column, but again those aren't visible when you print the sheet (I presume they are there just to help you outline your work?)

Two, when I try to erase part of a word or phrase that I have written in a cell, I can't do it. I only got two alternatives: either delete the whole word or phrase and write it again, or overwrite them. Is this normal? :confused:

My instinct says that there must be a certain configuration you have to make in order to work as you want, but I have never ever used Excel in the past and it's literally an uncharted area for me.

Thanks in advance http://www.tombraiderforums.com/images/smilies/smile.gif

Joseph
22-12-04, 15:00
Hi Nicky i only know the answer to your question Two.
You don't change the words IN their cells. To change a word, select it, and see that it is also in the formula-field. That is where you change the word.

http://joseph.tombraiderforums.com/Images/excel-1.gif

Nicky
22-12-04, 17:54
Guess what - I never noticed that bar over there :rolleyes: http://www.tombraiderforums.com/images/smilies/bash.gif

It works, of course :D Thank you, Jo http://www.tombraiderforums.com/images/smilies/smile.gif http://www.tombraiderforums.com/images/smilies/wave.gif

SpArKy
22-12-04, 18:52
Nicky these are my expertise areas! http://www.tombraiderforums.com/images/smilies/jumper.gif

I created a full working online gate ordering system using Excel, fully functioning, for now to make the tables print, you need to outline the cells, "borders", i am just cooking so hold there, and i willl come back to help you further!

SpArKy
22-12-04, 19:10
Applying Borders and Creating Tables.
http://img.photobucket.com/albums/v305/SpArKy18/excel1.jpg

I hope it makes sense!

Ha ha, first two words should be "Hightlight" sorry i am not used to this American Keyboard even though its practically the same!

[ 22. December 2004, 19:11: Message edited by: SpArKy ]

Nicky
22-12-04, 19:17
YES!!! http://www.tombraiderforums.com/images/smilies/jumper.gif Thanks a bunch, Sparky! http://www.tombraiderforums.com/images/smilies/smile.gif

Now why did they hide that button so far away? :rolleyes: http://www.tombraiderforums.com/images/smilies/tongue.gif

Thankies! http://www.tombraiderforums.com/images/smilies/thumb.gif

SpArKy
22-12-04, 22:28
NP any more problems give us a shout. You might have to PM to make sure i see the topic, lol.