98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel microsoft training - Formatting
excel microsoft training - Formatting
Resolved · Low Priority · Version Standard
Tue 18 Dec 2007, 16:27Delegate Elisabeth said...
Elisabeth has attended:
Excel Intermediate course
PowerPoint Introduction course
Word Advanced course
Formatting
we have spreadsheets at work which have every second line shaded with one colour and every other line shaded with another. when adding new data, how do i keep the formatting without having to highlight every second line?
Tue 18 Dec 2007, 16:59Trainer Rajeev said...
RE: formatting
Dear Elisabeth
Thank you attending Excel and PowerPoint Courses.
I am not very clear about the question but will try to answer to the best of my ability and my understanding.
If I am right you are saying that the table you have has been formatted with two different colours and when you add a new row in between the rows you want to maintain the same formatting!!
The best way to resolve this is by following these steps:
Step 1: Add the new rows and enter the data as usual
Step 2: Select the two rows that have got the two colours (Please ensure that when you select the two rows they must be together).
Step 3: Click on the Format Painter (the little paint Brush on the standard Toolbar next to the Undo Button)
Step 4: Simply select all the rows that you want to apply the formatting to.
NB: Excel will automatically maintain the same formatting i.e. the two colours for every other line (row) because you had selected the two rows with two different colours and it can follow the same pattern all the way!!
Ii hope that is what you wanted to achieve!!
If it is something else then you might want to either provide an example or even upload a sample file for us to have a look at!!
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000/2003
Wed 19 Dec 2007, 11:46Delegate Paul said...
RE: formatting
I have a bit of something to add to this.
You can create a worksheet with alternating coloured rows or columns (striped) with conditional formatting.
First, select the range that you want striped (or the whole sheet).
Next, go to Format/Conditional formatting. In the dropdown where it say value is, select "formula is"
In the textbox on the right type the expression "= mod(row(),2)=0" (without the quotes, of course.)
Finally, set the format that will apply to even rows.
You can vary the frequency of the stripe by using a value other than 2 in the mod function. If you want odd rows rather than even rows to be formatted, change the 0 to 1.
To have columns stripey, change the word 'row' to the word 'column'
Then you can add another conditional format to the same range of cells and the odd rows.
Maybe this will help aswell/instead?
Paul
Fri 21 Dec 2007, 10:55Delegate Elisabeth said...
RE: formatting
that's exactly what i wanted to achieve - many thanks Rajeev!!
Elisabeth
Sun 30 Dec 2007, 21:01Trainer Rajeev said...
RE: formatting
You're Welcome Elizebeth!!
I am glad that I could be of some assistance!!
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000/2003
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Random NumbersType =RAND()*200 to generate a number between 1 and 200. |
