I need help with something...and I dont know anything but basic stuff about excel
I am making my guest list tracker and i have it like color coded and divided with lines but it wont let me do that past # 41!!
Jesaroo2
Posted:
Member since
Re: anyone really good at excel???
Posted by NC1011
Really I don't know why it didnt work for you - must have been a fluke thing. All I did was hi-light the section missing borders and then select the borders option and added them in. Sometimes if a worksheet I'm working in gives me problems, I just copy and paste the data into another worksheet to see if that makes a difference. I've never seen that before tho so I wish I could offer better advice I'm glad I could fix it for you tho
where is the borders option? maybe i was clicking the wrong thing
thank you so much for your help
Mici n KC
Posted:
Member since
Re: anyone really good at excel???
Posted by Jesaroo2
Posted by Mici n KC
Posted by Jesaroo2
Posted by Mici n KC
So you know for future is to make the boxes. There's a little icon at the top that can have a __ or 2 lines or a box. That's what you need to use.
hm ok let me look...what icon is that?
On my excel it's next to the paint can.
I dont have that lol
It's called borders. It can also be done by going to Format then Cells then you'll see a tab for borders. That's how you can create grids or just lines.
Jesaroo2
Posted:
Member since
Re: anyone really good at excel???
Posted by Coach416
let me know if you have any trouble opening up the file
LOL the one you sent me is the one I am using!!!!!
I love it
thank you!!!!
NC1011
Posted:
Member since
Re: anyone really good at excel???
Posted by Jesaroo2
Posted by NC1011
Really I don't know why it didnt work for you - must have been a fluke thing. All I did was hi-light the section missing borders and then select the borders option and added them in. Sometimes if a worksheet I'm working in gives me problems, I just copy and paste the data into another worksheet to see if that makes a difference. I've never seen that before tho so I wish I could offer better advice I'm glad I could fix it for you tho
where is the borders option? maybe i was clicking the wrong thing
thank you so much for your help
There are a few ways to get to it, for me I hi-lite the cells I want to format and then right-click the mouse and choose 'format cells' and then click on the 'borders' tab and then you just select what you want - I'm a big fan of right-clicking
ETA - there is also a drop down menu once you get to the borders option that allows you to select line thickness and color
Jesaroo2
Posted:
Member since
Re: anyone really good at excel???
Posted by Jesaroo2
Posted by NC1011
Really I don't know why it didnt work for you - must have been a fluke thing. All I did was hi-light the section missing borders and then select the borders option and added them in. Sometimes if a worksheet I'm working in gives me problems, I just copy and paste the data into another worksheet to see if that makes a difference. I've never seen that before tho so I wish I could offer better advice I'm glad I could fix it for you tho
where is the borders option? maybe i was clicking the wrong thing
thank you so much for your help
nevermind im an idiot I just did it LOL
thank you again
Jesaroo2
Posted:
Member since
Re: anyone really good at excel???
Posted by Mici n KC
Posted by Jesaroo2
Posted by Mici n KC
Posted by Jesaroo2
Posted by Mici n KC
So you know for future is to make the boxes. There's a little icon at the top that can have a __ or 2 lines or a box. That's what you need to use.
hm ok let me look...what icon is that?
On my excel it's next to the paint can.
I dont have that lol
It's called borders. It can also be done by going to Format then Cells then you'll see a tab for borders. That's how you can create grids or just lines.
thank you girls so much!!!!!
Jesaroo2
Posted:
Member since
Re: anyone really good at excel???
okay one more dumb question. When I go to print it doesnt print across fully like it will come out the left half on 1 page and right on the 2nd. is there anyway to make it printer friendly?
NC1011
Posted:
Member since
Re: anyone really good at excel???
Posted by Jesaroo2
Posted by Jesaroo2
Posted by NC1011
Really I don't know why it didnt work for you - must have been a fluke thing. All I did was hi-light the section missing borders and then select the borders option and added them in. Sometimes if a worksheet I'm working in gives me problems, I just copy and paste the data into another worksheet to see if that makes a difference. I've never seen that before tho so I wish I could offer better advice I'm glad I could fix it for you tho
where is the borders option? maybe i was clicking the wrong thing
thank you so much for your help
nevermind im an idiot I just did it LOL
thank you again
Not a problem at all! Glad I could help. Off to dinner with the parents now!!! Nighty night!
Jesaroo2
Posted:
Member since
Re: anyone really good at excel???
Posted by NC1011
Posted by Jesaroo2
Posted by Jesaroo2
Posted by NC1011
Really I don't know why it didnt work for you - must have been a fluke thing. All I did was hi-light the section missing borders and then select the borders option and added them in. Sometimes if a worksheet I'm working in gives me problems, I just copy and paste the data into another worksheet to see if that makes a difference. I've never seen that before tho so I wish I could offer better advice I'm glad I could fix it for you tho
where is the borders option? maybe i was clicking the wrong thing
thank you so much for your help
nevermind im an idiot I just did it LOL
thank you again
night!
Not a problem at all! Glad I could help. Off to dinner with the parents now!!! Nighty night!
NC1011
Posted:
Member since
Re: anyone really good at excel???
You need to change the margins - go to file - page setup - and then click on the margins tab - from there you can click and drag the margins to where you want. Another option is to go to page setup and on the first tab have it drop from 100% to a lower percentage until it is all on one page. Also, you should change the page layout to landscape to give yourself more room. All of this is down on the page setup tab.
HTH
Mici n KC
Posted:
Member since
Re: anyone really good at excel???
Posted by Jesaroo2
okay one more dumb question. When I go to print it doesnt print across fully like it will come out the left half on 1 page and right on the 2nd. is there anyway to make it printer friendly?
Yes, you have to go to the page setup to fix this. It gives you the option to print on one page. It is most likely set up as portrait so you may want to change it to landscape. You just want the width to fit on the page so you can actually have more than one page.
Kricket212
Posted:
Member since
Re: anyone really good at excel???
YEAH!! I stink at excel too.
Jesaroo2
Posted:
Member since
Re: anyone really good at excel???
OMG I hate excel so I finally got it all set up and I go to print it and only two colums are printing!!!!! why?!?!?!?!?!
snowcutie82
Posted:
Member since
Re: anyone really good at excel???
if its all set up try selecting the entire space u want to print (use the mouse and click from the bottom and the last cell and move the mouse across until everything u want to print is in blue)
then file - print area - set print area
hopefully that works.
Jesaroo2
Posted:
Member since
Re: anyone really good at excel???
is anyone on that I can send my spreadsheet 2? I tried everything you girls said to print but it only print the first two boxes on line one. I am getting so frustrated! HELP
Celest
Posted:
Member since
Re: anyone really good at excel???
Posted by Jesaroo2
is anyone on that I can send my spreadsheet 2? I tried everything you girls said to print but it only print the first two boxes on line one. I am getting so frustrated! HELP
You can send it to me if you want to fix. FM me your email address so i can reply to with mine if you want
Celest
Posted:
Member since
Re: anyone really good at excel???
Hey hon if you are still up I sent you the file fixed up. Hope that helps catch you later
