Jul 11 2019 02:50 AM
Hi.
I have a list of account names in column A and values alongside in Column B (its a Trial Balance for the accounting fraternity) and I want to NAME each number cell in column B but using the text contained in column A as the name.
Is this possible ?
And is it possible to name all the cells in one go rather than having to do them one at a time ?
I've attached a file showing the spreadsheet
Many thanks
Jul 11 2019 03:00 AM - edited Jul 11 2019 03:01 AM
SolutionHere is step by step instruction https://www.engineerexcel.com/name-multiple-cells-quickly-using-create-selection/
Jul 11 2019 03:00 AM - edited Jul 11 2019 03:01 AM
SolutionHere is step by step instruction https://www.engineerexcel.com/name-multiple-cells-quickly-using-create-selection/