microsoft excel training - Tabs at bottom of worksheet

Resolved · Low Priority · Version Standard

Tabs at bottom of worksheet

Carol has attended:
Excel Introduction course

by - delegate Carol [4 posts] (2008 Jan 2 Wed, 15:47) Reply

Please could you tell me how to create the tabs at the bottom of the worksheets for days, months etc

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Dec 11 Thu + 12 Fri	Bayswater	3	book now	£525	£545
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	7	book now	£450	£475
2003	2009 Jan 22 Thu + 23 Fri	Southwark	4	book now	£475	£485
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	6	book now	£450	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	7	book now	£450	£475
2003	2009 Feb 19 Thu + 20 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 33 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Tabs at bottom of worksheet

by - trainer Rajeev gold contributer [462 posts] (2008 Jan 3 Thu, 12:46) Reply

Dear Carol

I think you have either posted this question in error or may be entered it again providing the course feedback.

A quick tip here for the next time. If you have already asked the question in the forum post then you don’t have to post the question when providing the feedback as it is optional.

I believe I have answered your query in detail in the previous post which appears to be exactly the same question so can I please request you to mark this query as resolved?

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000/2003

· Excel and Inventory Management
· Why Should I Learn Visual Basic in Excel?
· Creating Charts with Excel
· Customized Financial Excel Courses in London
· Excel in the Home Office

Excel tip:

Conditional formatting for cells that return text , not picked up by Go to command

If you have tried to format all cells containing text even those that display text as a result of a formula you may have had difficulty. As Go to command with constant selected does not pick up formulas that result in text.

Then try this. Select the range the formula cells appear in on your sheet. Format, select Conditional Formatting menu. In the dialog box under Condition 1, select "Formula Is" from drop down. Next to it in the Formula Box, enter the formula =Istext(A1. Click Format button , choose desired formatting settings and click OK. To go ahead and apply the conditional formatting click OK to accept

View all Excel hints and tips

Rate this page: