excel document

AI Training: For Busy Decision Makers & Professionals Book now

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel Document

Excel Document

resolvedResolved · Urgent Priority · Version 365

Teresa has attended:
Project Management - Framework & Processes course
Excel Advanced course

Excel Document

I wondered if you could help me with the template I emailed please – particularly in relation to the charging instructions tab.

How can I:


• Activate the data validation option so I can update the drop down menus
• Activate the function to colour red text, to comply with instructions at the bottom of the tab.

How can I also make this document quicker to open?

RE: Excel Document

Hello Teresa,

Thank you for your question and for sending the data file. To update the drop-down lists, you need to go to Data - Data Validation. To see which cells contain data validation rules, go to Home - Find and Select, Data Validation.

I notice that there are certain cells where the validation lists are manually typed into the Data Validation box. You can update these in this box.

Other cells contain lists which are in a hidden sheet named Data. You will need to unhide this sheet and update the lists here. The Data Validation box shows you which ranges contain the lists.

To apply red conditional formatting to text cells, you need to select the cells, then go to Home - Conditional Formatting - Highlight Cell Rules - Text that contains. Here you type the text which should appear in the cells and select a red colour.

Regarding the slow opening of the file, it seems that Excel is struggling to connect and update the links to four external files. It might be worth checking these files and the health of the links. You can see the links in Data - Edit Links.

I hope this helps.

Kind regards
Marius Barnard
STL

Thu 10 Mar 2022: Automatically marked as resolved.

 

Training courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Percentage format

Ctrl+Shift+% applies the Percentage format, with no decimal places.

View all Excel hints and tips


Server loaded in 0.11 secs.