98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel Document
Excel Document
Resolved · 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 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:Percentage formatCtrl+Shift+% applies the Percentage format, with no decimal places. |