need a ''professional ''excel specialised to help
Discussion
hi i have an excel spred sheet which has hidden formulars and hidden cololms which buttons relate to...i need to modifie it and cant... it s not locked.
im a dab hand at excel but not a professional at it..it needs someone who does it as a job or has studied it.any helpers out there please
thanks dom
im a dab hand at excel but not a professional at it..it needs someone who does it as a job or has studied it.any helpers out there please
thanks dom
If the columns are hidden, it should be simply a case of 'select all', unhide columns.
The buttons might relate to macros, not formulae. If this is the case, I would suggest that you don't try and mess with them unless you know your way around visual basic. Or can recreate the macros from scratch (which may not be that difficult).
The formulae might be referencing information and/or formulae on another page of your spreadsheet (which may or may not be hidden). It should be fairly simple to trace the path if this is the case.
The buttons might relate to macros, not formulae. If this is the case, I would suggest that you don't try and mess with them unless you know your way around visual basic. Or can recreate the macros from scratch (which may not be that difficult).
The formulae might be referencing information and/or formulae on another page of your spreadsheet (which may or may not be hidden). It should be fairly simple to trace the path if this is the case.
V8Dom said:
hi i have an excel spred sheet which has hidden formulars and hidden cololms which buttons relate to...i need to modifie it and cant... it s not locked.
im a dab hand at excel but not a professional at it..it needs someone who does it as a job or has studied it.any helpers out there please
thanks dom
pm me. im a dab hand at excel but not a professional at it..it needs someone who does it as a job or has studied it.any helpers out there please
thanks dom
If simple stuff will do for free, if time consuming then nominal charge.
Edited by amir_j on Wednesday 17th February 18:23
amir_j said:
V8Dom said:
hi i have an excel spred sheet which has hidden formulars and hidden cololms which buttons relate to...i need to modifie it and cant... it s not locked.
im a dab hand at excel but not a professional at it..it needs someone who does it as a job or has studied it.any helpers out there please
thanks dom
pm me.im a dab hand at excel but not a professional at it..it needs someone who does it as a job or has studied it.any helpers out there please
thanks dom
dom
If you can't get to a hidden row/column, hit F5 and enter the cell or range reference in the dialogue box that pops up, eg. A1 for single cell A:A for the whole column.
Once selected hit the key to the right of your right windows key, it'll bring up a context sensitive menu which should provide unhide as an option..
HTH..
Once selected hit the key to the right of your right windows key, it'll bring up a context sensitive menu which should provide unhide as an option..
HTH..
reminds me of the sheet the boss hid everyone's salary in, simply copied all and pasted into a new sheet
then the penny dropped that the token girl was on £15k, everyone else was on £23-25k and the boss on 30k
sales rep let slip that only a retard would be on less than £20k, cue the girl slapping him and storming out
then the penny dropped that the token girl was on £15k, everyone else was on £23-25k and the boss on 30k
sales rep let slip that only a retard would be on less than £20k, cue the girl slapping him and storming out
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff