Hi, I am a newbie when it comes to using excel. I know nothing about codes or
formatting, or even the right terminology for each box/section/row (I hope i
chose the right discussion group for this)
Right now, I am using excel in a very simple way. I have a list of columns
across the top that go from A to P, each with a different heading. Then down
on the left, I am up to line 190. I am not doing any calculations, only text
like names, ph #'s, email address, contact info, notes, dates, etc.
1) how far down do you go before switching to sheet 2 or 3?
2) how much info is too much for one excel sheet?
3)how do i either:
a) color code the entire row (eg. line 5, A - P) without seperately
configuring each column (A - P) with it's own color? [I've been right
clicking on a box (eg. A5), clicking "format cells", then "patterns", then
choosing a color, then copying and pasting it all the way down in the boxes i
want it, and repeating these steps for columns B - P]
b) color code alternate lines for easy visibility? [note: i found out how to
highlight every 2nd row, but this does not help me, as some sections are 2
rows down, some are 3, 4, etc.] eg A-P lines 18-19 is one grouping, whereas
A-P lines 21-25 is another.
Sorry, I hope this makes sense to someone. I tried to be as exact as possible.
D
Bookmarks