Dunstan has attended:
Excel Introduction course
Excel Intermediate course
Excel spreadsheet
On excel I have a trial balance I have not got sheet 1 which comes under the formula FX. I cannot edit the trial balance based on not having sheet 1. How can I edit the balance sheet?
My Email Address is dnicolwilson2000@aol.com
I can send a screenshot through email.
RE: Excel spreadsheet
Hi Dunstan,
Thank you for the forum question.
If your functions get the values from sheet 1 to your trial balance the values must be changed in sheet 1. Otherwise you will have to overwrite the function and ruin the worksheet.
Something tells me that your sheet 1 is hidden. Try to right click on a sheet tab at the bottom of the workbook and see if you have the option to unhide.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
