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 » Dynamic Tables
Dynamic Tables
Resolved · Low Priority · Version 2016
Wed 2 Oct 2019, 17:32Delegate Mike said...
Mike has attended:
Excel Intermediate course
Project Introduction course
Dynamic Tables
Hi
I am trying to add additional information into a table, but it will not accept it in the correct format, can someone give me a call please?
Kind regards
Mike
Thu 3 Oct 2019, 10:56Trainer Claire said...
RE: Dynamic Tables
Hi Mike,
Can you give me a bit more information on what's not working with the format?
Is it colour format or number format?
Whatever number format you put on the body of the table will continue down the rows as new information is added. For instance date formatting or currency information. Also conditional formatting will down the table too.
Do you have the formatting as you want it on the very first row below the header row?
thanks
Claire
Mon 14 Oct 2019, 16:18Trainer Sarah said...
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
Tue 15 Oct 2019, 20:06Delegate Mike said...
RE: Dynamic Tables
Hi it is about the set up tables - i really need to speak to someone as it is impossible to talk over messages!
Wed 16 Oct 2019, 11:38Trainer Richard said...
RE: Dynamic Tables
Hi Mike
Thank you for your patience Mike.
Under Section 5 - Working with Tables from the manual you receive on the Intermediate course it does run through a check on Tables.
Please ensure there are no gaps/blank rows and the blue triangle in the bottom corner is dragged to include the new data.
Without further information as Claire requested it's hard to know what you've tried and therefore what the root cause actually is.
I appreciate it's harder to explain by a message and for the majority of questions we receive this forum is a fit for purpose tool. The complimentary support for two years you receive is through this forum and doesn't include telephone/remote support.
If you can drop an email to Info@STL-Training.co.uk, we can get your account manager to give you a call and talk through how we can support you further. I hope that's going to help you progress your solution
Kind regards
Richard Bailey
Head of Learning
Mon 21 Oct 2019, 10:44Trainer Claire said...
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
Mon 28 Oct 2019: 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:Do a fast scrollIn big Excel databases with many records, you can move down thousands of rows super-fast as follows: hold down Shift then click on the scrollbar somewhere below the scrollbar handle. This will move you way down the sheet without your having to use the scrollbar up/down arrows or drag on the scrollbar handle. |
